Create And Link PostgreSQL Database With IGX Using Connection String
PostgreSQL is also known as Postgres, is an open-source and free relational database management system (RDBMS). It supports a wide variety of native data types.
Follow these simple steps below to create and link PostgreSQL database with IGX SCADA using Data Source Name (DSN).
- Open pgAdmin from the Start menu.
- In pgAdmin, expand the Servers tab on the left sidebar.
- Right-click on Databases, select Create and select Database.
- Give the database a name and click Save.
- Next, we will be using the Microsoft OLE DB Provider for ODBC (MSDASQL) for the connection string.
- From the Project Editor, click on Database task and create a new entry.
- Next, click the three dots at the end of the connection string box to open up the Data Link Properties window.
- Click on the Connection tab and select Use connection string.
- Copy the codes below and paste it in the Connection string box.
Driver={PostgreSQL Unicode};Server=IP address;Port=5432;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
- Make sure to change the values for Server, Database, Uid and Pwd accordingly. For more information about different types of drivers, connection strings and how to use them, click here.
- Next, click on Test Connection to test the connection to the database and click OK.
- Next, select the desired timer under Log Freq. This will define how frequent new data will be logged to that database.
- Save project.
Lastly, you may download a free copy of IGX Web SCADA and give it a try! Click here to view our online demo.
Please do not hesitate to contact us if you have any questions.