SQL Server Source to ODBC(IBM DB2 for iSeries) Target has error: Fail to get schema for table

[DuongNguyen]

I encountered this error

but when I check if AS400 is the source, qlik sees the schema and table

can you help me?

[john_wang · Accepted solution]

Hello @DuongNguyen ,

Thanks for the post!

Seems we cannot find any subscription from Qlik System yet, looks like this is a PoC project. I'd like to propose:

1- Please contact your region sales manager or account manager for help, it's better to proceed with the PoC under Qlik technical support (pre-sales team) to avoid try-and-error on variable issues.

2- Please be mind that unless enabled through Professional Services and approved by your Account Manager, the ODBC target e...

3- Try to set the syntax to GenericWithoutSchema , The steps and a sample:

      (1) Open DB2i ODBC target endpoint

      (2) Go to Advanced tab

      (3) Browse the Provider syntax

      (4) Choose GenericWithoutSchema and run task again.

Hope this helps.

Regards,

John.

[DuongNguyen]

@john_wang  thank you so much!