What's New

What's New

New features and enhancements

New features and enhancements

The July 2024 release of
Cloud Data Integration for PowerCenter (CDI-PC)
includes the following new features and enhancements.

Configurations for assessment and conversion

You can create the following configurations from the
Configurations
page and use them in assessment and conversion tasks:
Repoint Configuration
Contains the repoint configuration for assessment. You can use this configuration in assessment tasks to evaluate the feasibility of repointing the assets to another endpoint.
Connection Map
Contains mappings between the PowerCenter connections and the corresponding cloud connections. You can use this configuration in conversion tasks.
Conversion Properties
Contains basic and advanced conversion properties. You can use this configuration in conversion tasks to override the default conversion behavior.

PowerCenter parameter file conversion

You can convert PowerCenter parameter files to
Data Integration
parameter files. Create a
Parameter File Conversion Task
from the
Repositories
page, view and run the job from the
Parameter File Conversion Tasks
page, and monitor the status of the job on the
My Jobs
page.

Session-specific connection types

You can configure a new conversion property,
overrideToSessionConnectionType
to set the source or target connection type as per the session specific connection type. This flag applies to non-repointing scenarios when the source or target uses a different relational database than the session-level connection type.

Native precision and scale for repointing scenarios

You can configure a new conversion property,
UseDsqPrecisionAndScale
to set the native precision and scale for string data type as per the source qualifier. You can set this property when you repoint to any one of the following endpoints:
  • Google BigQuery
  • Amazon Redshift
  • PostgreSQL
  • Databricks
  • Snowflake
  • Azure Synapse

Native precision and scale for non-repointing scenarios

You can configure a new conversion property,
SrcNativeFieldsBasedOnSQFields
to set the native precision and scale for string, decimal, and date time data types based on the source qualifier. This flag applies to non-repointing scenarios for the following connections:
  • Oracle
  • ODBC
  • Microsoft SQL Server
  • Teradata
  • Sybase ASE
  • DB2 Loader
  • Netezza

0 COMMENTS

We’d like to hear from you!