PowerExchange Adapters for PowerCenter
This section describes new PowerCenter adapter features in version 10.4.0.
PowerExchange for Google BigQuery
Effective in version 10.4.0, you can read or write data of the NUMERIC data type to Google BigQuery. The NUMERIC data type is an exact numeric value with 38 digits of precision and 9 decimal digits of scale. When you read or write the NUMERIC data type, the PowerCenter Integration Service maps the NUMERIC data type to the Decimal transformation data type and the allowed precision is up to 28 and scale upto 9.
For more information, see the Informatica 10.4.0 PowerExchange for Google BigQuery User Guide for PowerCenter.
PowerExchange for Google Cloud Storage
Effective in version 10.4.0, you can configure the following Google Cloud Storage data object read operation advanced properties when you read data from a Google Cloud Storage source:
- Google Cloud Storage Path
- Overrides the Google Cloud Storage path to the file that you selected in the Google Cloud Storage data object.
Use the following format:
gs://<bucket name> or gs://<bucket name>/<folder name>
- Source File Name
- Overrides the Google Cloud Storage source file name specified in the Google Cloud Storage data object.
- Is Directory
- Reads all the files available in the folder specified in the Google Cloud Storage Path data object read operation advanced property.
For more information, see the Informatica 10.4.0 PowerExchange for Google Cloud Storage User Guide for PowerCenter.
PowerExchange for Greenplum
Effective in version 10.4.0, you can use PowerExchange for Greenplum to read data from Greenplum. You can configure specific session properties for Greenplum sources to determine how to extract data from Greenplum.
When you run a Greenplum session to read data, the PowerCenter Integration Service invokes the Greenplum database parallel file server, gpfdist, which is Greenplum's file distribution program, to read data.
For more information, see the Informatica 10.4.0 PowerExchange for Greenplum User Guide for PowerCenter.
PowerExchange for JD Edwards EnterpriseOne
Effective in version 10.4.0, you can use version 9.2 of JD Edwards EnterpriseOne API to create a JD Edwards EnterpriseOne connection and access JD Edwards EnterpriseOne objects.
For more information, see the Informatica 10.4.0 PowerExchange for JD Edwards EnterpriseOne User Guide for PowerCenter.
PowerExchange for Kafka
Effective in version 10.4.0, you can use configure the following SSL properties to enable a secure connection to a Kafka broker:
- •SSL Mode
- •SSL TrustStore File Path
- •SSL TrustStore Password
- •SSL KeyStore File Path
- •SSL KeyStore Password
You can configure the Kafka messaging broker to use Kafka broker version 0.10.1.1 and above.
For more information, see the Informatica PowerExchange for Kafka 10.4.0 User Guide for PowerCenter.
PowerExchange for Salesforce
Effective in version 10.4.0, you can use version 46.0 and 47.0 of Salesforce API to create a Salesforce connection and access Salesforce objects.
For more information, see the Informatica 10.4.0 PowerExchange for Salesforce User Guide for PowerCenter.
PowerExchange for SAP NetWeaver
Effective in version 10.4.0, you can use PowerExchange for SAP Dynamic ABAP Table Extractor to read data from SAP tables and ABAP Core Data Services (CDS) views through HTTP/HTTPS streaming. You can read data from ABAP CDS views using PowerExchange for SAP Dynamic ABAP Table Extractor if your SAP NetWeaver system version is 7.50 or later.
For more information, see the Informatica PowerExchange for SAP NetWeaver 10.4.0 User Guide.