AX2430

Importing from an internal Axiom Software database

You can import data from the current Axiom Software database. This feature can be used to automate the process of copying data from one table to another, or to transform the data within a table.

NOTE: Only administrators can create or edit an import that uses the current Axiom database as the source. Non-administrators do not see this option when creating or editing an import, and cannot open any existing imports that are configured to use this option. However, non-administrators can be given the right to execute an import that uses the Axiom database.

Source configuration

To import data from the Axiom Software database, complete the following configuration settings on the Source tab of the Import Wizard.

Item	Description
Import type	Select Internal Database to import data from the Axiom Software database.
Import source	Select one of the following database sources: Current Axiom system database: Import data from a table in the system database. Current Axiom audit database: Import data from a table in the corresponding audit database. NOTE: Systems with an Axiom Contract Management license can also import data from the Current Contract Management database. See the separate product documentation for more information on importing contract management data.

Item

Description

Import type

Select Internal Database to import data from the Axiom Software database.

Import source

Select one of the following database sources:

Current Axiom system database: Import data from a table in the system database.
Current Axiom audit database: Import data from a table in the corresponding audit database.

NOTE: Systems with an Axiom Contract Management license can also import data from the Current Contract Management database. See the separate product documentation for more information on importing contract management data.

When you use this option, Axiom Software automatically creates the necessary connection string in the background when the import is performed. If the import is copied to another system or if the current database is restored to a different location, the new context is used to create the connection string.

SQL Select Statement

The SQL SELECT statement defines the data query to the source database, resulting in the set of data to be imported to the temp table. You can then perform mapping and transformations on the data before importing into the destination table.

In the SQL Select Statement box, enter any valid SQL statement to define the data query. You can click the SQL editor button to open the Edit SQL dialog. This dialog provides a text editor for entering and reviewing large SQL statements, and several tools to check the statement. For more information, see Creating the SQL SELECT statement.

Variables can be used in the SELECT statement. See Using variables in imports.