ssis

27 New Data Sources Supported in Devart SSIS Components 2.0!

Devart is glad to announce the release of SSIS Data Flow Components 2.0 with support for 27 new data sources. We have supported Snowflake cloud data warehouse and a number of cloud applications, including several new inventory management solutions, like DEAR Inventory or Zoho Inventory, a number of new cloud CRMs, such as Pipedrive and Insightly CRM.

SSIS Data Flow Components now also support new cloud app categories, for example, Ads and Conversion, with such widely used tools as Google Analytics, Google Ads, and Twitter Ads. See the full list of the sources below:

(more…)

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

Evgeniy Gribkov

Evgeniy is an MS SQL Server database analyst, developer, and administrator. He is involved in the development and testing of the SQL Server database management tools. Evgeniy also writes SQL Server-related articles.
Evgeniy Gribkov

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

Evgeniy Gribkov

Evgeniy is an MS SQL Server database analyst, developer, and administrator. He is involved in the development and testing of the SQL Server database management tools. Evgeniy also writes SQL Server-related articles.
Evgeniy Gribkov

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…)