1. Launch Control Panel--> System and Security--> Administrative Tools --> ODBC Data Sources --> System DSN tab and click on the Add button
2. Select "Amazon Redshift (x64)" driver:
3. Name the data source appropriately and enter the name/IP address of the Amazon Redshift server along with username and password details. Click on Test ... button to see if the connection succeeds. If the connection fails, contact your database administrator. Enter details of your default database:
5. Within Statistica (or Enterprise Manager), create a new ADO.NET Database Connection. From Statistica desktop, the user may choose File-->External Data-->Query-->Create. Inside Enterprise Manager, right-click on the Data connections and click on New ADO.NET Database Connection:
6. Change the data source:
7. Select "Microsoft ODBC Data Source (ODBC) as the Data source and "Amazon Redshift ODBC DSN" as data source specification:
8. Click the "Test Connection" button and if the test is successful, click "OK". Then name the database connection.
The Amazon Redshift database can now be used to create data configuration. See steps 8 through 12 of this knowledge base article: https://support.tibco.com/s/article/How-to-pull-data-from-Teradata-into-Statistica-via-ODBC
Note: The ODBC connector does not support generic SQL filtering. If SQL filtering is necessary, please use the PostgreSQL driver (https://support.tibco.com/s/article/How-to-query-data-from-Amazon-Redshift-into-Statistica-Statistica-Enterprise-for-analyses-using-PostGres-ODBC-Driver)