Configuring access to data sources of type 2
For this type of ODBC data sources, you must download the ODBC driver and perform some configurations for using it. Data sources support are optimized. Currently, this type includes this data source: SAP HANA .
Before you begin
- Federation must be installed on the server that acts as the federated server.
About this task
Restrictions
- The ODBC wrapper does not support the following functions and
statements:
- Two-phase commit transactions
- LOCK TABLE statements on nicknames
- Features deprecated in ODBC 3.x
- X/Open or SQL/CLI drivers
- Stored procedure nicknames
- Statement-level atomicity enforcement using remote savepoint statements
- WITH HOLD cursors
- For data sources that do not support positioned update and delete operations, positioned UPDATE and DELETE statements and certain searched UPDATE and DELETE statements on a nickname will fail if a unique index on non-nullable columns does not exist on the nickname or its corresponding remote table. The error SQL30090 with the reason code 21 is returned when these statements fail.
- The ODBC wrapper does not support INSERT, UPDATE, or DELETE statements against data sources that restrict the number of active statements for each connection. Consult the documentation for your data source to determine if the data source restricts the number of active statements for each connection.
- The ODBC wrapper does not support operations on tables that contain columns with data types that use driver-specific SQL data type indicators. The type of operations that are not supported included the CREATE NICKNAME and SELECT statements in the pass-through mode. The ODBC wrapper supports only the SQL data type indicators that are defined by the ODBC standard in the Microsoft ODBC Programmer's Reference.
The data sources that are accessed through the ODBC API are referred to in this text as ODBC data sources.