SSIS Integration Toolkit for Oracle CRM On Demand

Powerful CRM Integration software for Oracle CRM On Demand.

  • Easily read from and Write to Oracle CRM On Demand.

  • Perform Create, Update, Upsert, and Delete operations with robust error handling.

  • Extract data with support for parent-child objects, Searchspec filters, and batch control.

See Capabilities Get Expert Help
KingswaySoft - Oracle Marketing Cloud SSIS Data Integration Made Easy

Note: The SSIS Integration Toolkit for Oracle CRM On Demand is now part of the SSIS Integration Toolkit, and is no longer available as a stand-alone product. Please continue reading for information about Oracle CRM On Demand SSIS components, or see the SSIS Integration Toolkit page for information on the new consolidated solution.

SSIS Integration Toolkit for Oracle CRM On Demand Product Box - Package

Data Integration Made Easy

Efficient SSIS Toolkit for high-performance data integration for Oracle CRM On Demand

Our data integration solution combines simplicity with exceptional performance, delivering robust integration capabilities that smoothen your ETL workflows.

Robust Features

Unlimited Integrations

Powered by the powerful SSIS ETL engine, developers can quickly integrate Oracle CRM On Demand with virtually any other application or data system.

SSIS Integration Toolkit for Oracle CRM On Demand includes a Connection Manager, a Source, and a Destination component for connecting to Oracle CRM On Demand instances.

Oracle CRM On Demand Data Integration

Data Integration Made Easy

Advanced Integration Capabilities

  • Achieve top-tier data integration for Oracle CRM On Demand with SSIS, ensuring high performance and seamless synchronization.

  • Take advantage of the flexibility and power of SSIS ETL engine with a codeless data integration approach.

  • Advanced field and column filtering to pull only the necessary data needed.

  • Unique options to support both parent and child objects.

  • Separate searchspec query filter fields for parent and child objects.

  • Built-in retry on intermittent errors helps eliminate integration disruptions due to temporary service outages or disruptions.

  • Read from a parent object and a child object.

  • 4 different actions for writing to Oracle CRM On Demand: Create, Update, Delete, or Upsert.

  • Automatic field mapping based on a name-match.

See Technical Requirements
See help manual for technical feature highlights

Codeless
 Integration

You don't have to write a single line of code to make data integration happen so your development can be done in a matter of minutes.

Flexible and
 Easy to Use

We make the most flexible integration solution on the market. Our software offers intuitive user interfaces that are flexible and easy to use.

Cost
 Effective

With a streamlined development experience, and an extremely simple licensing model, our solution offers the best value for your investment.

Unparalleled
 Performance

Our software includes purpose-built features that help you achieve optimal performance while ensuring exceptional efficiency and reliability.

Data Integration Made Easy with
SSIS Integration Toolkit for Oracle CRM On Demand

Powered by modern cryptography and authentication technologies for secure connections, such as TLS 1.2, OAuth2, SHA-256, etc.

DownloadPurchaseHelp Manual

The KingswaySoft tool’s UI is very intuitive and you cannot beat the support they provide.

D. Ng

Senior DBA

ASCO

SSIS Integration Toolkit for Oracle CRM On Demand - Connection Manager

Oracle CRM On Demand Connection Manager

  • The Oracle CRM On Demand Connection Manager facilitates connection to Oracle CRM On Demand web services.
  • Provides secure and encrypted communication between SSIS and Oracle CRM On Demand, ensuring the protection of sensitive data during data transfer.
  • Leverages Oracle CRM On Demand Web Services API, enabling seamless data integration between SSIS and Oracle CRM On Demand.
  •  See this component's documentation

Oracle CRM On Demand Source Component

  • The source component allows you to read data from Oracle CRM On Demand objects via web services.
  • Supports custom queries and filters, allowing users to extract specific data based on their requirements.
  • Enables real-time data synchronization, ensuring the most up-to-date CRM information is available for integration with other systems.
  •  See this component's documentation

SSIS Integration Toolkit for Oracle CRM On Demand - Source Component

