Source Data Connection Dialog Box - Intergraph Smart Instrumentation - 13.1 - Administration & Configuration - Hexagon PPM

Intergraph Smart Instrumentation Administration

PPMProduct
Intergraph Smart Instrumentation
PPMCategory_custom
Administration & Configuration
Version_SPI_custom
13.1

Enables you to select a database type and connect to an existing source domain when using that source domain to initialize a new domain.  Certain options in the dialog box change dynamically according to the source database type that you select.  Prior to using the dialog box options, make sure that the source Smart Instrumentation database is of the same version as the database where you are creating the new domain.

Database type — In accordance with your target database platform, select the source database type.  The following options are available:

  • SQL Server — Select if the target database is SQL Server.

  • Oracle — Select if the target database is Oracle.

  • SI Source — Select if the target database is a Smart Instrumentation .ddti seed file.

  • A DDTI file contains data that is not database dependent. The data in a DDTI file can be imported to any database format (MSS or Oracle) irrespective of its source.

    A DDTI project package file is not Smart Instrumentation version dependent. You can import and export from any version higher than 2018 to any other version of Smart Instrumentation version higher than 2018. For example 2018 to 14.0, 13.1 to 2018, and any later versions. However, certain functionalities of the export process are dependent on the Smart Instrumentation version. For example; giving Access Rights to the project reference data is only available from Smart Instrumentation 13.1 HF 7

  •  You can only select the same platform as the target database where you are creating the new domain.

Server (only available when the source database type is Oracle) — Allows you to type your Oracle instance alias.

Seed file name and path (only available when the source database is type SI) —Allows you to type the SI seed file name and path.

SHARED Tip You can use the Browse button to locate the required SI file.

For Oracle or SQL source files:

Admin schema name — Displays the Smart Instrumentation database schema.  When your source database is Oracle or SQL Server, you can type the appropriate Admin schema name of the source Smart Instrumentation database.

  • When your source database resides in Oracle, the default Admin schema logon name is IN_DBAMN.

  • When your source database resides in SQL Server, the default Admin schema logon name is SPI_DBAMN.  This setting must be different from the Admin schema logon password.

Admin schema password — Displays the default Admin schema logon password IN_DBAMN. or type the required password name.

  • When your source database is Oracle, the default Admin schema logon password is IN_DBAMN.

  • When your source database is SQL Server, the default Admin schema logon password is SPI_DBA.  This setting must be different from the Admin schema logon name.

For SI source files:

Schema Name — This field appears blank and is read-only.

Schema password — The seed file password is automatically added to this read-only field.

Connect — Connects to the source database.  After the connection is established, you can select the source domain.

Domain — After connecting to the source database, from the list, select the source domain.

Save last created ID for merging renamed items — Allows you to save the ID of the last created item in the domain.  The software allocates a unique sequential ID to each item that you create.  On merging data at a later stage, if the ID of an item is less than or equal to the ID of the last created item, this indicates that the item was created in the database prior to making the backup.  Consequently, the Merger Utility is able to identify the item by its ID, and can update renamed items if required, by selecting the Include renamed items check box in the Merge Options dialog box.  If you clear this check box, the software makes a backup without saving the last created item ID.  In this case, the Merger Utility ignores any items that were renamed since the backup, even if you select the Include renamed items option, and inserts them as new records.

Copy users and departments to target domain — Allows you to copy the Smart Instrumentation user and department definitions from the source domain to the domain you are initializing.  The software can only copy those users and departments who are assigned to groups.

OK — Reopens the Initialize dialog box, where you can start the initialization process.