You may be trying to access this site from a secured browser on the server. Please enable scripts and reload this page.
Turn on more accessible mode
Turn off more accessible mode
Skip Ribbon Commands
Skip to main content
This page location is:
Data Engineering Integration
Data Engineering Integration
Enterprise Data Catalog
Enterprise Data Lake
Enterprise Data Preparation
Cloud Application Integration
Cloud Data Integration
Cloud Customer 360
Cloud Data Wizard
Informatica Cloud for Amazon AWS
Informatica for Microsoft
Cloud Integration Hub
Cloud B2B Gateway
Cloud API Management
Cloud Data Integration – Elastic
Complex Event Processing
Proactive Healthcare Decision Management
Real-Time Alert Manager
B2B Data Exchange
B2B Data Transformation
Data Integration Hub
Data Validation Option
Data Quality & Governance
Axon Data Governance
Data as a Service
Data Security Group (Formerly ILM)
Data Centric Security
Master Data Management
MDM – Relate 360
MDM Registry Edition
Product Information Management
MDM - Product 360
Ultra Messaging Options
Ultra Messaging Persistence Edition
Ultra Messaging Queuing Edition
Ultra Messaging Streaming Edition
Edge Data Streaming
PAM (Product Availability Matrices)
Informatica Expert Assistant
Velocity (Best Practices)
KB Home Page
Top Link Bar
FAQ: Is IIR compatible with Sybase?
A source only database is connected to using ODBC and has the restriction that you can read from it, however, it cannot use triggers or create IDTs / IDXes etc. So updates have to be handled using the API or NSA methods. Any attempt to use it as a target will get errors such as
Generic ODBC source access does not support target DB operation.
Also, note that both MySQL and Sybase are not officially supported but we did not remove the code that supported them. It may still work to the versions when last tested (Sybase has been removed from PAM some time ago and MySQL was supported up to about version 5.5). Sybase and MySQL had more limited trigger support as well.
Due to these limitations and the fact that Sybase is now an SAP product (since 2014) and may have a different identification code (which means IIR would only support it as an
Unknown database type
or source only database) it is better not to try and use it as a target even if IIR allows it. Sybase looks like it is the end of life by SAP as well.
Generic ODBC Databases
Generic ODBC drivers may be used to access ODBC compliant databases for the unsynchronized source access.
The ODBC drivers for your DBMS must be installed and configured appropriately prior to the installation of MDM-RE. %SSABIN%\odbc.ini must be configured to include an entry for each Data Source Name. Refer to section ODBC Configuration on page 41.
The last version to have Sybase support was 9.0.1, find the attached document.
Configuration; Product Feature
Last Modified Date:
5/20/2020 8:25 PM
People who viewed this also viewed
Did this KB document help you?
This document resolved my issue
This document did not resolve my issue
This document helped but additional information was required to resolve my issue
What can we do to improve this information (2000 or fewer characters)
© 2016 Informatica All Rights Reserved