Brocade Network Advisor IP User Manual 19
53-1003056-01
PostgreSQL database 1
The ODBC Data Source Administrator dialog box displays.
6. Click the System DSN tab.
7. C l i ck 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 Por t Number field.
16. Enter the database user name in the User Name field.
17. Enter the password in the Password field.
18. Click Te st to test the connection.
19. Click OK on the Connection Test dialog box.
20. Click Save.
21. Cl ick 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