topic Re: How to load data load from DB2 iSeries Views to the target Snowflake? in Qlik Replicate

How to load data load from DB2 iSeries Views to the target Snowflake?

satyender — Fri, 18 Nov 2022 16:54:57 GMT

Hello,

Greetings!

Any idea how to load the data from DB2 iSeries views to Snowflake?

In the Table Selection tab I am not seeing the Views to select.

-Satyender

Re: How to load data load from DB2 iSeries Views to the target Snowflake?

Frank_S — Fri, 18 Nov 2022 17:06:32 GMT

Hi @satyender

Please check the following help page for additional information on configuring your requirement as needed.

https://help.qlik.com/en-US/replicate/November2022/Content/Replicate/Main/IBM%20DB2%20for%20iSeries/db2.htm#Using%20IBM%20DB2%20for%20iSeries%20as%20a%20source

Kind regards..

Re: How to load data load from DB2 iSeries Views to the target Snowflake?

satyender — Fri, 18 Nov 2022 17:18:09 GMT

Thanks Frank for your response.

The connection is already set to the DB2 iSeries and able to get the Tables. The question is how to get the Views data from DB2 iSeries. As I am not seeing the option of Views in the Table Selection tab in Qlik Replicate.

Re: How to load data load from DB2 iSeries Views to the target Snowflake?

lyka — Fri, 18 Nov 2022 17:25:22 GMT

Hello,

Views can only be selected from the following endpoints:

Teradata
Amazon Redshift
PostgreSQL
MySQL
SAP Sybase ASE
IBM DB2 for LUW
IBM DB2 for z/OS
Oracle
Microsoft SQL Server
ODBC with CDC
ODBC

https://help.qlik.com/en-US/replicate/May2021/Content/Global_Common/Content/SharedEMReplicate/Design%20Tasks/tasks_addTables.htm#ar_tasks_1150461142_1281452

Thanks

Lyka

Re: How to load data load from DB2 iSeries Views to the target Snowflake?

satyender — Fri, 18 Nov 2022 17:34:21 GMT

Thank you Lyka for your response.

Hmm.. Now I can see the reason why I am not able to see the Views in the Table Selection. 😞

Re: How to load data load from DB2 iSeries Views to the target Snowflake?

john_wang — Sun, 20 Nov 2022 13:37:35 GMT

Hello @satyender , copy @lyka ,

Totally agree with Lyka.

If you still want to replicate VIEW from DB2i in Full Load ONLY task, then you may take steps:

1- create a 64-bit ODBC DSN

2- users the generic ODBC DSN in source Endpoint. now you can see both tables/views are visible in task design, as below:

Hope this helps.

Regards,

John.

Re: How to load data load from DB2 iSeries Views to the target Snowflake?

satyender — Tue, 22 Nov 2022 18:53:06 GMT

Thank you @john_wang for your reply.

I will try this option.

Re: How to load data load from DB2 iSeries Views to the target Snowflake?

satyender — Wed, 23 Nov 2022 00:10:51 GMT

The ODBC worked like a charm. But, unfortunately I am unable to run the task as our dept. does not have an ODBC license.

Thanks so much @john_wang for the tip.

-Satyender

Re: How to load data load from DB2 iSeries Views to the target Snowflake?

john_wang — Wed, 23 Nov 2022 08:38:43 GMT

Hi @satyender ,

You are right. The generic ODBC source/target EndPoint requires dedicated license token.

Regards,

John.