APPX Software Library

Chapter 3: Make APPX Files Available to SQL

Add the COUNTRY Table to SQL with ASQL

  1. Open ASQL Dictionary Importer from the installed 5.5.4 package.
  2. Choose AppxODBC, enter an authorized APPX user and password, and enter DMO for both Database ID and Application ID.
  3. Select OK. The DMO dictionary tree appears.
ASQL uses the default AppxODBC DSN and the DMO sample IDs.
Figure 4. ASQL uses the default AppxODBC DSN and the DMO sample IDs.

ASQL selects the AppxODBC DSN, which supplies Host, Database and optional Service. DMO in this dialog selects the APPX database and application to import; it is separate from the SQL dictionary appx. Meaning of these names.

ASQL connects to DMO through the default dictionary.
Figure 5. ASQL connects to DMO through the default dictionary.
  1. Expand DMO → DMO, select COUNTRY, and select Import Tables.
  2. Wait for the check mark beside COUNTRY and Ok in the status line.
The COUNTRY import finishes with a check mark and Ok.
Figure 6. The COUNTRY import finishes with a check mark and Ok.

ASQL creates the SQL table metadata, index and synonym. It reads the records from the APPX file when the table is queried; this dictionary import does not copy the business records into a separate SQL database.