Create a New Destination - Intergraph Smart Reference Data - Version 10.2 - Customization & Programming - Hexagon

Intergraph Smart Reference Data Integration (10.2)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
10.2

To keep track of what was transferred from Smart Reference Data to which Smart 3D instance, each export job is assigned to a particular destination. These destinations represent the Smart 3D catalog databases with specific connection information, like the catalog server, catalog schema server, catalog database, and the catalog schema database. The destinations are defined on the Integration > Smart 3D > Smart 3D Transfer Jobs > Destinations Destinations screen.

84

To find out what information to enter on this screen, you can run Modify Database and Schema Location from Start > All Programs > Intergraph Smart 3D > Database Tools.

85

Oracle

  1. Enter the name of the destination in the Destination field.

  2. In the Host Name field, enter the Smart 3D machine name where the Smart Reference Data Listener is running. This can be a middleware node and does not necessarily need to be on the same computer as the Oracle server that the Smart 3D database is running.

  3. In the Site Server field, enter the TNS Alias of the database instance.

  4. In the Site DB field, enter the database schema.

  5. In the DB Provider field, select Oracle for an Oracle Smart 3D database.

  6. In the Catalog DB field, enter the database schema.

    The values entered in the Host Name, Site Server, Site DB, DB Provider, and Catalog DB fields will be used instead of the config items for the host and plant name, if you are using Smart 3D V2019. For previous Smart 3D versions, these values are not used by the load API.

  7. In the Catalog Server field, enter the node/machine where the catalog database is running.

  8. In the Catalog Schema Server field, enter the node/machine where the catalog schema database is running.

  9. In the Catalog Schema DB field, enter the container for the schema data that is supplied by Smart Reference Data, like custom attributes and codelists.

The values entered in the Catalog Server, Catalog Schema Server, and Catalog Schema DB fields will be checked at the analyze log stage. You must enter these values if the ANALYZE_BL_LOG parameter is set to Y; otherwise, you do not have to.

SQL Server

  1. Enter the name of the destination in the Destination field.

  2. In the Host Name field, enter the Smart 3D machine name where the Smart Reference Data Listener is running. This can be a middleware node and does not necessarily need to be on the same computer as the SQL Server that the Smart 3D database is running.

  3. In the Site Server field, enter the name of the server instance.

  4. In the Site DB field, enter the database name within the server instance (for example, SITE_SDB).

  5. In the DB Provider field, select MSSQL.

  6. In the Catalog DB field, enter the database name within the server instance (for example, SDBSPECS_CDB).

The values entered in the Host Name, Site Server, Site DB, DB Provider, and Catalog DB fields will be used instead of the config items for the host and plant name, if you are using Smart 3D V2019. For previous Smart 3D versions, these values are not used by the load API.