EasyCatalog Wiki
NousmedisContact us
English
English
  • 👋Welcome!
  • First steps
    • What is EasyCatalog?
    • 30 days trial version
    • Purchasing and activating EasyCatalog
    • Transferring an activation
    • Opening EasyCatalog documents on other computers
  • Importing your data
    • Supported data sources
    • Data concepts
    • Delimited files
    • Excel Spreadsheets
    • Google Docs Spreadsheets
    • Data from an ODBC-compliant Database
      • Connecting to the database
      • Updating the database
    • XML
    • Enterprise data providers
      • Managing Enterprise Data Providers
      • Akeneo
      • Sales Layer
      • Plytix
    • Custom data providers
    • Common errors and warnings
    • Data caching and the workspace folder
  • Field options
    • Opening the field options dialog
    • Available field options
      • The format pane
        • Alfanumeric
        • Number
        • Percentage
        • Currency
        • Custom
        • Hyperlink
        • Imported text
        • Date/Time
        • Barcode
        • Formatting rule
        • Tabular
Powered by GitBook
On this page
  • Benefits
  • Installation

Was this helpful?

  1. Importing your data

Data from an ODBC-compliant Database

You will need to purchase a license of the ODBC Data Provider module in order to connect to an ODBC-compliant database

PreviousGoogle Docs SpreadsheetsNextConnecting to the database

Last updated 2 years ago

Was this helpful?

Using drivers supplied by your database vendor, or a third-party driver manufacturer, the ODBC Data Provider can connect directly to hundreds of SQL database systems including , , and .

Benefits

Connecting directly to a database improves both the speed at which you can start working with your data and allows you to target specific data you wish to work with. The power of your database can also be utilised to selectively retrieve, filter, sort and even perform calculations on your data which is imported directly into EasyCatalog without the need to generate export text files.

The ODBC Data Provider is also bidirectional, so any changes made to data on the document can be optionally updated on the database.

Installation

The ODBC Data Provider is an optional module for EasyCatalog, and should be installed using the supplied installer.

Macintosh users: If the ODBC Data Provider module is not available after installation, please follow the instructions in the ‘platform Specific Issues’.

MySQL
Microsoft SQL Server
MariaDB
FileMaker