PostgreSQL database

1

The ODBC Data Source Administrator dialog box displays.

6.Click the System DSN tab.

7.Click Add.

The Create a New Data Source dialog box displays.

8.Select PostgreSQL Unicode.

9.Click Finish.

The PostgreSQL Unicode ODBC Driver (psqlODBC) Setup dialog box displays.

10.Enter a name for the data source in the Datasource field.

11.Enter the description of the database in the Description field.

12.Enter the name of the database in the Database field.

13.Select enable or disable from the SSL Mode list to specify whether or not to use SSL when connecting to the database.

14.Enter the IP address or host name of the Management application server in the Server field.

15.Enter the database server port number (default is 5432) in the Port Number field.

16.Enter the database user name in the User Name field.

17.Enter the password in the Password field.

18.Click Test to test the connection.

19.Click OK on the Connection Test dialog box.

20.Click Save.

21.Click OK on the ODBC Data Source Administrator dialog box.

22.To export data, select Data > Import External Data > New Database Query and complete the steps in the Data Connection Wizard.

Connecting to the database using the ODBC client (Linux systems)

NOTE

The ODBC driver is not supported on 64-bit Linux systems.

You must have the Open Database Connectivity (ODBC) driver to allow remote clients to export data and generate reports. The ODBC driver enables you to configure the data source name (DSN) for the Network Advisor database.

Before you install the Linux ODBC driver, download the ODBC RedHat Package Manager (RPM) file based on the Linux version.

TABLE 8 ODBC RedHat Package Manager (RPM) file requirements

Linux version

RedHat Package Manager file

 

 

SUSE

Rpm –I unixODBC-2.2.12-197.17.i586.rpm

 

 

RedHat or Oracle Enterprise

Rpm –i unixODBC-2.2.11-1.i386.rpm

 

 

Brocade Network Advisor IP User Manual

19

53-1003056-01

 

Page 71
Image 71
Brocade Communications Systems IP250 user manual Odbc Data Source Administrator dialog box displays, Suse