With Task Factory and its connectivity components, you're given the power to access data stored in cloud-based platforms such as Salesforce, Microsoft Dynamics, SharePoint, Twitter, Facebook, and virtually any REST-enabled application. All without writing a single line of code.
The REST Source in Task Factory allows you to connect to almost any web
The component can handle both XML and JSON data being returned from the REST endpoints which means it supports both legacy (XML based) and newly created (with JSON) REST endpoints.
With
Before using the Azure ML Batch Execution Task, you can load source data from your local systems to be used during the execution of the Azure ML Prediction Web Service.
The Azure ML Storage Destination is used to load data to the Azure
You simply configure the Azure ML Destination to map your local source data to the Azure ML file that is expected during execution and go. The component takes care of creating the file and uploading it to the Azure blob storage for you.
After executing the Azure ML Batch Task, there will be a resulting file written by the
The Azure ML Storage Source is used to download this file and output it as source data that can be used in your data flow.
This
Each Azure ML Prediction / Scoring web service has an endpoint that can be used to kick off running a batch execution process.
The Azure ML Batch Execution Task
The Azure ML Batch Execution Task can be used with the Azure ML Storage Destination and Azure ML Storage Source to insert data before a batch execution and then retrieve the results of a batch execution.
*Must have an Azure ML account to use this task.
The three components in Task Factory for Azure ML all work in conjunction with each other. You don't have to use all three to execute an Azure ML / Prediction Web Service batch, but the Source and Destination give you the power to load data to Azure ML before a batch execution and retrieve data from Azure ML after a batch execution.
When using all three components together you will be able to take data that needs to be scored by a prediction service, load it to an Azure ML blob storage location, execute an Azure ML
The Salesforce.com Source SSIS connector is used to quickly and easily retrieve data stored in your Salesforce.com account with a few simple clicks.
If you need to import data from Salesforce for in-house processing, the Salesforce.com Source allows you to retrieve any data supported by the Salesforce.com Soap
Within 5 minutes, you’ll be pulling Salesforce data into your local environment.
The Salesforce.com Destination SSIS connector is used to send data from your local environment to your Salesforce.com account.
If you need to insert, update, delete, or
*Must have an enterprise salesforce.com account to use this task. This is a salesforce.com requirement.
*Task Factory now supports the TLS 1.2 encryption, as required by Salesforce.
The Dynamics CRM Source is an SSIS source component that quickly and easily retrieves data stored in your Dynamics CRM system whether it’s on-premise or hosted online account with a few simple clicks.
The intuitive interface includes advanced filtering capabilities, as well as a data preview pane so you know the data
The Dynamics CRM Destination is an SSIS destination component that gives you complete control over the data stored in your Dynamics CRM server.
The component allows you to insert, update, upsert and delete data stored in your Dynamics CRM Server.
The user interface makes mapping your source data to the Dynamics entity quick and painless. You'll be controlling your Dynamics data within minutes.
Supports Office 365, hosted and on-premise servers.
The Twitter Source is an SSIS source component that gives you the ability to connect to your Twitter account to retrieve information available from the Twitter Rest API Endpoints.
These endpoints contain information like direct messages, timeline statuses, followers and your own list data, among others.
The built-in Preview tab allows you to test various parameters and see right
The Facebook Source is an SSIS source component that gives you the ability to connect to your Facebook account to retrieve data from the Facebook Graph
These endpoints give you access to information like status updates, friends, comments and inbox messages.
The built-in Preview tab allows you to test various parameters and see right
A Task Factory license is not required to use Task Factory when developing and running packages in Visual Studio/SSDT. However, a Task Factory license is required to use Task Factory for packages run outside of Visual Studio/SSDT.
65+ SSIS tasks and components
Subscription pricing is based on a 12-month term paid in advance, with automatic renewal at the end of the term.