New features and enhancements

Read about new features and enhancements in the August 2024 Data Ingestion and Replication release.

Common

The August 2024 release of Data Ingestion and Replication includes the following new features that are common to multiple types of ingestion and replication tasks.

SSL encryption support for SQL Server target connections

Application ingestion and replication jobs and database ingestion and replication jobs that have a SQL Server target type (including Azure SQL Database, RDS for SQL Server, and Azure SQL Managed Instance) can use SSL encryption for the target connection. This feature is supported for jobs with any supported source type and load type. The connection's authentication mode must be either SQL Server Authentication or Windows Authentication v2.

When you configure SQL Server connection properties, set the Encryption Method property to SSL, Request SSL, or Login SSL. Then set the related properties, including Crypto Protocol Version, Validate Server Certificate=True, Trust Store, Trust Store Password, and Host Name in Certificate.

For more information, see Connectors and Connections > Microsoft SQL Server connection properties.

New alert condition for incremental load and combined load jobs not processing DML changes

For application ingestion and replication jobs and database ingestion and replication jobs, you can now configure alert email notifications if an incremental load or a combined initial and incremental load job has not been processing any DML data for a significant period of time.

You can create the alert notification from the Alerts > Data Ingestion and Replication Alerts page in Operational Insights. In the Create Alert wizard, select the Source CDC Delay option to receive notifications if a delay in processing records from the source occurs.

Application Ingestion and Replication

The August 2024 release of Application Ingestion and Replication includes the following new feature and enhancement:

Support for Microsoft Dynamics 365 sources with Microsoft Azure SQL Database targets for all load types

Application Ingestion and Replication supports Microsoft Dynamics 365 sources with Microsoft Azure SQL Database targets for initial, incremental, and combined load types.

For more information, see Guidelines for Microsoft Azure SQL Database targets.

Database Ingestion and Replication

The August 2024 release of Database Ingestion and Replication includes the following new features and enhancements:

Active Directory Password authentication for SQL Server sources

You can now use Active Directory Password authentication for SQL Server source connections that are used by database ingestion and replication initial load jobs and by incremental load and combined load jobs that use the CDC Tables or Log-based CDC method. This authentication method is not currently supported for jobs that use the Query-based CDC method.

For more information, see Connectors and Connections > Microsoft SQL Server connection properties.

Replacement of special characters in column names with a provided choice of string in the Snowflake target

If the source tables contain columns that have special characters in the name, you can now replace the special characters with a provided choice of string in the Snowflake target using the targetReplacementValue=<string> custom property.

To replace the special characters with an underscore, set the targetReplacementValue=<string> custom property on the Target page of the task wizard and in a properties file which you can define in the Custom Configuration Details area of the Secure Agent.