Data connector for PostgreSQL

The connector for PostgreSQL enables you to directly import a PostgreSQL dataset to InfoSum Platform. 

Before starting, you will need the following information to hand:

  • Database address, including a port number. If the port number is omitted then the default port for PostgreSQL, 5432, will be used.
  • Database name.
  • Table name.
  • Username.
  • Password.

PostgreSQL tables should be imported with their correct types where possible. Our categorisers only support strings, bools and integers.

To configure a connection, login to the Platform if you haven't already and either create a dataset or access the Bunker of an existing dataset. Once you're in the Bunker, select Import a dataset or use the Import tab, and locate the PostgreSQL connector as shown below. 

 

Click Connect and enter the credentials.  

 

You will then be taken to the Auth stage, where you can specify the SSL mode. Next, define what will be imported - either by table name (e.g. dummy_data.drone1) or with a custom SQL query.

 

A subset of the data will then appear as a preview. You can perform some minor manipulations as this point, such as selecting which columns to import, renaming columns and excluding rows. 

When you're happy with the preview, accept the settings and select an import configuration, then you'll be taken to the Import Wizard. This will show how our Platform has understood your dataset and mapped columns into our Global Schema.  

 

If this looks correct, accept the Wizard Settings, otherwise untick the boxes so they can be correctly mapped during the later normalisation phase.