SALESFORCE.COM INTEGRATION PACK FOR SSIS

Salesforce.com Integration Pack for SQL Server Integration Services (SSIS).  SALEFORCE INTEGRATION PACK

SSIS Salesforce Integration Pack is a comprehensive solution that will allow you to systematically integrate Salesforce within SSIS. Components install GU integration directly into Business Intelligent Studio (BIDS) and you can simply drag and drop SSIS custom Salesforce components into your SSIS package. This intuitive interface allows you can read data from Salesforce or Bulk insert/update data into Salesforce. You can also execute any valid Salesforce API calls inside SSIS. Try for yourself and download today.

The Salesforce.com custom components help SSIS developers deliver solutions that fit any data delivery scenario. Save development time and resources by implementing this Salesforce Integration pack into your environment!

Salesforce.com Integration Pack for SQL Server Integration Services (SSIS).

Salesforce.com Integration Lighting Pack

Salesforce.com Source Connection for SQL Server Integration Services (SSIS).    Salesforce.com Source Connection for SSIS

  • Multiple modes to read data from Salesforce CRM (i.e. Table or Query)
  • Support for SOQL Query Language (Salesforce Object Query Language)
  • Support for automatic conversion between UTC date/time and Local date/time
  • Intuitive user interface with Salesforce Object Browser
  • Support for data preview, max rows, batch size
  • Support for Dynamic query (using SSIS Variable placeholder e.g. {{User::MyVar}} )
  • Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)

Salesforce API Task Connection for SQL Server Integration Services (SSIS).    Salesforce.com Destination Task

  • Load data into Salesforce.com from any source with drag and drop user interface
  • Support multiple write operations (e.g. Bulk Insert, Update, Delete, Upsert)
  • Support for executing assignment rule after Update/Insert operation for Case, Lead or Account
  • Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)

Salesforce.com API Connection for SQL Server Integration Services (SSIS).    Salesforce.com API Connection Task

  • Support for calling any Salesforce REST API (RESTful API)
  • Support for calling any Salesforce SOAP API (XML API)
  • Call REST Style HTTP Web Service from SSIS (e.g. Perform HTTP GET, POST, LIST )
  • Save response to variable or file
  • Filter JSON response using JSONPath to extract specific value inside response text
  • Filter XML response using XPath to extract specific value inside response text
  • Validate response using custom rules such as Response Code must be less than 300, Response Content must contain XYZ string, Response Header must contain certain key/value pair … etc
  • Support for Testing UI
  • Support for dynamic variable replacement with format specifiers anywhere inside header or request data (e.g. {{User::MyVar}} {{User::MyDate,yyy-MM-dd}} {{User::MyAmount,C}} )
  • Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)

   
   

Additional SSIS Components for Business Intelligence Studio (BIDS)

Amazon DynamoDB Source for SSIS
Amazon DynamoDB ExecuteSQL
Amazon AWS
Cloud Storage
DynamoDB Integration Pack for SSIS

Amazon Redshift Cluster Mgmt

Amazon Redshift Data Transfer

DynamoDB Source

DynamoDB Source



Download the SSIS Integration Lightning pack for custom components, tasks, and generators for SQL Server Integration Services (SSIS).

Connect to all your Data Sources!

There is more to 'Reaching for the Clouds' than just infrastructure. it’s about building a system that applies to your business and in doing so creating efficiencies and workflow processes that ultimately reduces overall operational costs. Anyone can use technology. It’s about peeling back the onion and truly understanding the reasons behind how and why you are building it. The world as we know it is evolving at rapid speeds, becoming more mobile with each technological advancement.

Connect to Microsoft SQL Azure!

With SQL Azure 99.9% guaranteed uptime and their higly secure billion dollar data centers makes it a logical decision. Can your company guarantee your databases won't be breached? The term 'cloud computing' refers to a variety of Internet-based computing services. The difference between cloud-based and traditional software is that when you access the cloud, your desktop or laptop isn't the thing doing the actual computing, reducing overall operational costs. Check out our SQL Azure Tasks if Microsoft is your cloud choice.

With Amazon leading the charge in Cloud Computing . Reach for the Clouds, Inc. had to supply it's clients a way to move their data to Amazon Cloud. Can your company guarantee your databases won't be breached? The term 'cloud computing' refers to a variety of Internet-based computing services. The difference between cloud-based and traditional software is that when you access the cloud, your desktop or laptop isn't the thing doing the actual computing, reducing overall operational costs. Check out our Amazon Tasks and Adapters.

Reach for the class has a staff that has been delivering Microsoft SSIS products for the last decade for SQL Server. Schedule a demo or simply trial the software for free. We are here to make you experience a truly successful one so please do not hesitate to reach out to our certified cloud professionals.

There is more to 'Reaching for the Clouds' than just infrastructure. it’s about building a system that applies to your business and in doing so creating efficiencies and workflow processes that ultimately reduces overall operational costs. Anyone can use technology. It’s about peeling back the onion and truly understanding the reasons behind how and why you are building it. The world as we know it is evolving at rapid speeds, becoming more mobile with each technological advancement.

Reach for the Clouds focuses on delivering modern business solutions that are innovative and proactive, connecting organizations with their people and their ecosystem, allowing organizations to deploy individual business scenarios.

Connect to all your Data Sources!

There is more to 'Reaching for the Clouds' than just infrastructure. it’s about building a system that applies to your business and in doing so creating efficiencies and workflow processes that ultimately reduces overall operational costs. Anyone can use technology. It’s about peeling back the onion and truly understanding the reasons behind how and why you are building it. The world as we know it is evolving at rapid speeds, becoming more mobile with each technological advancement.

Connect to all your Data Sources!

There is more to 'Reaching for the Clouds' than just infrastructure. it’s about building a system that applies to your business and in doing so creating efficiencies and workflow processes that ultimately reduces overall operational costs. Anyone can use technology. It’s about peeling back the onion and truly understanding the reasons behind how and why you are building it. The world as we know it is evolving at rapid speeds, becoming more mobile with each technological advancement.

Connect to all your Data Sources!

There is more to 'Reaching for the Clouds' than just infrastructure. it’s about building a system that applies to your business and in doing so creating efficiencies and workflow processes that ultimately reduces overall operational costs. Anyone can use technology. It’s about peeling back the onion and truly understanding the reasons behind how and why you are building it. The world as we know it is evolving at rapid speeds, becoming more mobile with each technological advancement.