SSIS Connectivity
Connect to multiple data sources without writing a single line of code
SSIS REST Source
The REST Source in Task Factory allows you to connect to almost any web service or cloud application that uses a REST API and bring the data right into your data flow.
The component supports both legacy (XML based) and newly created (with JSON) REST endpoints.
With its support for Basic REST, OAuth1, and OAuth2 authentication, you can use the REST Source to connect to and extract data from your accounts on platforms such as Zendesk, GoToWebinar, Survey Monkey, and MailChimp.
Azure ML SSIS Components
The three Azure ML components in Task Factory work in conjunction with one another. 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 can take data that needs to be scored by a prediction service, load it to an Azure ML blob storage location, execute an Azure ML prediction or scoring web service, and retrieve the results immediately.
Salesforce.com Source
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 data supported by the Salesforce.com Soap API like leads, accounts, contacts, and opportunities right into your SSIS data flow.
Salesforce.com Destination
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 upsert data into any Salesforce object from within SSIS, then the Salesforce.com Destination makes it super simple with very little configuration. It supports both regular and bulk mode transfer.
Dynamics CRM Source SSIS Connector
The Dynamics CRM Source is an SSIS source component that quickly and easily retrieves data stored in your Dynamics CRM system, whether it’s an on-premises or hosted online account, typically with a few clicks.
The intuitive interface includes advanced filtering capabilities and a data preview pane, so you know the data being retrieved from your Dynamics server is exactly what you need.
Dynamics CRM Destination SSIS Connector
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 typically within minutes.
Supports Office 365, hosted, and on-premises servers.
Twitter Source
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 such as direct messages, timeline statuses, followers, and your own list data.
The built-in Preview tab allows you to test various parameters and see quickly if the data you want is being sent to you from Twitter. This reduces development time significantly because you aren't forced to run the package to see the data being retrieved.
Facebook Source
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 API Endpoints (including the Marketing API).
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 quickly if the data you want is being sent to you from Facebook. This reduces development time significantly because you aren't forced to run the package to see the data being retrieved.
SSIS REST Source
The REST Source in Task Factory allows you to connect to almost any web service or cloud application that uses a REST API and bring the data right into your data flow.
The component supports both legacy (XML based) and newly created (with JSON) REST endpoints.
With its support for Basic REST, OAuth1, and OAuth2 authentication, you can use the REST Source to connect to and extract data from your accounts on platforms such as Zendesk, GoToWebinar, Survey Monkey, and MailChimp.
Azure ML SSIS Components
The three Azure ML components in Task Factory work in conjunction with one another. 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 can take data that needs to be scored by a prediction service, load it to an Azure ML blob storage location, execute an Azure ML prediction or scoring web service, and retrieve the results immediately.
Salesforce.com Source
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 data supported by the Salesforce.com Soap API like leads, accounts, contacts, and opportunities right into your SSIS data flow.
Salesforce.com Destination
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 upsert data into any Salesforce object from within SSIS, then the Salesforce.com Destination makes it super simple with very little configuration. It supports both regular and bulk mode transfer.
Dynamics CRM Source SSIS Connector
The Dynamics CRM Source is an SSIS source component that quickly and easily retrieves data stored in your Dynamics CRM system, whether it’s an on-premises or hosted online account, typically with a few clicks.
The intuitive interface includes advanced filtering capabilities and a data preview pane, so you know the data being retrieved from your Dynamics server is exactly what you need.
Dynamics CRM Destination SSIS Connector
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 typically within minutes.
Supports Office 365, hosted, and on-premises servers.
Twitter Source
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 such as direct messages, timeline statuses, followers, and your own list data.
The built-in Preview tab allows you to test various parameters and see quickly if the data you want is being sent to you from Twitter. This reduces development time significantly because you aren't forced to run the package to see the data being retrieved.
Facebook Source
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 API Endpoints (including the Marketing API).
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 quickly if the data you want is being sent to you from Facebook. This reduces development time significantly because you aren't forced to run the package to see the data being retrieved.
SSIS connectivity components make it simple to access data stored in cloud platforms
Task Factory
- 60+ high-performing SSIS components
- Save time managing tedious data warehousing ETL tasks
- Connect to dozens of data sources