ODBC Connector 24.2

# Features and Capabilities

The ODBC Connector (CFS) retrieves data from an ODBC data source, for example Microsoft SQL Server or MySQL.

Repository | Any ODBC data source, as long as the relevant drivers are available on the connector machine.
Data the connector can retrieve | The connector can retrieve string, numeric, date, and binary values from the database. The connector can create documents by retrieving data from single tables or views, or by extracting data from multiple, related tables. The connector can extract binary files from binary large object (LOB) fields.
Data the connector cannot retrieve | The connector cannot retrieve XML data types, but these can be transformed into strings by modifying the query used to retrieve the data. The connector cannot retrieve bit-fields from a MySQL database, but you can modify your query to convert the field value to an integer. For example: `SELECT bit_field+0 FROM mytable`.

Copyright 2024 Open Text
Version 24.2 | Last updated March 2024

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: IDOL ODBC Connector 24.2

Topic Title: Features and Capabilities