public inbox for [email protected]  

help / color / mirror / Atom feed

From: Reshma Toppo <[email protected]>
To: [email protected] <[email protected]>
Subject: Understanding plsqlODBC Configuration Options while connecting SSIS to Postgres database
Date: Fri, 20 Aug 2021 13:40:13 +0000
Message-ID: <SJ0PR06MB7210BBA0931832A4999E078D80C19@SJ0PR06MB7210.namprd06.prod.outlook.com> (raw)

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
=============Notice to Recipient: This e-mail transmission, and any documents, files or previous e-mail messages attached to it may contain information that is confidential or legally privileged, and intended for the use of the individual or entity named above. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that you must not read this transmission and that any disclosure, copying, printing, distribution or use of any of the information contained in or attached to this transmission is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify the sender by telephone or return e-mail and delete the original transmission and its attachments without reading or saving in any manner. Thank you. =============

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Understanding plsqlODBC Configuration Options while connecting SSIS to Postgres database
  In-Reply-To: <SJ0PR06MB7210BBA0931832A4999E078D80C19@SJ0PR06MB7210.namprd06.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox