Phoenix can export selected worksheet columns to specific fields within a table in any ODBC-compliant database. Like ODBC import, the export requires a connection string defining the database type and location. It also requires an export definition to map columns in the source worksheet to fields in the target database table.
Database connection: Both ODBC import and export can use the same connection string to define the database type and location. This string is created in the ODBC Export wizard or loaded from a previously saved import or export as detailed under “Establishing a connection”.
Export definition: Once the database connection is established, an export requires a mapping of columns from the Phoenix worksheet to fields in the target database table. This export definition may be created in the ODBC Export wizard or loaded from a previously saved export as shown under “Creating a new export”.
The export definition can be saved with a connection string to an export definition file (*.exp), for later re-use. The export definition can also be saved without the connection string and loaded for use with other databases via different connection strings.
See the following topics for more information:
Legal Notice | Contact Certara
© Certara USA, Inc. All rights reserved.