This page includes a list of frequently asked questions about the Attunity Oracle-CDC for SSIS. You can find additional questions and answers on the support forum.
Product availability:
Product capabilities:
Related Products:
Please contact us with any additional question you may have.
Product availability:
What version of the product is currently available?
The product is generally available and the current release is version 2.0.
Can I get support when i download a trial version?
Yes. Once you register to download the trial version you will receive an email with login information to our online Support Forum, where you can post questions and review other discussion threads.
Product capabilities:
Where can I find an overview of the product?
A quick overview of the product and its components is available in the product overview and user guide.
How does CDC help me create more efficient integration solutions?
Attunity Oracle-CDC for SSIS enables efficient data processing by non-intrusively capturing and delivering only the changes made to Oracle tables. CDC makes your solution more efficient because:
- It does not require any downtime and runs while operational systems are running. With CDC, you can eliminate batch processing windows that are no longer required, avoiding downtime and freeing up resources including CPU, memory, and network bandwidth.
- Data changes typically amount to a small percentage of the source data volume, making the rapid growth in data volumes a non-issue. Furthermore, it requires much less resources (CPU, memory, etc.) for processing changes as compared to BULK processing.
- It employs log-based CDC that is non-intrusive and has minimal impact on the Oracle source database. It does not add any triggers, timestamp columns, ‘shadow tables’, and it does not require and changes the database schema or the OLTP applications.
What Oracle versions are supported?
Attunity Oracle-CDC for SSIS supports Oracle 9.2.0.4 and higher.
Is Oracle RAC Supported?
Yes.
What SQL Server versions are supported?
Attunity Oracle-CDC for SSIS supports SQL Server 2005 and SQL Server 2008.
Related Products:
How is the product related to the Microsoft Connector for Oracle by Attunity?
Attunity is a Microsoft partner and was selected by Microsoft to provide high speed bulk data connectors for Oracle and Teradata. These connectors were released by Microsoft in October 2008. In building the Attunity Oracle-CDC for SSIS, Attunity allows users of both Oracle and SQL Server to complement their BULK data integration with efficient real-time capabilities.
Does Attunity support CDC for additional sources?
Yes. Attunity is a leading provider of CDC software and the Attunity Stream product line supports a comprehensive list of enterprise sources including relational as well as non-relational databases. For relational sources such as SQL Server and DB2, users can check out the Attunity SSIS CDC Accelerator.