BIS Support in dotConnect for Oracle
dotConnect for Oracle can be used in SQL Server Business Intelligence Solution (BIS) projects. It provides native Devart Oracle Source and Devart Oracle Destination components for DataFlows in Integration Services projects and support Reporting Services and Analysis Services projects.
SSIS DataFlow Source and Destination Components
dotConnect for Oracle provides native Devart Oracle Source and Devart Oracle Destination components along with the Devart Oracle Connection Manager for Data Flows in SQL Server Integration Services (SSIS) projects. These components are available in the professional edition of our providers.
Devart Oracle Source
Devart Oracle Source component is a data flow component that queries data from the corresponding database and makes it available for other DataFlow components.
Devart Oracle Source component provides a powerful editor dialog box that allows you to tweak the component visually.
The Devart Oracle Source editor dialog box displays all available database tables in the Tables tree. You can also view the table properties in this tree and the metadata of the tables and columns in the Properties box. To ease query creation, you can drag a table from the Tables tree to the Edit Query box, and the query to the corresponding table will be built automatically. You can also drag a table to already created query in Edit Query, and the name of this table will be added to the query text.
Devart Oracle Source editor displays SQL Server Integration Services (SSIS) system variables, saving your time, since you don't need to search their names in the documentation any more. They can also be dragged to the query editor to insert their names to the query.
Devart Oracle Source editor allows you to quickly preview the data, returned by the specified query to make sure that you have entered it correctly.
Devart Oracle Destination
Devart Oracle Destination component is a data flow component that loads data into a database table.
Devart Oracle Destination component uses direct path load interface, thus providing significantly higher perfomance for data loading that the standard ADO.NET Destination component.
Per-row Error Processing
Devart Oracle Destination component provides advanced error processing capabilities. It can return a set of columns, containing error code, error columns, and error description for the rows, that caused an error. Thus errors can be processed for each row that caused an error, and you can get the Oracle IDs of records, that were inserted successfully.
Devart SSIS Data Flow Components for Oracle
If you need only SSIS features of dotConnect for Oracle, you may purchase Devart SSIS Data Flow Components for Oracle. This is the SSIS functionality of dotConnect for Oracle, released as a separate product.