SSIS Integration Toolkit for Oracle CRM On Demand is a unique tool utilizing SSIS capabilities to perform high-performance data integration.

Data integration that is straightforward and offers powerful and robust integration performance.

The SSIS Integration Toolkit for Oracle CRM On Demand

  • High-performing data integration for Oracle CRM On Demand using SSIS.
  • Take advantage of the flexibility and power of SSIS ETL engine with a codeless data integration approach.
  • Immersive development productivity thanks to the easy learning curve and familiar development experience using Microsoft Visual Studio.
  • Advanced field and column filtering to pull only the necessary data needed.
  • Unique options to support both parent and child objects.
  • Powered by modern cryptography and authentication technologies for secure connections, such as TLS 1.2, SHA-256, etc.
  • Synchronize data with virtually any external data source that SSIS can read/write to including Microsoft Dynamics 365, SharePoint, HubSpot and any other components available in the Ultimate Edition.
Oracle CRM On Demand Data Integration

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

D. Ng

Senior DBA

ASCO

Unique Features


  • 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.
  • Separate searchspec query filter fields for parent and child objects.
  • 4 different actions for writing to Oracle CRM On Demand: Create, Update, Delete, or Upsert.
  • Automatic field mapping based on a name-match.

Technical Requirements


  • Microsoft SQL Server Integration Services, either:
    • Microsoft SQL Server Integration Services, either:
      • Azure-SSIS Integration Runtime,
      • Microsoft SQL Server 2022,
      • Microsoft SQL Server 2019,
      • Microsoft SQL Server 2017,
      • Microsoft SQL Server 2016,
      • Microsoft SQL Server 2014,
      • Microsoft SQL Server 2012,
      • Microsoft SQL Server 2008 R2, or,
      • Microsoft SQL Server 2008.
    • Oracle CRM On Demand WSDL Files (see Help Manual for details)

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.

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 offers many specifically designed features that help you achieve the best possible performance without having to hijack your budget.