Thread: Understanding plsqlODBC Configuration Options while connecting SSIS to Postgres database
Understanding plsqlODBC Configuration Options while connecting SSIS to Postgres database
Hi,
We have a BI tool extracting data from Postgres database . We are using connection string to connect to Postgres database from a BI tool. Connection is working fine. Successfully extracting data. However, the data extraction is slow. We want to have a deeper understanding of these Connection String options more so that performance can be improved
Help will be greatly appreciated
Connection String we are using:
"Driver={PostgreSQL Unicode};server="+ @[$Project::SourceServer] +";uid="+ @[$Project::SourceDBUserName] +";initial catalog="+ @[$Project::SourceDBName]+";database="+ @[$Project::SourceDBName] +";port="+@[$Project::SourcePort]+";sslmode=prefer;readonly=1;protocol=7.4;fakeoidindex=0;showoidcolumn=0;rowversioning=0;showsystemtables=0;fetch=1000;unknownsizes=0;maxvarcharsize=8000;maxlongvarcharsize=8190;debug=0;commlog=0;usedeclarefetch=1;textaslongvarchar=1;unknownsaslongvarchar=1;boolsaschar=0;parse=0;lfconversion=1;updatablecursors=1;trueisminus1=0;bi=2;byteaaslongvarbinary=1;useserversideprepare=1;lowercaseidentifier=0;d6=8;optionalerrors=0;xaopt=1"
This is the Postgres documentation that I referred for setting the values for connection options in the connection string
https://odbc.postgresql.org/docs/config.html
Thanks & Regards
Reshma G Toppo