Connecting to an Oracle Database

Make sure that the Oracle client is installed and that the services you want to connect to are available.

To connect to an Oracle database

1. Click FileNewData Connection.
2. In the Create Spatial Data Source dialog box, select Autodesk FDO Provider for Oracle and click OK.

   The Connection Editor is displayed to the right of the Site Explorer.

3. Enter the service to connect to.
4. Select Use Map Server Credentials or Use The Following Credentials.
5. Do one of the following:
   • If the database is set up to recognize them, select Use Map Server Credentials.
   • If the database requires them, select Use The Following Credentials and enter the user ID and password.
6. Select the data store from the list.
7. Click Test Connection.

   You should see a Successful Connection message.

   
8. On the Autodesk Infrastructure Studio toolbar, click Save to store this connection resource in the repository.

Other Controls in this Dialog Box

Version (Long Transaction)

If the provider provides this capability, select a long transaction name. A long transaction retains the context of an open transaction if it is interrupted and resumed.