How to migrate data from mainframe db2 to postgresql without using ADF?

Question

How to migrate data from mainframe db2 to postgresql without using ADF?

Satya Sri 46

In my organization we have data in Mainframe DB2, would like to migrate data into azure postgres SQL. our client do not want us to use Azure Data Factory, is there any other pipeline to migrate the data from mainframe db2 to PostgreSQL ?

GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-12-03T21:58:10.037+00:00

Hi, @Satya Sri Thanks for posting your question in the Microsoft Q&A forum.
If understand correctly you want to migrate mainframe DB2 to Azure Postgres and you said your client does not want to go with ADF.
There is no direct migration tooling for this migration probably need to use the method of extracting data first into flat files and then import into PostgreSQL, however, I will check with the internal team and provide you with more details.

Regards
Geetha
GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-12-16T18:01:19.233+00:00

@Satya Sri Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

-Geetha

1 answer

Your answer

GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-12-03T21:58:10.037+00:00

Hi, @Satya Sri Thanks for posting your question in the Microsoft Q&A forum.
If understand correctly you want to migrate mainframe DB2 to Azure Postgres and you said your client does not want to go with ADF.
There is no direct migration tooling for this migration probably need to use the method of extracting data first into flat files and then import into PostgreSQL, however, I will check with the internal team and provide you with more details.

Regards
Geetha
GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-12-16T18:01:19.233+00:00

@Satya Sri Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

-Geetha

Answer 1

GeethaThatipatri-MSFT 29,587 Microsoft Employee Moderator

Hi, @Satya Sri Thanks for your patience on this.
If you can “afford” an offline migration -> It means, you will have downtime using any of the methods below.

Use Spark via Azure Synapse or Azure Databricks to connect with DB2 and move data to Azure PostgreSQL
Any ETL (IBM DataStage, Informatica PowerCenter, Talend, etc.. tool you already have knowledge that has connectors or connectors can be purchased for the source and target.
Extract the files via DB2 export to a share location, use Azure Databox to send it to MSFT dc and upload it to blob storage, import it via copy command to Azure PostgreSQL

I hope this information helps.

Regards
Geetha

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer.

GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-12-14T23:56:13.363+00:00

Hi, @Satya Sri We haven't heard back from you. Just wanted to check if you find the above reply useful. If yes, do click on the 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution.

Regards
Geetha

Share via

How to migrate data from mainframe db2 to postgresql without using ADF?

1 answer

Your answer