Download
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.
download and unzip the driver, then double click on the installer package.
This will launch the installation wizard. Follow all the default settings and finally click Finish when the installation is complete.
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.
You can also open the ODBC Data Sources Administrator from the command line on Windows
- C:\Windows\SysWOW64\odbcad32.exe for the 32bit version
- C:\Windows\System32\odbcad32.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.
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-account.demo-game
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
Now Test your connection then Save it. Your connection is now ready to use in your tool of choice.