Connections - Enhanced

Amazon Redshift

• •You can use AWS Identity and Access Management (IAM) Authentication for secure and controlled access to Amazon RedShift resources.
• •When you read data from Amazon Redshift objects, you can configure key range partitioning.
• •When you configure field mappings in a Data Synchronization task, you can create a lookup to an Amazon Redshift object.
• •You can include a Lookup transformation in a mapping.
• •You can configure Full and Source-Side Pushdown optimization.
• •You can configure advance filter properties in Data Synchronization tasks, mappings, and Mapping Configuration tasks.
• •You can configure pre-SQL and post-SQL queries for source and target objects in Data Synchronization tasks, mappings, and Mapping Configuration tasks.
• •You can configure a Source transformation to select distinct rows from the Amazon Redshift table and sort data.
• •You can parameterize source and target table names to override the table name in a mapping.
• •You can define an SQL query for source and target objects in a mapping to override the default query. You can enter an SQL statement supported by the Amazon Redshift database.

Amazon S3

• •You can include the period (.), the underscore (_), @, $, and % special characters in the object name when you create a new target object at runtime.
• •You can append the timestamp in the object name when you create a new target object at runtime in a mapping.
• •You can parameterize the object name when you create a new target object at runtime.

Complex File

Eloqua Bulk API

• •Minimum value: PT1H, which stands for one hour.
• •Maximum value: P2W, which stands for two weeks.

File Processor

Marketo V3

• •Opportunity, opportunity role, sales person, and company are available as both source and target objects in a task. You can use Marketo V3 Connector to retrieve opportunity, opportunity role, sales person, company records from Marketo. You can also insert, update, upsert, or delete sales person, company, opportunity and opportunity role data in Marketo.
• •Program, email, channel, and tag are available as source objects in a task. You can use Marketo V3 Connector to retrieve program, email, channel, and tag from Marketo.

Microsoft Azure SQL Data Warehouse

Microsoft Dynamics CRM

Microsoft SQL Server Connector

• •You can use a Microsoft SQL Server connection to connect to Microsoft Azure SQL databases. You can also connect to audit-enabled Azure SQL databases and pre-V12 Azure SQL databases.
• •You can connect to Azure SQL databases from Secure Agents deployed on Azure virtual machines.
• •You can use SSL encryption mode to connect to Microsoft SQL Server databases and Microsoft Azure SQL databases.
• •When you create a Mapping Configuration task to read data from Microsoft SQL Server, you can configure key range partitioning to improve performance.
• •When you create a Mapping Configuration task, you can create a target file at run time if the target does not exist in the Microsoft SQL Server connection.
• •When you create a Data Replication task, you can use the Microsoft SQL Server bulk API.
• •When you create a Mapping Configuration task, you can use the Microsoft SQL Server bulk API to perform an insert operation.

MySQL Connector

• •When you create a Mapping Configuration task to read data from MySQL, you can configure key range partitioning to improve performance.
• •When you create a Mapping Configuration task, you can create a target file at run time if the target does not exist in the MySQL connection.

ODBC

• •Redshift. When you read from or write to Amazon Redshift, select Redshift.
• •Azure DW. When you read from or write to Azure Data Warehouse, select Azure DW.
• •Other. When you read from or write to any other databases, select Other.

Oracle Connector

• •When you create a Mapping Configuration task to read data from Oracle, you can configure key range partitioning to improve performance.
• •When you create a Mapping Configuration task, you can create a target file at the run time if the target does not exist in the Oracle connection.
• •You can now specify the Oracle System ID (SID) in the Service Name connection property to connect to Oracle databases.
• •When you install the Secure Agent on 64-bit Windows or Linux operating systems, you can read data from and write data to Oracle 12c databases.

Salesforce

• •You can enable primary key chunking in mappings to increase performance when you extract data from large tables.
• •You can create new or modify the existing Salesforce connections to use version 37 and version 38 of the Salesforce API.

Salesforce Marketing Cloud

• •You can use Salesforce Marketing Cloud Connector to perform upsert and delete operations on Contact objects with system-defined data extensions.
• •You can use Salesforce Marketing Cloud Connector to perform fetch, upsert, and delete operations on non-Contact objects with system-defined data extensions.
• •You can use Salesforce Marketing Cloud Connector to read and write system-defined and user-generated data extensions through SOAP API.
• •You can now perform upsert and delete operations on user-generated data extensions.
• •You can now perform an upsert operation on system-defined data extensions.
• •When you perform an upsert operation, you do not need to specify contact key in grandchild data extensions.

SAP SuccessFactors ODATA

• •SAP SuccessFactors ODATA Connector supports Hosted Agent.
• •You can use SAP SuccessFactors ODATA Connector to join multiple sources.
• •You can use OAuth 2.0 authentication in SAP SuccessFactors ODATA connection.

SAP SuccessFactors SOAP

Workday V2

• •When you read large amounts of data from Workday, you can configure a batch size to determine the number of requests that the Secure Agent sends to Workday parallely to fetch pages. You can set up to a maximum batch size of 20. Default is 1.
• •You can access the following modules in Workday when you use the Workday V2 connection:
• - Admissions
• - Compensation_Review
• - Dynamic_Document_Generation
• - Financial_Aid
• - Inventory
• - Payroll_FRA
• - Payroll_GBR
• - Student Finance
• - Student Records

Zendesk