Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
RaviDharipuri
Contributor
Contributor
‎2023-05-31 10:38 AM

Importing data model and/or a single table definition into Compose data model

Currently there is only one way to import table definitions in compose that is through the Erwin data model import. 

there is no other alternative way to import data model and/or table definitions in the compose model using a csv file or Json or text file.

It would be a great feature to provide other alternatives. Let us know if this is achievable and if yes, when can we expect this to be available.?

we created a ticket as well, 00056233

Case Details - Qlik Community

Labels (1)
Labels
314 Views
0 Likes
1 Solution

Accepted Solutions
TimGarrod
Employee
Employee
‎2023-05-31 03:24 PM

There are actually 2 ways you can import a model besides Erwin. 

1 - Use the CSV feature to import a CSV that defines the entities and columns.  https://help.qlik.com/en-US/compose/May2022/Content/ComposeDWDL/Main/DW/Projects/CLI_for_ExportImpor... 

2 - Use the DISCOVER feature.  If you use DISCOVER, then the 'model' needs to exist as tables in a database.  Depending on what you use for modeling, you can create the objects in a SQL / mysql or in the target - create a 'landing' connection to that env. and then discover those tables  / foreign keys.   Compose will create a set of mappings when it does the discover, but those can easily be deleted by deleteing the ETL set that is generated. 

View solution in original post

288 Views
1 Reply
TimGarrod
Employee
Employee
‎2023-05-31 03:24 PM

There are actually 2 ways you can import a model besides Erwin. 

1 - Use the CSV feature to import a CSV that defines the entities and columns.  https://help.qlik.com/en-US/compose/May2022/Content/ComposeDWDL/Main/DW/Projects/CLI_for_ExportImpor... 

2 - Use the DISCOVER feature.  If you use DISCOVER, then the 'model' needs to exist as tables in a database.  Depending on what you use for modeling, you can create the objects in a SQL / mysql or in the target - create a 'landing' connection to that env. and then discover those tables  / foreign keys.   Compose will create a set of mappings when it does the discover, but those can easily be deleted by deleteing the ETL set that is generated. 

289 Views