Downloadpostgres-logo

Before you can connect to your data in the deltaDNA data warehouse you will need to download a PostgreSQL ODBC driver.

We will setup a connection on a Windows 8.1 PC in this example, so navigate to the /msi folder and scroll to the bottom of the page where the most recent downloads are located.

There will be two downloads for each release of the PostgreSQL ODBC driver, a 32bit driver and a 64bit one.

You will need to make sure you download the driver that corresponds to the tools you are using. For example, if you are only using a 32bit version of Microsoft Excel you will need to select the 32bit driver (the one that isn’t marked with x64 in its name). If you try and use the wrong one you will get “Platform Compatibility” error when you try and create a connection. If that happens just go to Control Panel >> Programs and Features and Unistall the incorrect one and start over.

postgres_download

download and unzip the driver, then double click on the installer package.

postres_installer

This will launch the installation wizard. Follow all the default settings and finally click Finish when the installation is complete.

postgres_completed

Connect

Now that  the PostgreSQL driver is installed you are ready to set-up a DSN connection that can be used by a wide variety of tools.

Navigate to Control Panel >> Administrative Tools and open the ODBC Data Sources manager.

Please note, there may be a 32 bit and a 64 bit version of the ODBC Data Sources manager on your PC, make sure you use the one that corresponds to the version of the PostgreSQL ODBC driver you downloaded and the tools you will be using to connect to the deltaDNA data warehouse.

odbc

You can also open the ODBC Data Sources Administrator from the command line on Windows

  • C:WindowsSysWOW64odbcad32.exe  for the 32bit version
  • C:WindowsSystem32odbcad32.exe for the 64bit version.

Stay on the User DSN tab if you wish the connection to be private to your account, or select the System DSN tab if you want all users on this PC to access the connection. Press the Add button and scroll down the Create New Data Source list until you find the PostgreSQL Unicode option. Select it and Finish.

PostgresDataSource

When you click Finish, a new panel will open. You will need to populate 5 values in this panel.

Database:

This is the name of the account and game that you want to connect to as shown in the URL in your browser address bar whilst logged in to deltaDNA.
NB: Please note the full stop between the Account Name and the Game Name 
demo-co.my-demo-game

DBeaverDatabaseSchema

Host:
data.deltadna.net 

Username:
This is the username you use to login to the deltaDNA platform.

Password:
This is the password you use to login to the deltaDNA platform.

Description:
A friendly description that you will use to identify this connection in the tools you use to connect to your data.

NB: Leave the Port number set to its default value of 5432

ODBCconnected

Now Test your connection then Save it. Your connection is now ready to use in your tool of choice.