HP Systems Insight Manager - Manual (Page 12)

Importing items as Service Desk configuration items from the HP SIM database
12
Before performing these steps, the PostgreSQL ODBC driver should already be installed on the client that
will be used to run the data exchange tasks. Also, the HP Systems Insight Manager database should
already be configured for remote access.
1. Select Start>Settings>Control Panel>Administrative Tools>Data Sources(ODBC).
2. Click the System DSN tab.
3. Click Add.
4. Select the PostgreSQL Unicode driver, and then click Finish.
5. Enter a name for the DSN in the Oracle ODBC Driver Configuration window, for example,
HPSIM-
PGSQL
.
6. Enter the database name:
insight_v1_0
.
7. Enter the server name.
8. Specify the User ID and password.
9. Set the Port number to 50006.
10. To open the Advanced Options Window, click Datasource.
11. Change the Max Varchar field from 254 to 256.
12. To close the Advanced Options Window, click OK.
13. To close the PostgreSQL ODBC Driver Configuration window, click Save.
14. To close the ODBC Data Source Administrator Window, click OK.
Figure 3 PostgreSQL OBDC Configuration window.