BIS Support in dotConnect for DB2
dotConnect for DB2 can be used in SQL Server Business Intelligence Solution (BIS)
projects. It provides native Devart DB2 Source and Devart DB2 Destination components
for DataFlows in Integration Services projects and support Reporting Services and
Analysis Services projects.
SSIS DataFlow Source and Destination Components
dotConnect for DB2 provides native Devart DB2 Source and Devart DB2 Destination
components along with the Devart DB2 Connection Manager for Data Flows in SQL Server
Integration Services (SSIS) projects. These components are available in the professional
edition of our providers.
Devart DB2 Source
Devart DB2 Source component is a data flow component that queries data from the
corresponding database and makes it available for other DataFlow components.
Devart DB2 Source component provides a powerful editor dialog box that allows you
to tweak the component visually.
The Devart DB2 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 DB2 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
Devart DB2 Source editor allows you to quickly preview the data, returned by the
specified query to make sure that you have entered it correctly.
Devart DB2 Destination
Devart DB2 Destination component is a data flow component that loads data into a
Devart DB2 Destination component uses IBM.Data.DB2.DB2BulkCopy for loading data,
thus providing significantly higher perfomance for data loading that the standard
ADO.NET Destination component.
Per-row Error Processing
Devart DB2 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.