Import source: Current Axiom database

Use one of the Current Axiom database options to import data from the current Axiom database. This feature might 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.

When you use one of these options, 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.

You can select either of the following options:

• 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.

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 temptable. 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.