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.