Get column level details for source and targets

[Shajad]

Hello,

we are trying to get column level details like column name, data type etc from Qlik. Is there any API that can help us retrieve this information or is there any other way we can get this information.

Please let me know.

Thanks

[marksouzacosta]

Hi @Shajad,

In Qlik Sense Application Load Script, if you are using ODBC or OLEDB Connections, you can capture this information using the following statement:

SQLColumns
SQLColumns | Qlik Sense on Windows Help

You can also check for:

SQLTypes: SQLTypes | Qlik Sense on Windows Help

SQLTables: SQLTables | Qlik Sense on Windows Help

There is also a special API where you can get information this information, similar to what you see from the Data Connection Wizards. This has some limitations, and it is harder to use but if you are interested, I can send to you more details.

Regards,

Mark Costa

[Shajad]

Mark,

We are using Qlik Enterprise Manager. Do you know how we can do this in Enterprise Manager?

I apologize I am new to this. I was just pulled into a project to pull metadata from Qlik using REST API.

Thanks

[marksouzacosta]

These SQLColumns you can use from Qlik Cloud or Enterprise Management in Qlik Load Script. You can reload the application and store this information in CSV files for example.

Qlik .NET SDK have methods ready to collect this information as well, like the GetDatabaseTableFields method from the App class. https://help.qlik.com/en-US/sense-developer/May2024/Subsystems/NetSDKAPIref/Content/Home.htm

You can also use the Qlik Engine JSON API - I never implemented this one:
List the fields in a table for a ODBC, OLEDB or CUSTOM connection | Qlik Sense for developers Help

Regards,

Mark Costa

[sureshkumar]

Hello @Shajad 

Try ExportAll API
https://help.qlik.com/en-US/enterprise-manager/May2024/Content/EnterpriseManager/EnterpriseManager_A...

If the above API doesn't help then go to Replicate Server

Open CMD-->run as Administrator-->Route to bin folder [ex: cd C:\Program Files\Attunity\Replicate\bin]

Enter - Repctl.exe dumpmetadata sqlite_file="Product_dir\data\tasks\task_name\dynamic_metadata.sqlite"

Ex: Repctl.exe dumpmetadata sqlite_file="C:\Program Files\Attunity\Replicate\data\tasks\Test_Task\dynamic_metadata.sqlite"

New folder will be created inside Task_name folder--> where you will see Table definition defined at the source and Target.

Hope it helps.

Regards,

Suresh