Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
Views can only be selected from the following endpoints:
Thanks
Lyka
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. 😞
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.
Hi @satyender
Please check the following help page for additional information on configuring your requirement as needed.
Kind regards..
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.
Hello,
Views can only be selected from the following endpoints:
Thanks
Lyka
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. 😞
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.
Thank you @john_wang for your reply.
I will try this option.
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
Hi @satyender ,
You are right. The generic ODBC source/target EndPoint requires dedicated license token.
Regards,
John.