I am new to Qlik Replicate and trying to understand some of the functionalities. Our Source is Informix and Target is Azure SQL.
I want to generate the (transformed) DDL which will be used to create objects in SQL Server(Tables/PK/FK/Indexes). Does the tool allow it using some API? Can you please let me know how to do it, if the tool allows?
The only way I am aware of is to run the task with verbose logging for METADATA_MANAGER, TARGET_LOAD. These should write the create table SQL statements to the task log.
I don't know of a way to generate the create table DDL for a target without running the task.
If this is a feature you would like to see in the product, I encourage you to please submit a feature request here which goes to our Product Management team. Other users will have the opportunity to vote on it to increase the chances at adoption and to set the priority: https://community.qlik.com/t5/Ideas/idb-p/qlik-ideas
The only way I am aware of is to run the task with verbose logging for METADATA_MANAGER, TARGET_LOAD. These should write the create table SQL statements to the task log.
I don't know of a way to generate the create table DDL for a target without running the task.
If this is a feature you would like to see in the product, I encourage you to please submit a feature request here which goes to our Product Management team. Other users will have the opportunity to vote on it to increase the chances at adoption and to set the priority: https://community.qlik.com/t5/Ideas/idb-p/qlik-ideas
