Manage data connections - HxGN SDx - Update 64 - Administration & Configuration

The Data Connections page allows you to add database connections. The database connections are used to import domain tags from existing databases.

Add data connections

1. Log on to HxGN SDx Dashboard.

2. Click Data Capture Administration > Data Reader Patterns.

3. Click Data Connections to view the existing data connections in an item list.

4. Click Add Data Connection to open the Create Data Connection dialog box.

5. Type a name for the data connection in the Name box.

6. Type a name for the domain in which the domain tags extracted using this data connection are stored.

   

   • You should not type a domain name that already exists in the database. The domain typed in the Domain box is created in database after the data connection is saved.

     • It is recommended you restrict the number of characters in the domain name so that it does not exceed 10 characters.

7. Select a Connection Type from the list. To use a custom database as the Connection Type, you must:

   • Create a custom assembly and add it to Settings.xml. This custom assembly must refer to Intergraph.SPFN.Server.dll.

   • Ensure that the custom assembly contains a class that inherits Intergraph.SPFN.Server.Data.SPFNBaseProvider, available in Intergraph.SPFN.Server.dll, and override the methods as required.

   • Ensure that the instance of this class is used by Data Capture for all the database operations on the custom connection type.

   

   • If the Connection Type is EXCEL, you must type the Provider Name for the version of Microsoft Excel installed on your computer, in the Provider Name box.

   • If the Connection Type is MSACCESS, you must type the provider name for the version of Microsoft Access installed in your computer, in the Provider Name box. Click Browse access file to provide the File Path of the Microsoft Access file.

   • The default value for Provider Name is Microsoft.ACE.OLEDB.12.0.

   • If the Connection Type is CUSTOM, you must type the connection string of the database in the Connection String box.

8. Type the database instance name in the Database Source box.

   

   • If you use the Oracle database, type the Oracle instance name in the Database Source box.

   • If you use the SQL Server database, type the SQL server name in the Database Source box.

9. Type the database server name in the Database Name box.

10. Type the username and password for the user account that has access to the database.

• If you use the Oracle database, you must use the dump file name as the username. For example, if the dump file name is EQUIPLIST_Data.dmp, the username must be equiplist_data.

• If you use the SQL Server database, you must use the .bak file name as the username. For example, if the bak file name is PUMPLIST_Data.bak, the username must be PUMPLIST_Data.

• Select a data connection and click Edit Data Connection to modify the data connection details.

• You can select one or more data connections and click Delete Data Connections to remove the data connections from the list. To do this, you must hold down the CTRL key while you select each data connection that is to be deleted.