Use ODBC Import to load data from an ODBC-compliant database directly to a worksheet. An import involves establishing a connection to the database, then defining a query to draw specific fields and records from it.
Database connection: Both ODBC import and export use a connection string that defines the database type and location. This string can be created by pointing to the database type and file or loaded from a previously saved import or export as detailed under “Establishing a connection”.
Query: Once the database connection is established, an import requires a query to set which data table, field(s), and records to import. The query can be created in the ODBC Import wizard or loaded from a previously saved import as described under “Specifying the Query”. Phoenix translates the query into Structured Query Language (SQL), which can be edited before executing the import.
The query settings can be saved with a connection string to an import specifications file (*.imp), for later re-use. The query settings can also be saved without the connection string and loaded for use with other databases via different connection strings.
Phoenix also provides a Custom Query Builder for creation of dynamic link library (DLL) files that can access additional data source types, including Watson version 7.x DMLIMS. See “Using the custom query builder”.
Note: If an error is encountered when using ODBC Import, try setting the permissions of the C:\Windows\SysWOW64\comdlg32.ocx file to Read-Execute and Read for Everyone user.”
Legal Notice | Contact Certara
© Certara USA, Inc. All rights reserved.