How to increase data transfer speed between SQL Server and Greenplum

asked 2019-02-07 10:49:03 -0500

siddhu gravatar image

updated 2019-02-08 10:21:05 -0500

metadaddy gravatar image

I have created one pipeline to transfer data between SQL Server and Greenplum using JDBC. It is more than 7 hours to transfer data. i have enable multinsert option and increase batch size. Just it is taking more time. Please tell how to increase the data transfer speed?

edit retag flag offensive close merge delete

Comments

Which origin are you using?

metadaddy gravatar imagemetadaddy ( 2019-02-08 10:21:16 -0500 )edit

Jdbc consumer

siddhu gravatar imagesiddhu ( 2019-02-10 01:50:30 -0500 )edit