Task and components for SQL Server Integration Services.

Tasks and components for SQL Server Integration Services.

  1. COZYROC task and component suite for SQL Server Integration Services provide you fast and easy ETL.
  2. Cut your ETL development time and accomplish more with our reliable components suite.
  3. Reliable, essential components for developing affordable, world-class ETL solutions with Microsoft SQL Server Integration Services.
  4. These SSIS tasks and components are accessible right from the SSIS Toolbox in Visual Studio.
  5. Learn more at www.cozyroc.com.

Accounting
Overview
Tasks
 
Sources
 
Destinations
 
Transformations
 
Connections
 
REST Adapters
 
API
Freshbooks Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Quickbooks
 
 
Source

Destination

 
 
Connection

 
 
API
Xero Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 

 
 
 
 
 
 
 
 
 
 


 
Administration
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
Google Admin Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
ServiceNow Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
LDAP
 
 
Source

Destination

 
 
Connection

 
 
API

 
 
 
 
 
 
 
 
 
 


 
Analytics
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
Google Analytics Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Google Big Query Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
SAS
 
 
Source

Destination

 
 
Excel Add-In
 


 
QlikView
 
 
Source

Destination

 
 
 
 


 
Tableau Destination
 
 
 
 
Destination

 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 


 
Automation
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
Script Component Plus
 
 
 
 
 
 
Transformation

 
 
 
 
 
Script Task Plus
Task

 
 
 
 


 
 
 
 
 
Data Flow Task Plus
Task

 
 
 
 
 
 
 
 
 
 
 
Sort Plus
 
 
 
 
 
 
Transformation

 
 
 
 
 
Flow Synchronization
 
 
 
 
 
 
Transformation

 
 
 
 
 
JavaScript
Task

 
 
 
 
Transformation

 
 
 
 
API
Lookup
 
 
 
 
 
 
Transformation

 
 
 
 
 
Query
 
 
 
 
 
 
Transformation

 
 
 
 
 
Table Difference
 
 
 
 
 
 
Transformation

 
 
 
 
 
SSH Execute Task
Task

 
 
 
 
 
 
 
 
 
 
 
Parallel Loop Task
Task

 
 
 
 
 
 
 
 
 
 
 
REST
 
 
Source

Destination

 
 
Connection

 
 
API
Stream Task
Task

 
 
 
 
 
 
 
 
 
 
 
Zip Task
Task

 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 


 
CMS
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
SharePoint
 
 
Source

Destination

 
 
Connection

 
 
API
WordPress Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Collaboration
 
 
 
 
 
 
 
 
 
 


 
Asana Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Basecamp Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Google Calendar Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
GoToWebinar Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Jira Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Parature Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Smartsheet Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
SurveyMonkey Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Trello Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Zendesk Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 

 
 
 
 
 
 
 
 
 
 


 
Commerce
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
Magento Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Shopify Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Square Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Zuora Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 

 
 
 
 
 
 
 
 
 
 


 
Communication
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
Jabber Task
Task

 
 
 
 
 
 
 
 
 
 
 
PureCloud Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Receive Mail Task
Task

 
 
 
 
 
 
 
 
 
 
 
Send Mail Task
Task

 
 
 
 
 
 
 
 
 
 
 
Slack Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Twilio Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 

 
 
 
 
 
 
 
 
 
 


 
CRM
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
Dynamics CRM
 
 
Source

Destination

 
 
Connection

 
 
API
Sage
 
 
Source

Destination

 
 
Connection

 
 
API
Salesforce
 
 
Source

Destination

 
 
Connection

 
 
API
SugarCRM
 
 
Source

Destination

 
 
Connection

 
 
