This article guides us through establishing a connection and extracting the data from the Aurora Postgres Database from Statistica. The requirement to extract data from a Aurora Postgres Database SQL Version 12.13, is supported through driver installation, and the driver details are provided here. 

Driver information

We have used the ODBC driver provided for PostgreSQL

Create a database connection to retreive data like we create in Enterprise Manager. We can also specify the Database Connection in the Writeback to Database node and then specify the table we want to create or use. 

We can leave the Database name set to Postgres since that is the default - add the server name, which is the link below the Endpoint, highlighted in green in 3nd screenshot below. Username and password you will create when first creating the database instance in AWS. 

An endpoint can be obtained from AWS Postgres instance details. These are where our Postgres Aurora Instance is located on AWS and work as host address to connect them :

Port is the default, we need to allow a firewall exception on the machine where you're creating the DB Connection:

On the Enterprise end, we can select the OLE DB connection type, and select the OLE DB Provider for ODBC Drivers.

Connection String we used in Enterprise Manager - Provider=MSDASQL.1;Password=*****;Persist Security Info=True;User ID=statistica;Data Source=PostgreSQL30;Initial Catalog=postgreso



And then put in the connection info for the ODBC Connection (see above)


 

We can perform below on Aurora Postgres In Statistica 14.0.1.25:

1) Write a spreadsheet into a new table in the DB

2) Query the database as part of an Enterprise Manager Data Connection

3) Drop and recreate the table when writing back new data