Installing the odbc driver on linux systems – Brocade Network Advisor SAN User Manual v12.3.0 User Manual
Page 75
Brocade Network Advisor SAN User Manual
23
53-1003154-01
PostgreSQL database
1
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.
Installing the ODBC driver on Linux systems
To install the ODBC driver and , complete the following steps.
1. Execute the following command in the terminal:
> su
>chmod 777 edb_psqlodbc.bin
> ./edb_psqlodbc.bin
2. On the Setup psqlODBC screen click Next.
TABLE 6
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