API
Zoho CRM Connection
 
 
 
 
 
 
 
 
Connection

 
 
 

 
 
 
 
 
 
 
 
 
 


 
Data Cleansing
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
Address Parse
 
 
 
 
 
 
Transformation

 
 
 
 
 

 
 
 
 
 
 
 
 
 
 


 
Database
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
Database Partitions Task
Task

 
 
 
 
 
 
 
 
 
 
 
DB2 Destination
 
 
 
 
Destination

 
 
 
 
 
 
 
Informix Destination
 
 
 
 
Destination

 
 
 
 
 
 
 
ODBC Destination
 
 
 
 
Destination

 
 
 
 
 
 
 
Oracle Destination
 
 
 
 
Destination

 
 
 
 
 
 
 
Sybase Destination
 
 
 
 
Destination

 
 
 
 
 
 
 
Teradata
 
 
Source

Destination

 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 


 
Education
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
SimplyDigi Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 

 
 
 
 
 
 
 
 
 
 


 
ERP
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
Dynamics AX
 
 
Source

Destination

 
 
Connection

 
 
API
Dynamics GP
 
 
Source

Destination

 
 
Connection

 
 
API
Dynamics NAV
 
 
Source

Destination

 
 
Connection

 
 
API
NetSuite
 
 
Source

Destination

 
 
Connection

 
 
API

 
 
 
 
 
 
 
 
 
 


 
File Formats
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
EDI
 
 
Source

Destination

 
 
Connection

 
 
 
Template Task
Task

 
 
 
 
 
 
 
 
 
 
 
Template
 
 
 
 
 
 
Transformation

 
 
 
 
 

 
 
 
 
 
 
 
 
 
 


 
File Transfer
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
Amazon S3 Task
Task

 
 
 
 
 
 
 
 
 
 
 
Dropbox Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
File Transfer Task
Task

 
 
 
 
 
 
 
 
 
 
 
Google Drive Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
OneDrive Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
SCP Task
Task

 
 
 
 
 
 
 
 
 
 
 
SFTP Task
Task

 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 


 
GIS
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
ArcGIS Feature Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 

 
 
 
 
 
 
 
 
 
 


 
HR
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
Humanity Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
OpenAir
 
 
Source

Destination

 
 
Connection

 
 
API

 
 
 
 
 
 
 
 
 
 


 
Marketing
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
Constant Contact Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
HubSpot Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Mailchimp Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Marketo Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Pardot Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Twitter Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 

 
 
 
 
 
 
 
 
 
 


 
NoSQL
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
MongoDB
 
 
Source

Destination

 
 
Connection

 
 
 

 
 
 
 
 
 
 
 
 
 


 
Productivity
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
Excel
Task

Source

Destination

 
 
Excel Connection

 
 
API
Google Sheets Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Google Tasks Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 
Wunderlist Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 

 
 
 
 
 
 
 
 
 
 


 
Security
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
OpenPGP Task
Task

 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 


 
Transportation
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
Fleet Complete Connection
 
 
 
 
 
 
 
 
 
 
REST Adapter

 

 
 
 
 
 
 
 
 
 
 


 
Not Categorized
Overview
Tasks

Sources

Destinations

Transformations

Connections

REST Adapters

API
SSH Connection
 
 
 
 
 
 
 
 
Connection

 
 
 
Data Flow Source
 
 
Source

 
 
 
 
 
 
 
 
 
Data Flow Destination
 
 
 
 
Destination

 
 
 
 
 
 
 
Amazon S3 Connection
 
 
 
 
 
 
 
 
Connection

 
 
 
Distributed Cache Connection
 
 
 
 
 
 
 
 
Connection

 
 
 
Exchange Connection
 
 
 
 
 
 
 
 
Connection

 
 
 
FTPS Connection
 
 
 
 
 
 
 
 
Connection

 
 
 
IMAP Connection
 
 
 
 
 
 
 
 
Connection

 
 
 
Jabber Connection
 
 
 
 
 
 
 
 
Connection

 
 
 
Package Connection
 
 
 
 
 
 
 
 
Connection

 
 
 
Pop3 Connection
 
 
 
 
 
 
 
 
Connection

 
 
 
SMTP Connection
 
 
 
 
 
 
 
 
Connection

 
 
 
Dynamic Data Flow
 
 
 
 
 
 
 
 
 
 
 
 
 

    Book a Presales Call

     

    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now.