Connectors - Enhanced

Amazon Aurora

• •On Windows 64-bit and Linux 64-bit operating systems, Amazon Aurora drivers are upgraded to the latest versions.

Amazon S3

• •On Windows 64-bit and Linux 64-bit operating systems, Aurora, MySQL, Microsoft SQL Server, and Oracle drivers are upgraded to the latest versions.
• •For client-side and server-side encryption, you can configure the customer master key ID generated by AWS Key Management Service (AWS KMS) in the connection.
• •You can override and parameterize the Amazon S3 bucket name in the advanced target properties.
• •In addition to the existing regions, you can also read data from or write data to the Amazon S3 buckets in the following regions:
• - Asia Pacific (Mumbai)
• - Canada (Central)
• - China (Bejing)
• - US East (Ohio)
• •When you write data to the Amazon S3 buckets, you can compress the data in GZIP format.
• •When you run a task in Secure Agent runtime environment, you can specify a directory path that is available on the corresponding Secure Agent machine in the runtime environment.
• •You can write multiple files to Amazon S3 target from a single source. You can configure the Distribution Column options in the advanced target properties.
• •You can configure the multipart upload option to upload a single object as a set of independent parts. TransferManager API uploads the multiple parts of a single object to Amazon S3. After uploading, Amazon S3 assembles the parts and creates the whole object. TransferManager API uses the multipart uploads option to achieve performance and increase throughput when the content size of the data is large and the bandwidth is high.
• •You can read multiple files from Amazon S3 and write data to a target.
• •When you create a mapping task to write data to Amazon S3 targets, you can configure partitions to improve performance. You can configure the Merge Partition Files option in the advanced target properties.

Amazon Redshift

• •For server-side encryption, you can configure the customer master key ID generated by AWS Key Management Service (AWS KMS) in the connection.
• •In addition to the existing regions, you can also read data from or write data to the following regions:
• - Asia Pacific (Mumbai)
• - Canada (Central)
• - China (Bejing)
• - US East (Ohio)
• •You can configure the multipart upload option to upload a single object as a set of independent parts. TransferManager API uploads the multiple parts of a single object to Amazon S3. After uploading, Amazon S3 assembles the parts and creates the whole object. TransferManager API uses the multipart uploads option to achieve performance and increase throughput when the content size of the data is large and the bandwidth is high.
• •In addition to the existing recovery options in the vacuum table, you can select the reindex option to analyze the distribution of the values in an interleaved sort key column.

Coupa

• •You can specify the Error Payload Directory to get the details of the failed payload in Coupa.
• •You can perform insert or update operation on the following objects in Coupa:
AccountValidationRules, Addresses, BudgetLines, CatalogItems, ContentGroups, Contracts, Currencies, ExpenseLines, ExpenseReports, InventoryTransactions, OrderPads
PurchaseOrders, Requisitions

File Processor

• •You can use the CompressAllFiles filter field to zip files to a single zip or .7z file.
• •You can perform delete operation on a File Processor target.
For more information, see the Informatica Cloud File Processor Connector User Guide.

Google BigQuery

• •You can create Google BigQuery target tables based on the columns present in the Google BigQuery source.
• •When you write data to a Google BigQuery target, you can configure the create disposition property to define whether the Secure Agent must create the target table if it does not exist.
• •You can update data in a Google BigQuery target.
• •You can delete data from a Google BigQuery target.
• •You can specify the following data formats for the Google BigQuery target staging file:
• - JSON (Newline Delimited)
• - CSV
• •You can configure the following advanced writer properties:
• - Number of threads for uploading staging file
• - Local storage file directory
• - Allow quoted newlines
• - Field delimiter
• - Allow jagged rows
• •You can use a Google BigQuery object as a source in Data Synchronization tasks, Mapping Configuration tasks, and mappings.
• •You can use staging mode to read data. In staging mode, the Secure Agent first downloads BigQuery target data in Google Cloud Storage and then reads the data from Google Cloud Storage.
• • You can configure the following properties when you use staging mode to read data from a Google BigQuery source:
• - Number of threads for downloading staging files
• - Local stage file directory
• - Staging file name
• - Enable staging file compression

Google Cloud Storage

• •You can use Google Cloud Storage Connector to read data from Google Cloud Storage. You can use Google Cloud Storage objects as sources in Data Synchronization tasks, Mapping Configuration tasks, and mappings. You can use Google Cloud Storage Connector to read files that contain string and binary data.
• •You can specify the number of threads that the Secure Agent must create to write data to the Google Cloud Storage target. You can configure multi-threading to write data to the Google Cloud Storage target in parallel and improve the performance.
• •You can specify whether the Secure Agent must retain the order of text data when it writes to the Google Cloud Storage target. You can retain the order of text data if you configure more than one thread to write text data to a Google Cloud Storage target.

