Connecting to Database Platforms Other Than ODBC - Intergraph Smart Instrumentation - Help

Intergraph Smart Instrumentation Help

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Help
Smart Instrumentation Version
13.1

This procedure describes the steps required to connect to a database platform such as Oracle or SQL Server. To connect to an external database platform, you must have access rights to the database server as well as the appropriate database drivers. You must also have the appropriate settings in the configuration files (for example, .ini files) and in the Windows registry.

  1. Select Actions > Define External Macro Source.

  2. In The Define External Macro Source dialog, from the Database type list, select the source database platform: Oracle or SQL Server.

  3. In the Server box, type the name of the server that you use to connect to the database server:

    • <alias name> — if you connect to Oracle

    • <server name> — if you connect to SQL Server

  4. In the Database schema logon name box, type the logon name required to connect to the source domain in the database server.

  5. In the Database schema logon password box, type the logon password required to connect to the source domain in the database server.