SSIS Integration Toolkit for Oracle CRM On Demand - Destination Component

Oracle CRM On Demand Destination Component

  • The destination component facilitates writing data to Oracle CRM On Demand via web services.
  • Supports bulk data insertion, optimizing the upload process for large datasets to Oracle CRM On Demand and reducing processing time.
  • Provides robust mapping capabilities, allowing users to accurately align SSIS data with corresponding fields in Oracle CRM On Demand for precise data integration and management.
  •  See this component's documentation

Get the Ultimate Edition to start using all integration toolkits, including our SSIS Productivity Pack

DownloadPurchase

Where Our Solutions Fit in Your Workflow

Our solutions are used across a wide range of roles involved in managing
data pipelines, integrations, and enterprise system connectivity.

Data & Integration Engineers

  • Build pipelines using SSIS components

  • Connect APIs, files, and databases

  • Use a fully code-free interface

  • Log and handle integration errors

  • Improve performance with tuning

Enterprise Application Managers

  • Oversee scheduled integration tasks

  • Monitor recurring data sync workflows

  • Track execution of automation steps

  • Review integration run history logs

  • Check scheduled package performance

Solution Designers & Architects

  • Build reusable package templates

  • Enable high-volume data flows

  • Support hybrid system models

  • Align with audit and logging rules

  • Onboard new systems efficiently

More Resources

Download our Data Sheet for
SSIS Integration Toolkit for Oracle CRM On Demand

SSIS Oracle CRM On Demand Toolkit Data Sheet

FAQ

What is the SSIS Integration Toolkit for Oracle CRM On Demand and what does it do?

The SSIS Integration Toolkit for Oracle CRM On Demand is a specialized solution designed to facilitate Oracle CRM On Demand data integration within SSIS packages. It provides components to establish connections, extract data from Oracle CRM On Demand, and write data to Oracle CRM On Demand, streamlining your CRM data synchronization and ETL processes. This toolkit is essential for managing your Oracle CRM data flow.

How do I connect to Oracle CRM On Demand using this toolkit?

To connect to Oracle CRM On Demand, you'll use the Oracle CRM On Demand Connection Manager. You'll need to specify your Web Service URL (e.g., https://secure-ausomx[POD].crmondemand.com/Services/Integration), and your User Name and Password for authentication (Login Credentials in SOAP Security Header). This ensures a secure and active connection for all your Oracle CRM data operations.

Can I retrieve specific data from Oracle CRM On Demand and filter records?

Yes, the Oracle CRM On Demand Source Component allows for granular data extraction from Oracle CRM On Demand. You can select a Source WSDL file to define the available objects and then choose a Source Object (and optionally a Child Object) to read from. Crucially, you can apply a Searchspec Filter using SQL-like syntax to retrieve only the desired records, enhancing efficiency for Oracle CRM reporting and custom CRM On Demand data extracts.

What actions can I perform when writing data to Oracle CRM On Demand?

The Oracle CRM On Demand Destination Component supports several actions for writing data to Oracle CRM On Demand: Create: To insert new records. Update: To modify existing records. Delete: To remove records. Upsert: To either create a new record or update an existing one based on specified matching fields. Note that Upsert is limited to a batch size of 1. These actions provide comprehensive control over your Oracle CRM data management.

How does the toolkit handle errors and provide feedback during data processing?

The Oracle CRM On Demand Destination Component offers robust error handling options. You can choose to Fail on error, Redirect rows to error output, or Ignore error. If you select "Redirect rows to error output," failed records are sent to a separate output with an OracleErrorMessage column, which contains the specific error message from Oracle CRM On Demand. Additionally, for auditing and troubleshooting, you can enable output fields like OracleCrmId (for the new record's ID) and IsNew (to indicate if a record was newly created during an Upsert), making Oracle CRM integration troubleshooting more efficient.

Get in Touch

If you would like to know more specific details about our solutions or if you have any suggestions about our product offerings, we are always here to listen and help!

Contact Us

Help ManualsOracle CRM On Demand Toolkit

Testimonials

Case Studies

Video Tutorials