You want to import data from CSV files but you don't have a template?
Whatever the targeted module, you must provide the following information to define or reference DataGalaxy's object :
- The object's "Path": is the full object hierarchy separated by "\" characters, ending with its name, for example \HUMANRESOURCES\DEPARTMENT\DEPARTMENTID
- The "type" of the object's "path" : identifies the types of the objects defined in the "path", separated by "\" characters. A type can be concept, business term, indicator, ... Please refer to this article describing the meta model object typologies to learn more about object types. An example of a "type" value of a "path" can be \Model\Table\Column
You can find in attachment examples of files for all our modules, by family of objects, as well as relations.
If you wish to get import templates with custom attributes as configured in your environment, please use the following procedure:
- Access the module you wish to import your data into.
- If the module is empty, create some data.
- Click on export data.
- Reuse the export template and then import data again.
To learn more about importing data with DataGalaxy, you can read the following article:
The Import Logic in DataGalaxy
Attachments from the original article (21 sample CSV files): they must be re-uploaded here, they were not carried over by the migration.
- Sample-DataProcessing-2-In.csv (1.68 KB)
- Sample-DataProcessing-1-General.csv (334 Bytes)
- Sample-Dictionary-Azure Client Data-1-Containers.csv (299 Bytes)
- Sample-DataProcessing-4-DataProcessingItems.csv (1.51 KB)
- Sample-DataProcessing-3-Out.csv (402 Bytes)
- Sample-Dictionary-Azure Client Data-2-Structures.csv (19 KB)
- Sample-Dictionary-Azure Client Data-4-PK.csv (11.7 KB)
- Sample-Dictionary-Azure Client Data-3-Fields.csv (102 KB)
- Sample-Dictionary-Enterprise DWH-1-Structures.csv (1.76 KB)
- Sample-Dictionary-Azure Client Data-5-FK.csv (25.3 KB)
- Sample-Dictionary-Enterprise DWH-3-PK.csv (801 Bytes)
- Sample-Dictionary-Enterprise DWH-2-Fields.csv (19.7 KB)
- Sample-Dictionary-Enterprise DWH-4-FK.csv (1.35 KB)
- Sample-Glossary-1-General.csv (24.2 KB)
- Sample-Glossary-2-Linked-Objects.csv (9.65 KB)
- Sample-Usages-1-General.csv (1.05 KB)
- Sample-Usages-2-Linked-Objects.csv (2.76 KB)
- Sample-Dictionary-0-Source-Multi.csv (771 Bytes)
- Sample-Dictionary-Big Query NoSql-1-Containers.csv (147 Bytes)
- Sample-Dictionary-Big Query NoSql-2-Structures.csv (649 Bytes)
- Sample-Dictionary-Big Query NoSql-3-Fields.csv (2.07 KB)