How to connect to postgresql db in OpenSpan
How can we connect to postgresql db in OpenSpan. My requirement is to insert data into one of the table using automation.
Accepted Solution
Cognizant
US
Thanks. I used ODBCQuery component and used microsoft DSN to connect to the db.
Pegasystems Inc.
US
You'll likely want to use the SQLQuery component
http://help.openspan.com/80/Components/Using_the_SQLQuery_Component.htm
1986
US
Hi Vinit,
What do u mean by Microsoft DSN.?
Can you please let me know what connection string or Data source Name , we need to give in "Connection" tab of Data Link Properties window.
Thanks,
Param
Cognizant
US
you need to setup data source name in odbc. search with odbc in search box of start. Open it and then there you can configure data source name. Once you configure DSN, it will be available in robotics studio to use
1986
US
Thanks for that Info Vinit. it worked well.
I have downloaded the ODBC connector for Postgres, then created ODBC data Source. Then in ODBCConnector Component, on Connections tab I got the Data source name that I created in previous step as option in Data sources dropdown.
Param