JDBC

LDAP

Microsoft Azure Blob Storage Connector

• •When you read data from or write data to Microsoft Azure Blob Storage, you can use the Blob Name Override property to override the default Blob name.
• •When you read data from or write data to Microsoft Azure Blob Storage, you can use the Blob Container Override property to override the default container name.
• •When you read data from Microsoft Azure Blob Storage and use the header in the first row of blob property, the Secure Agent reads the first row of the blob as a header. When you write data to Microsoft Azure Blob Storage and use the header in the first row of blob property, the Secure Agent writes the first row of blob as a header.
• •When you write data to Microsoft Azure Blob Storage, you can use the Compress newly created Blob property to compress the newly created blob when set to True.

Microsoft Azure DocumentDB Connector

Microsoft Azure SQL Data Warehouse Connector

Microsoft Dynamics AX V3

• •You can set the batch size when you perform a create, update, or delete operation. Default batch size is 50.
• •You can use Microsoft Dynamics AX V3 Connector to perform full update operation.
• •You can use readAll operation to read all the records from Microsoft Dynamics AX.
• •You can use Microsoft Dynamics AX V3 Connector to configure midstream transformation.
• •When you read data from or write data to Microsoft Dynamics AX, you can use the following advanced properties:
• - Batch Size. You can write data to the target in batches.
• - Company Name. You can specify the company name.
• - Language. You can localize the data you read from or write to Microsoft Dynamics AX.

Microsoft Dynamics CRM

Microsoft SQL Server

MySQL

• •When you create a Mapping Configuration task to read data from MySQL, you can configure key range partitioning to improve performance.
• •On Windows 64-bit and Linux 64-bit operating systems, MySQL drivers are upgraded to the latest versions.

NetSuite

ODBC

• •You can use the ODBC connection to connect to the Teradata database. Specify Other subtype in an ODBC connection to connect to Teradata sources and targets.
• •You can enable full or source pushdown optimization for Teradata sources and targets. Specify Other subtype in the ODBC connection properties to enable pushdown optimization when you read data from or write data to Teradata databases. The Secure Agent pushes the supported functions to Teradata sources and targets based on the pushdown optimization session property name you select.
• •When you use the ODBC connection to connect to MongoDB, you must use the Simba ODBC driver version 2.4.1.1001 on Windows or Linux to connect to MongoDB. You cannot upgrade Simba ODBC drivers from previous versions.
• •You can use the ODBC connection to read and write data from IBM DashDB.
• • When you create a new ODBC connection on Linux platform, you can select a driver manager for the Linux Secure Agent. Select one of the following driver managers:
• - Data Direct
• - unixODBC2.3.0
• - unixODBC2.3.4
• •You can configure Microsoft Active Directory as the authentication server to connect to Microsoft Azure SQL Data Warehouse through an ODBC connection.
For more information, see the Informatica Cloud ODBC Connector User Guide.

Oracle

• •You can use Oracle bulk API to insert data in bulk mode. When you create a Mapping Configuration task, you can use the Oracle bulk API to perform insert operation.
• •On Windows 64-bit and Linux 64-bit operating systems, Oracle drivers are upgraded to the latest versions.

REST V2

• •You can configure the extended JSON mime type, JSON subtype, and JSON custom type for the API response.
• •You can create Swagger for an REST API from Informatica Cloud.
• •Fault processing is supported for midstream. The fault group contains the RequestXML, ErrorCode, and ErrorMessage. To map the fault group for the business services created in the previous version of connector, recreate the Web Services transformation and map all the required fields..
• •You can upload a file to a REST endpoint URL.

Salesforce

• •You can create a Salesforce connection with OAuth authentication.
• •You can use an SOQL custom query as a source type in the Mapping Designer when Salesforce Bulk API is enabled.
• •Salesforce Connector supports version 39 of Salesforce API.

Satmetrix

ServiceNow

• •You can use the Informatica Cloud Hosted Agent (Hosted Agent) as a runtime environment for a ServiceNow connection.
• •ServiceNow Connector uses REST API in SynQ READ operation to fetch data from ServiceNow.

Snowflake

Workday V2

Zuora AQUA

• •You can run a task to download data from the multiple Zuora source objects at once.
• •You can define multiple ZOQL queries in the advanced data filters section to download the data from multiple or related source objects.