Accessing SQL Anywhere data

The project at hand is to create ODBC access SQL Anywhere data used by FedEx Ship Manager. The database is stored on the local machine.

The goal is to extract daily shipment data without having to manually manage the data export sequence in the application itself.


SQL Anywhere is not supported by the visual query designer in EasyMorph, but you still can query it using custom SQL statements.

Create an ODBC connection in EasyMorph with “Generic SQL” as SQL dialect. Then open Query Editor and switch into the “Custom SQL” mode, then write SQL SELECT statements manually.