ssis

PostgreSQL 13 Support in dotConnect for PostgreSQL, LinqConnect, SSIS Components, and Entity Developer

Devart is glad to announce support for the latest PostgreSQL version – PostgreSQL 13 – in the newly released dotConnect for PostgreSQL 7.19 and SSIS Data Flow Components 1.15 as well as in LinqConnect, and Entity Developer products.

(more…)

How to Export and Import SQL Server Database Data to a SQL Script

We quite often face the task of migrating database directory data. And the database for a recruitment service, which we created in the previous series of articles, is no exception. In this article, we are going to demonstrate how you can export data to a .sql file and then import it to the target database. Is it worth mentioning that you can either migrate the whole database or certain objects depending on your purpose.

(more…)

SSH Support in SSIS Components 1.14 and dotConnect for Oracle 9.12

Devart is glad to announce support of SSH connections in the Direct mode in dotConnect for Oracle 9.12 and SSIS Data Flow Components 1.14. Now you can connect both to on-premises Oracle and Oracle Database Cloud — a Database as a Service (DBaaS) solution from Oracle — via secure SSH protocol in the Direct connection mode.

(more…)

Compare and Find Data Differences Between Two Tables in SQL Server with SSIS and dbForge Tools

Systems often work with distributed databases that contain distributed tables. Distribution is supported by various mechanisms, including replication. In this case, it is necessary to constantly maintain the synchronization of a particular data segment. It is also necessary to check the synchronization itself. This is when the need to compare data in two tables appears.

(more…)

Dynamics CRM OAuth 2.0 Support and Other Improvements in SSIS Components 1.13

Devart is glad to announce the release of SSIS Data Flow Components 1.13 with support of OAuth 2.0 authentication for Dynamics CRM and a number of improvements for other cloud sources and databases.

(more…)

SQL Server Integration Services 2019 Support in dotConnect Providers and SSIS Components

Devart is glad to announce support for the latest SQL Server Integration Services – SSIS 2019 – in its products that support SSIS – Devart SSIS Data Flow Components and dotConnect providers for databases.

(more…)

PostgreSQL 12 support in SSIS Data Flow Components

Devart is glad to announce support for the latest PostgreSQL version – PostgreSQL 12 – in the newly released SSIS Data Flow Components 1.11.
(more…)

BigCommerce API v3 Support in dotConnect for BigCommerce 1.9 and SSIS Data Flow Components for BigCommerce

We are pleased to announce support of BigCommerce API v3 in dotConnect for BigCommerce 1.9 and SSIS Data Flow Components for BigCommerce.
(more…)

PostgreSQL 11 support in dotConnect for PostgreSQL, LinqConnect, SSIS Components, and Entity Developer

Devart is glad to announce support for the latest PostgreSQL version – PostgreSQL 11 – in the newly released dotConnect for PostgreSQL 7.12 and SSIS Data Flow Components 1.10 as well as in LinqConnect, and Entity Developer products.
(more…)

Support for Zoho CRM API v2 in SSIS Data Flow Components 1.9

Devart is glad to announce the release of SSIS Data Flow Components 1.9 with support of Zoho CRM API v2 and Azure Data Factory V2 Integration Runtime support. (more…)