Truedat Docs
Search…
Files Description
Following is the description of the files used in the different Data Catalog APIs

Structure File

Contains the list of data assets to be loaded into truedat.
Text
Description
Required
group
Group to which the structure belongs. In the case of an Oracle DB it could be the schema, in the case of a Microstrategy report it would be the document, etc. All the structures of the same group must be sent together since when receiving a group it will be inferred that those structures of the same group that are not in the file have been deleted
name
Structure name. Depending on the type of structure, it will be the name of the table, file, report, etc.
external_id
External identifier of the structure. It allows us to identify the structure from the origin of the metadata in order to make successive queries. Additionally, this external identifier is necessary to enable navigation between traceability and catalog.
description
Optional description of the structure that provides information to the users of the Data Dictionary
type
It allows us to specify what type of structure we are dealing with: Table, Report, File, etc.
class
Indicates if the structure belongs to
Possible values:
  • "": An empty string indicates that the structure is no defined class
  • "field": Asset is a field of another structure. Usually columns in a table
  • "table": Asset has children with class field.
m:*
It is allowed to enter variable fields to be decided by each connector. These fields can later be used to be displayed in the listings or to order them.
m:data_type_class
ype mapping to be used at points in the application where it is necessary to have a standard data type. For example, this happens to be able to show the quality operators that apply to the structure.
Possible values:
  • boolean
  • date
  • number
  • string
  • timestamp
File example:
"group";"name";external_id;"description";"type";"ou";m:varnum
"MIHI";"CLIENTES";"MIHI.CLIENTES";"Tabla que contiene información de clientes";"tabla";"truedat";"1"
"Riesgos";"Primas Vencidas";"Riesgos.Primas Vencidas";"Informe donde se cálcula el importe de las primas vencidas";"informe";"";"2"

Data Structures Relations

Contains the parent / child relationship of the structures, if any, which allows navigation between structures.
Field
Description
Required
parent_external_id
Identify the external identifier of the parent
child_external_id
Identify the external identifier of the child
type
Identify the type of relationship between the father and son. If you want to use this functionality, you must register the type of relationship before including that type in this file.
File example
"parent_external_id";"child_external_id";"type"
C.R. Analitica (S.M.).Objetos públicos/Informes/Cuadro de seguimiento;C.R. Analitica (S.M.).Actividades;
C.R. Analitica (S.M.).Cuenta de Resultados Analítica pdf;C.R. Analitica (S.M.).Analisis Agencias_pdf;
C.R. Analitica (S.M.).Cuenta de Resultados Analítica pdf;C.R. Analitica (S.M.).Analisis Agencias_Sin tradicional_pdf;
C.R. Analitica (S.M.).Cuenta de Resultados Analítica pdf;C.R. Analitica (S.M.).Costes Unitarios_pdf;includes