Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Convert DB2 database to PostgreSQL.

Can I convert a DB2 database > 1GB,hundreds tables to PostgreSQL,with TOS DI?Just the tables data,no stored procedures,no triggers etc.
What is the best method to do that? I'm using TOS DI for the first time.
Labels (2)
1 Reply
Anonymous
Not applicable

Hi,
With community version, you have to create many subjobs for the mapping of each table from DB2 to PostgreSQL.
With Enterprise subscription version, you just need to create only one subjob for the mapping of all tables due to the dynamic schema, dynamic schema feature is not available in community version, please read the following page to know more about this feature.
https://help.talend.com/pages/viewpage.action?pageId=5671283

Best regards
Sabrina