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

RaviDharipuri — Fri, 14 Mar 2025 20:49:07 GMT

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

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

TimGarrod — Wed, 31 May 2023 19:24:11 GMT

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_ExportImport_Objects.htm#anchor-4

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.

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

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

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