Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Slow insertion in Amazon Redshift

I'm testing the BO Data Services as ETL tool for data extraction having as Amazon Redshift destination. However, the performance for the inserts into Redshift is very bad.

On average, the Data Services inserts about 5 records per second. (I made tests with Talend and it already entered 22000 reg / sec)


We have a BODS running on the Linux platform x64.

For connection, we use an ODBC connection created and configured as Amazon recommendations.

http://docs.aws.amazon.com/redshift/latest/mgmt/install-odbc-driver-linux.html

Does anyone have any idea how I can provide more performance in data inserts in Redshift using bods?

Thanks

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question