DataFlux Data Management Studio 2.6: User Guide

Adding ODBC Connections to SAS Web Infrastructure Platform Data Servers

The SAS Web Infrastructure Platform Data Server is included in SAS deployments for use as transactional storage by SAS middle-tier software and some SAS solutions software. This server is based on PostgreSQL database software. The server is configured specifically to support SAS software.

A SAS Web Infrastructure Platform Data Server can be used to host a DataFlux repository. The first step is to create an ODBC PostgreSQL connection to an SAS Web Infrastructure Platform Data Server. You can then use this connection to create a DataFlux repository on that server.

Perform the following steps to add an ODBC PostgreSQL connection to a SAS Web Infrastructure Platform Data Server.

1. Click the Data riser on the DataFlux Data Management Studio desktop.
2. Expand the Data Connections folder.
3. Select the New Data Connection menu in the Data Connections pane on the right. Then select ODBC Connection to display the ODBC Data Source Administrator dialog.
4. Select the type of connection that you want to establish. For example, you can click System DSN to create a connection to a data source that all users on the machine can access. The System DSN tab is shown in the following display:

   

5. Click Add to select the driver for your data source. Select the DataFlux 32-bit Postgres Wire Protocol driver as shown in the following display.

   

6. Click Finish. A setup dialog displays for the selected driver (connection type).
7. Enter a name, a description, and other attributes into the setup dialog. We recommend that you avoid using special characters such as quotation marks in your data source names. The Port Number for a Postgres Wire Protocol connection must be 10442, as shown in the next figure.
   

   
   
   

8. Click OK save the connection and return to the ODBC Data Source Administrator dialog. The new connection is included on the System DSN tab of that dialog.
9. Click OK to close the ODBC Data Source Administrator dialog and return to the Data riser.
10. Refresh the Data riser in order to see the new connection in the Data Connections folder in the left pane. Select View, and then select Refresh from the main menu. The new connection should appear in the Data Connections folder.
11. To verify a connection, double-click the connection in the Data Connections folder in the left pane. Enter any required credentials. If the connection works, you will be able to see tables, fields, and other attributes in the right panel.

To use a PostgreSQL connection to create a DataFlux repository on a SAS Web Infrastructure Platform Data Server, see Adding a DBMS Repository for the Client.