Connect EasyCatalog directly to your database using our generic ODBC Data Provider. Get up-to-the-minute information as often as you need, powered by your own SQL queries.
Take your data with you
The ODBC Data Provider works by taking a snapshot of your data that you can refresh at any time. This removes the need for a constant live connection and means you can carry on working even when the database is offline — including when you’re working from home or on the move.
Benefits
- Work offline with a local snapshot of your data
- Refresh whenever you need the latest values
- Avoid being blocked by IT, VPN issues, or database downtime
Bi-directional Link
The ODBC Data Provider is bi-directional: any changes you make to linked content in InDesign can be written straight back to the database. It tracks which fields have been modified and efficiently applies only those updates.
Spotted an error in your data? Fix it once in the document and push the correction back to the database so it’s never repeated in future.
Multiple views of your Database
You can configure any number of data sources at the same time, each with its own SQL statement. This gives you virtually unlimited ways to view and slice your data.
As with all EasyCatalog panels, each view can have its own:
- Sorting
- Grouping
- Filtering
Create different panels for different teams, catalog sections, or output types — all from the same database.
Supported Databases
Support for your particular database is dependent on the availability of ODBC client drivers – Windows users usually get these at no extra cost from their database vendor.
| Platform | Availability |
|---|---|
| Macintosh | This module has been written to be compatible with drivers supplied by Actual Technologies. Please note that these drivers are available at additional cost. Evaluation drivers can be downloaded from their website and are available for many popular database platforms, including SQL Server, Oracle, Sybase, MySQL. Drivers for MySQL are available free of charge from the MySQL site for Macintosh OSX. |
| Windows | Most database vendors now ship ODBC client drivers for Windows with their databases, and are usually available free of charge. ODBC drivers are available for all of the major databases, including MySQL, SQL Server, Oracle, Sybase and Microsoft Access. |
Configuration
All that’s needed to make the Data Provider work is a simple select statement or call to a stored procedure. The example below illustrates how easy it is to configure:
Purchase this module
The cost to purchase a license for the ODBC Data Provider Module is listed below.
