Trying to connect to RDS Postgres on Amazon AWS

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ep_datastage
Participant
Posts: 24
Joined: Wed Apr 16, 2014 11:11 am
Location: United States

Trying to connect to RDS Postgres on Amazon AWS

Post by ep_datastage »

Can I connect directly to RDS Postgres in Amazon AWS ? I have DS 11.3. If so, which type of connector do I use ? Thanks Rick
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Try configuring your ODBC driver in the .odbc.ini file if your DataStage server is on UNIX or Linux. There is a PostgreSQL Wire Protocol driver available. Then use the ODBC Connector stage in your jobs. Make sure there aren't any firewalls blocking the database connection.
Choose a job you love, and you will never have to work a day in your life. - Confucius
ep_datastage
Participant
Posts: 24
Joined: Wed Apr 16, 2014 11:11 am
Location: United States

Post by ep_datastage »

Thanks. I had been using a jdbc connection for regular postgres, but are you saying that I should try the ODBC connection for RDS Postgres ?
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

I was just pointing out that a PostgreSQL ODBC driver is available, and therefore I would expect it to work. It should not matter that the database is hosted on Amazon. I have not connected to that type of database myself but I have over the years used many other built in ODBC drivers with the Connector stage. If you have already had success with a JDBC connection then you might as well continue using it.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply