Database Import Wizard

The Database Import Wizard is used for configuring database connections. Configured database connections can be selected as preallocations.

Prerequisites

Due to your currently used role you have the privilege Configure Database Connections.

Purpose

The Database Import Wizard takes you through the steps necessary for importing database tables in order to set the source, subject and target of the database import.

You can use the settings for the import's source to create connections to any relational database management system (RDBMS, DBMS for short).

Selecting the database system also sets the type system at the same time. Only packages which support the type system matching the database system by profile import are provided as target upon import.

Note

The wizard is only available in Innovator for Information Architects.

Sequence Control Files

Files which control the flow of DB imports can be found in the following directories:

  • $INODIR\java\InoIMInOut\configuration directory

    • datatypes.xml for implementing JDBC data types into Innovator data types upon import
    • stereos.xml with the customizable stereotypes used upon import

  • $INODIR\java\InoJDBC\configuration\de\mid\data directory

    • statements_*.xml allow you to query the database using JDBC standard

Call

Select Import/Export>Import>Database.

The top section shows which step you are currently in; from the second step onwards it also has an active back button you can click on to go back a step.

The middle section shows you the input and selection options available for the database connections or tables.

At the bottom are the following buttons, if applicable:

  • Next button

    You use this button to reach the next processing step if the step does not require the selection of a radio button.

    When you have completed all the required information in the wizard, the Import button appears instead. The Import button imports directly into the selected target package.

  • Cancel button

    This closes the wizard. If you have made any changes, you are asked if you want to save these.

The wizard contains specific areas for the individual steps.

Step 1 of 5: Select the database connection

The wizard contains the following areas in the first step.

Database Connections

The list of database connections configured is shown in the list on the left-hand side.

The fields on the right-hand side are filled with connection details if you click on one of the database connections.

In addition to the commands that are available as buttons below the list, the context menu for a database connection also provides the following commands:

  • Load connections

    Load connections from a file. The connection data from the file is added and - if applicable - given a unique name.

  • Save connections

    Save the selected connections to a file.

General settings for the database connection selected on the left.

Name

The name of the connection shown.

Standalone Servers Group

  • Type: DBMS-specific connection type
  • Host: The address or name of the computer that the DBMS is running on.
  • Port: The port DBMS gets JDBC access for.

DB Filters Group

  • Filter: Comma-separated list of names for restricting the databases to be queried ("Name1[,Name2,...,NameN]"; "Name%" inputs all objects which start with "Name")
  • Databases (DB2 zOS only): Comma-separated list of names for restricting the databases to be queried
  • Catalog/SID/TNS Service: DBMS-specific instance of a catalog name or connection data
  • Schema: DBMS-specific instance of a schema name

Group Login

  • User name: The user with which the database is to be accessed
  • Password: The password of the user
  • Integrated security: ID for use of user data for the user logged-in to the operating system.

Check Connection

A connection test with the current settings Use to test whether the data entered can be made into a database connection. The button is activated if a database connection was selected.

Additional settings for the database connection selected on the left.

  • URL prefix: DBMS-specific connection prefix

  • Driver name: The Java class which enables access to the DBMS.

  • Driver file: Possible Java class path extension

  • Extended configuration: Here, you can select a configuration file to change the behavior during the import from the standard behavior. The call parameters of all actions are extended or replaced accordingly.

    The format of the file is as follows:

    <?xml version="1.0" encoding="UTF-8"?>
<Root>
 <Arguments>
  <Argument Name="Name1" Value="Value1" />
  <Argument Name="Name2" Value="Value2" />
  <Argument Name="Name3" Value="Value3" />
:
 </Arguments>
</Root>

Buttons

  •  Add a new database connection

    This creates a new database connection that you can rename and make settings for. Certain settings are preallocated.

  •  Create a copy of the selected database connection

    The button is activated if a database connection was selected.

  •  Delete the selected database connection(s)

    The button is activated if a database connection was selected.

Selection of Database Connection

How to proceed

  1. Select the database connection you want import tables with.

  2. If the database connection you want does not already exist, then click on to create a new one. Enter the correct specifications for making the connection you want.

  3. If you want to use an existing database connection as a template, then select this database connection and click on to copy the specifications and make the changes required.

  4. If you require special filter or driver settings, then jump to the Advanced tab and make the appropriate settings.

  5. To test the configured data connection, click on Check Connection.

    The database login dialog appears. Enter the user and password and click on OK. The connection is tested and the result is displayed.

  6. Click on Next.

    A connection is made to the configured database selected in the database connection.

    The wizard jumps to the next step.

Step 2 of 5: Selection of database objects to be imported

How to proceed

  1. Activate the appropriate check boxes in order to select the database objects in the connected database that you want to import.

  2. Click on Next.

    The wizard jumps to the next step.

Step 3 of 5: Selection of import type

Context

You can choose between:

  • Standard Import

    In the next step, you select the database elements to be imported.

  • Advanced import

    Open the DB manager, which provides advanced comparison and import functions.

How to proceed

  • To select the import variant, click on the relevant button.

    The wizard jumps to the next processing step or to the DB Manager editor.

Step 4 of 5: Selection of database elements

How to proceed

  1. Select the database elements that you want to import into your model.

  2. Click on Next.

    The wizard jumps to the next step.

Step 5 of 5: Selection of the target package

How to proceed

  1. Select the target package in the model where the database elements should be imported.

  2. To import the selected database elements, click on Import.

    The selected database elements are imported directly into the target package.

Related Topics Link IconRelated Topics

This chapter contains the topics: