Creating a database adapter

Create a database adapter to enable CADMATIC eShare to connect to an external database and access project data stored in that database.

Prerequisites

• You have the connection string that CADMATIC eShare needs for connecting to the database. For additional information, see Connecting to different types of databases. For a general reference, see http://www.connectionstrings.com.

Do the following:

1. Navigate to the project to edit, and then click Project Admin in the main menu. The project administration view opens.

2. Click Adapters and Data Sources. The Adapters and Data Sources configuration view opens.

3. Click Add.

4. In the Available Adapter Types section, select Database Adapter, and then click Create adapter.

5. In the Adapter section, enter a name and description (optional) for the adapter, and specify whether the adapter should be enabled.

6. In the Adapter Configuration section, specify the following settings:

   • Database type – Select the database type from the list: Microsoft SQL Server, OLE DB, ODBC, or Oracle.

     If you are creating a database adapter for Microsoft SQL Server, select the following:

     Show/hide details

     • Connection String Mode – Select the string mode.

       • If you select Advanced, specify the connection string to use for connecting to the database in the Connection String field. Select Test to check the connection string.

       • If you select Simple, you can specify a simple connection by filling and specifying the following information:

         • Server and instance – Enter the server and instance in format <server>\<instance name>.

         • Authentication – Select the authentication method. If you select Username & Password, enter them in the fields.

           You can select Test to check the connection string.

         • Database (optional) – You can specify the name of the database after successfully testing the connection string.

   • Connection string – Specify the connection string to use for connecting to the database.

   Note: CADMATIC eShare stores the connection string as plain text, so anyone who can access the project database can see the username and password from there.

   Note: Add Encrypt=True to connection string in SQL database adapters if you want to use encrypted connection.

7. Click Save.

Related Actions

• Creating a database adapter data source
• Creating a categorization data source
• Creating a document data source
• Creating an object attributes data source