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