Excel Odata Mac Are Configured

By default, the CData ODBC Drivers for Mac are configured to use UTF-32 which is compatible with iODBC, but other Driver Managers may require alternative encoding.

Excel Odata Driver Must Be

The driver must be registered with the driver manager and DSNs are defined in the driver managers configuration files.

Note that the ODBC Manager must match the bitness of the ODBC driver.

After opening the iODBC Administrator 64-bit, you will see the CData OData Source listed under the System tab.

Select the DSN and click the Configure button to set connection properties as name-value pairs.

This keeps the CData ODBC Driver for OData 2019 from having to send requests for metadata on each connection.

This enables access to related entities, even though these entities may not be linked by a foreign key in your OData service.

If this is the case for your API, specify the base entitys primary key in the WHERE clause to access navigation properties.

Otherwise, the driver uses the default format defined by the service.

This is useful if your application supports an older OData version.

This can help you to avoid SQL escapes and errors in SQL-based tools.

You can specify other authentication values in CustomHeaders.

Windows (NTLM): Set the Windows User and Password to connect and set AuthScheme to NTLM.

Kerberos and Kerberos Delegation: To authenticate with Kerberos, set AuthScheme to NEGOTIATE.

To use Kerberos Delegation, set AuthScheme to KERBEROSDELEGATION.

By default, the driver attempts to communicate with the SPN at the specified Url.

To specify another certificate, see the SSLServerCert property for the available formats to do so.

In this section, the Driver property specifies the path to the driver library.

The driver library is the.dylib file located in the lib subfolder of the installation directory, by default in ApplicationsCData ODBC Driver for OData.

Driver ApplicationsCData ODBC Driver for ODataliblibodataodbc.dylib.

If you need to connect to OData from an application that can use only the ANSI ODBC API, click iODBC Demo Ansi.

You can now execute SQL statements to OData by clicking Execute SQL in the SQL menu.

Excel For Mac Odata