Question
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
Thanks. I used ODBCQuery component and used microsoft DSN to connect to the db.
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
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
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
You'll likely want to use the SQLQuery component
http://help.openspan.com/80/Components/Using_the_SQLQuery_Component.htm