最新版 KingswaySoft SSIS Integration Toolkit for Microsoft Dynamics 365 v23.2 更新於
2023/11/23
SSIS Integration Toolkit - Ultimate Edition
One license key, any SSIS Integration Toolkit
SSIS集成工具包提供靈活且易於使用的經濟高效,無代碼,高性能的數據集成解決方案。
我們的解決方案基於Microsoft SQL Server,利用SQL Server Integration Services作為ETL平台,可實現與幾乎任何應用程序或數據庫系統的數據集成。
Ultimate Edition包括用於多個企業應用程序(如Microsoft Dynamics 365,Salesforce,SharePoint等)的數據集成解決方案,以便於在各種應用程序或數據庫之間檢索和寫入數據。Ultimate Edition還包括SSIS Productivity Pack,這是一系列先進的SSIS組件,可以提高開發人員的工作效率。
KingswaySoft SSIS
- 當您需要我們的兩種或更多產品時,這是一種簡化且經濟高效的解決方案
- 一個許可證密鑰,用於啟用所有SSIS Integration Toolkit和SSIS Productivity Pack產品。
- 超過150種優質和獨特的SSIS組件,無需任何自定義腳本即可實現快速ETL開發。
- 包括數十個連接管理器,可與幾乎任何應用程序或數據庫系統連接和集成,包括對40多個應用程序的專用支持。
- 接收數十種額外的連接和生產力增強解決方案,以簡化數據集成開發。
- 訪問任何新的SSIS Integration Toolkit產品並在發布後立即更新。*
The SSIS Integration Toolkit - Ultimate Edition is the must-have collection for all KingswaySoft SSIS Integration products. Click on the products below to learn more about each solution included with the Ultimate Edition.
Data Integration Application Connectivity Solutions
CRM Applications
Marketing Applications
Directory Services
Content Management
Google Services
|
ERP Applications
HRIS Applications
Development Platform
Collaboration
Message Queue
|
Accounting & Commerce
Customer Service
Cloud Storage
NoSQL
|
Data Integration Productivity Enhancements
SSIS Productivity Pack |
||
|
|
Microsoft Dynamics 365 Integration Software
Data integration development can be done in minutes, instead of weeks or months
SSIS Integration Toolkit for Microsoft Dynamics 365 offers the greatest flexibility, performance, and ease of use.
Loaded with advanced options and configurable settings, SSIS Integration Toolkit for Microsoft Dynamics 365 is a developer's choice for codeless data integration for Microsoft Dynamics 365.
Data Integration for Microsoft Dynamics 365 made easy
Support for Customer Engagement, Finance & Operations, & Business Central, Common Data Service (CDS), Microsoft Dynamics CRM, AX, & NAV
- Powered by the powerful SSIS ETL engine, developers can quickly integrate Microsoft Dynamics 365 with virtually any other application or data system.
- Full support for Dynamics 365, CRM, AX (Finance & Operations), NAV (Business Central), CDS, and PowerApps means easy integration between applications and versions as well as a simple data migration path for application upgrades.
- An extremely simplified ETL development experience within a familiar development environment (Microsoft Visual Studio) provides developers the best possible development productivity.
- Available on its own or as part of a package with our other enterprise data integration solutions in our Ultimate Edition including SharePoint, HubSpot, Active Directory and the SSIS Productivity Pack to enhance development productivity.
Key Benefits
• Complimented by SSIS capabilities, the SSIS Integration Toolkit is most feature-rich data integration solution for Microsoft Dynamics 365, which enables data integration between Microsoft Dynamics 365, CRM, NAV, AX, CDS, PowerApps and virtually any other database or application systems.
• Utilizing the codeless data integration approach, you can forget all intricate details involved in working with Microsoft Dynamics web service interfaces when developing data integration solutions.
• Easy learning curve, consistent application user interface, familiar development experience, all adds up to an improved development experience.
• Offers many specifically designed features that help you achieve the best possible performance without sacrificing your IT budget.
Below are the components included with the SSIS Integration Toolkit for Microsoft Dynamics 365 and just some of their many technical features.
SSIS Integration Toolkit for Microsoft Dynamics 365
Microsoft Dynamics 365 CE/CRM
CRM/CDS Connection Manager
• Supports connections to 365 Customer Engagement, CRM 3.0 - 2016, and CDS.
• Option to work around intermittent errors by making retry service calls.
CRM/CDS Source Component
• Facilitates reading data from Microsoft Dynamics 365 CE/CRM using either Entity, FetchXML query, EntityChanges or AuditLog option.
• The most sophisticated support of any complex FetchXML queries.
CRM/CDS Destination Component
• Facilitates writing data into Microsoft Dynamics 365 CE/CRM using Create, Update,Delete, Upsert, Merge, Convert, Send, Bulk Delete, or ExecuteWorkflow write actions.
• Four different matching options when performing Update or Upsert: Primary Key,CRM Duplicate Detection, Manually Specified Fields, & CRM Alternate Key.
• Support of utilizing CRM Bulk Data API.
• Equipped with many configurable options,Text Lookup feature makes CRM lookup references painlessly easy.
• Support for CRM many-to-many relationship without requiring writing a single line of code.
• Support for a transparent handling of special CRM fields.
• Many advanced options are offered for special integration scenarios.
• Support for multithreaded writing using one single configuration.
CRM OptionSet Mapping Component
• Provides a consistent way to manage thetranslation and mapping of CRM OptionSetvalues.
Microsoft Dynamics 365 BC/NAV
NAV Connection Manager
• Supports connections to Microsoft Dynamics 365 Business Central and NAV 2009 - 2018.
• Support for multitenant deployment.
• Option to work around intermittent errors by making retry service calls.
NAV Source Component
• Facilitates reading data from Microsoft Dynamics 365 BC/NAV via Web Services.
• Option to filter data using Page Filtering query with support for User and System Variables.
NAV Destination Component
• Support for Create, Update, Delete, Upsert actions.
• Upsert action is based on manually selected matching field(s) with several options to handle multiple matches.
• 3 Error Handling Mechanism with 2 additionalconfigurable Default Output columns:
• Key
• IsNew
• Advanced filtering features for NAV field mappings.
• Support for multithreaded writing using one single configuration.
Microsoft Dynamics 365 FO/AX
AX Connection Manager
• Supports connections to Microsoft Dynamics 365 Finance & Operations and AX 4.0 - 2012 R3.
AX Source Component
• Facilitates reading data from Microsoft Dynamics 365 FO/AX using query with support for User and System Variables.
• Option to specify AX fields to retrieve for specified objects.
AX Destination Component
• Support to write to the AX server using Create, Update, Delete, and Upsert actions.
• Upsert action is based on manually selected matching field(s) with the option to ‘Ignore Unchanged Fields.’
• 3 Error Handling Mechanism with additional configurable columns:
• AxRecId
• IsNew
• Advanced filtering capabilities for AX field mappings.
• Support for multithreaded writing using one single configuration.
AX Next Sequence Number Component
• Retrieves the next sequence number from the AX server to use as the input for one of the input columns within the AX Destination component.
系統需求
SSIS Integration Toolkit for Microsoft Dynamics 365
Software Prerequisites
To use SSIS Integration Toolkit for Microsoft Dynamics 365, you need to have the following software:
Azure-SSIS Integration Runtime, or, Microsoft SQL Server 2022, 2019, 2017, 2016, 2014, or 2012
NetSuite Data Integration
Easily develop codeless data integration for NetSuite using SSIS
High performance data integration software for NetSuite that is powerful, flexible, efficient, reliable and easy to use.
Built on the powerful and flexible SSIS ETL engine, the SSIS Integration Toolkit for NetSuite makes data integration easy enabling codeless data integration with NetSuite and virtually any other application or database system.
The SSIS Integration Toolkit for NetSuite
- Data integration can be done in a matter of minutes when using this powerful integration toolkit.
- Utilizes Microsoft SSIS as the data integration platform to take advantage of the flexibility and power of the SSIS ETL engine.
- Intuitive user interface to manage different aspects of your integration development in a codeless, drag and drop environment.
- Develop simple to complex data integration jobs without ever having to write a single line of code.
- A simple development process with built in features to help ease the process even further, including automatic field mapping.
- NetSuite data integration with virtually any other application or data source through other SSIS components and the Ultimate Edition which includes Salesforce, SharePoint, Magento, HubSpot and many more.
Unique Features
- Built in retry on intermittent errors helps eliminate integration disruptions due to temporary service outages or disruptions.
- Read from Common, Custom or Advanced NetSuite objects.
- Column/field filtering capabilities to retrieve only the data you need.
- Support for reading from and writing to Child Objects
- Write to NetSuite using 4 different write actions: Create, Update, Delete or Upsert.
- Support for adding custom fields to read from or write to.
- Automatic field mapping based on a name-match.
系統需求
Technical Requirements
NetSuite
SQL Server Integration Services, either:
- Azure-SSIS Integration Runtime,
- 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.
Salesforce CRM Integration Software
Your robust, cost effective Salesforce integration solution
Experience more features and greater performance for your Salesforce data integration project.
The SSIS Integration Toolkit for Salesforce is the most performant and feature rich data integration solution for Salesforce on the market. With a meticulously designed software that leverages the power of the SSIS ETL engine for a familiar development experience, your integration job can be completed 3 to 10 times faster.
Salesforce CRM Integration
- An extremely simplified ETL development experience within a familiar development environment (Microsoft Visual Studio) provides your developers the best possible development productivity.
- Intuitive user interface to manage different aspects of your integration development in a codeless, drag and drop environment.
- Robust error handling and superior performance.
- Text Lookup feature makes Salesforce lookup references painlessly easy and it comes with many configurable options.
- Includes support for writing to Salesforce Wave Analytics using the Salesforce Wave Destination component.
- Equipped with many specifically designed integration options, the SSIS Integration Toolkit is the most flexible solution to read from or write to Salesforce.
- Integration can be done with virtually any application or data source that you may need to work with, including NetSuite, HubSpot, Microsoft SharePoint, Active Directory and any other solution available in the Ultimate Edition.
Unique Features
- "Retry on intermittent errors" to deal with transient network or server problems in a robust fashion.
- Read data from either a Salesforce object or using SOQL query
- The most sophisticated support for SOQL queries, including the support for child-to-parent relationship, aggregation, datetime functions, and parameterized queries that utilize SSIS variables.
- Support for Salesforce bulk API
- "Refresh Salesforce Metadata" feature makes it easy to update components to latest Salesforce metadata without having to delete and re-create them.
- Seven different write actions for writing to Salesforce server: Create, Update, Delete, Upsert, Merge, HardDelete, and UnDelete.
- Automatically maps all available input columns to the corresponding Salesforce fields by matching their names.
- Text Lookup feature to perform a lookup to Salesforce records using either text or integer values as the input
- "Ignore Null-Valued Fields" to avoid overwriting existing values with an empty value.
- Write to Salesforce Wave Analytics using Append, Delete, Overwrite and Upsert operations.
系統需求
Technical Requirements
- Salesforce CRM, either:
- Salesforce Professional Edition,
- Salesforce Enterprise Edition, or,
- Salesforce Unlimited Edition.
- Big Data
- Salesforce Wave Analytics (Einstein Analytics)
- Marketing
- Salesforce Marketing Cloud
- Microsoft SQL Server Integration Services, either:
- Azure-SSIS Integration Runtime,
- 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.
SSIS Integration Toolkit for Microsoft Dynamics GP
- Data integration can be done in a matter of minutes when using this powerful integration toolkit.
- Utilizes Microsoft SSIS as the data integration platform to take advantage of the flexibility and power of the SSIS ETL engine.
- Develop simple to complex data integration jobs without ever having to write a single line of code.
- A simple development process with built in features to help ease the process even further, including built-in SQL Query builder and automatic field mapping.
- Includes GP Connection Manager, GP Source component, GP Destination component and the bonus GP Next Document Number Generator Component.
- GP data integration with virtually any other application or data source through other SSIS components and the Ultimate Edition which includes Microsoft Dynamics CRM, SharePoint, Active Directory, Salesforce and many more.
- Write custom SQL queries or simply choose a source object to retrieve data.
- Column/field filtering capabilities to retrieve only the data you need.
- Write to Microsoft Dynamics GP using 4 different write actions: Create, Update, Delete or Void.
- Automatically maps fields to establish associations between input columns and GP fields.
- NextDocNumber component can be used to generate new sequential IDs for transnational objects.
SSIS Integration Toolkit for Microsoft Dynamics SL
- Simple, straightforward and cost effective data integration built to handle the intricate details of working with Microsoft Dynamics SL web service interfaces.
- Immersive development productivity thanks to the easy learning curve and familiar development experience using Microsoft Visual Studio as the ETL development tool.
- Easy-to-use, codeless solution that enables integration to occur in a matter of minutes for what could otherwise take months of development.
- Variety of functional buttons to better support the development process.
- Takes advantage of the flexibility and power of the SSIS ETL engine to integrate with virtually any application or data source.
- Available as a stand-alone product or as part of the Ultimate Edition which includes Microsoft Project Server, Microsoft Dynamics 365, OneDrive, Salesforce and many more.
- Built in retry on intermittent errors helps eliminate integration disruptions due to temporary service outages or disruptions.
- Support for working with Child Objects in both reading and writing.
- Can specify both the source object and child object properties and provide filtering criteria for each.
- Write based on the primary key for both the source object and the child object.
- Write to Microsoft Dynamics SL through either Create, Update, or Delete actions.
SSIS Integration Toolkit for Directory Services
- High performing data integration for Active Directory and Azure Active Directory using SSIS.
- Immersive development productivity thanks to the easy learning curve and familiar development experience using Microsoft Visual Studio.
- Easily manage massive number of Active Directory Users and Groups.
- Maintain User's Group memberships effortlessly.
- Read and write to various Directory attributes including custom and array attributes from Users and Groups.
- Disable or enable massive number of User accounts instantly.
- Built in search function so developers can quickly find the fields required.
- Synchronize user account information with virtually any external data source that SSIS can read/write to including Microsoft Dynamics, SharePoint and any other components available in KingswaySoft's Ultimate Edition.
- A much simplified connection manager makes it easy to communicate with Active Directory.
- Read data from Active Directory user, group, computer records with support of any custom fields.
- Support of using Search Criteria to filter data in LDAP filtering format.
- Capability to specify container path to narrow your search scope.
- Active Directory Destination Component supports 5 different write actions: Create, Update, Upsert, Move, and Delete.
- Active Directory Destination Component supports massive data manipulation of the following objects.
- User - Create, update, or delete active directory users.
- Group - Create, update, or delete active directory groups.
- GroupMembership - Add users to, or remove users from active directory groups.
SSIS Integration Toolkit for Microsoft SharePoint
- Take advantage of the freedom, flexibility and power of the SSIS ETL engine to facilitate Microsoft SharePoint data integration.
- Performant and easy-to-use SSIS components to quickly connect, read and write to Microsoft SharePoint Online or On-Premise.
- Option to retrieve data from SharePoint using CAML query filters built in the Query Designer.
- Manage your SharePoint flat files with 3 bonus SSIS components included with the toolkit.
- Integrate your SharePoint data with virtually any application or database system including Microsoft Dynamics 365, Salesforce, Marketo, SQL Databases and Oracle Databases.
- Available on its own or as part of a package with our other enterprise data integration solutions in our Ultimate Edition.
- Write to SharePoint lists and document libraries using 7 different write actions: Create, Update, Delete, CreateFolder, CheckIn, CheckOut, and Moderate.
- Support for downloading and uploading of attachments in SharePoint list items.
- Support for multithreaded writing using one single configuration.
- Query Designer allows you to design CAML Query directly within the SharePoint Source Component.
- Manage SharePoint flat files with SSIS Productivity Pack's Premium Flat File Source, Destination and File Transfer Task components included.
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.
- Synchronize data with virtually any external data source that SSIS can read/write to including Microsoft Dynamics ERP, SharePoint, HubSpot and any other components available in the Ultimate Edition.
- 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.
SSIS Integration Toolkit for QuickBooks
- High performing data integration for QuickBooks Online and On-Premise using SSIS.
- Take advantage of the flexibility and power of the SSIS ETL engine.
- Intuitive user interface to manage different aspects of your integration development.
- Integration without having to write a single line of code, allowing the development process to be done quickly and easily.
- Immersive development productivity thanks to the easy learning curve and familiar development experience using Microsoft Visual Studio.
- Robust error handling and superior performance.
- Synchronize QuickBooks data with virtually any external data source that SSIS can read/write to including Microsoft Dynamics 365, Active Directory, SharePoint and any other components available in the Ultimate Edition.
- Built in retry on intermittent errors helps eliminate integration disruptions due to temporary service outages or disruptions.
- Easy to use filtering parameters to retrieve only the data you need to work with.
- 4 different actions for writing to Quickbooks: Create, Update, Soft Delete, or Hard Delete.
- Automatic field mapping based on a name-match.
- Use the QuickBooks Token Manager to export tokens from the development machine and then import them in to the integration server.
- Line items support brings unique flexibility and enables the ability to read/write individual line items from a primary entity.
SSIS Integration Toolkit for Magento
- High-performance, easy-to-use, cost-effective data integration solution for Magento.
- Easily synchronize your commerce data with your ERP and CRM systems.
- Freedom, flexibility and power of the SSIS ETL engine that helps you create the most sophisticated integration solutions for Magento.
- SSIS Data Flow Components built exclusively for Magento to address the unique aspects of working with Magento data.
- Several configurable settings and options to retrieve only the data needed from Magento.
- Build simple to complex integration scenarios with Magento and virtually any other application or database system including Microsoft Dynamics 365, Dropbox, Salesforce and any other application found in our Ultimate Edition.
- Built in retry on intermittent errors helps eliminate integration disruptions due to temporary service outages or disruptions.
- Full support to read from Magento Child Objects and attributes.
- Support for Object source Search Parameters for easy advanced filtering options.
- Write to Magento through 3 different write actions (Post, Put, Delete) which allow you to create, update, upsert or delete data from Magento.
- Sophisticated Error Handling options allows you to specify how errors should be handled if they occur.
SSIS Integration Toolkit for HubSpot
- High-performance, easy-to-use, codeless data integration solution for HubSpot.
- Freedom, flexibility and power of the SSIS ETL engine.
- Quick integration development and scheduling that can be done in minutes.
- OAuth authentication that uses tokens to access your data makes your integration development easier by assisting you in moving your tokens from machine to machine.
- Respects the API Throttle Rate to prevent HubSpot server from declining request.
- Retrieve HubSpot records based on search parameters and other filter criteria.
- Build unique integration scenarios with HubSpot and virtually any other application or database system.
- Available on its own or as part of a package with our other enterprise data integration solutions in the Ultimate Edition including Microsoft Dynamics CRM and ERP, Dropbox, Salesforce and many more.
- Retry on Intermittent Error option to automatically recover from possible intermittent outages or disruption of service so the integration does not have to be stopped due to temporary issues.
- Specify filtering parameters to only return records that meet the requirements.
- Write to HubSpot using 1 of 4 different write actions: Create, Update, Upsert or Delete.
- Use the Token Manager to Add, Remove, Import or Export tokens and manage the transfer of tokens from the development machine to the SQL Server.
SSIS Integration Toolkit for Marketo
- High-performance, easy-to-use, cost-effective data integration solution for Marketo.
- Freedom, flexibility and power of the SSIS ETL engine that helps you create the most sophisticated integration solutions for Marketo.
- SSIS Data Flow Components built exclusively for Marketo to address the unique aspects of working with Marketo data.
- Built in Duplicate Detection based on specified field(s).
- Several configurable settings and options to retrieve only the data needed from Marketo.
- Full support for integrating with Marketo Custom Objects.
- API Throttling to respect the Marketo API Throttle limit.
- Build simple to complex integration scenarios with Marketo and virtually any other application or database system including Microsoft Dynamics CRM and ERP, Dropbox, Salesforce and any other application found in our Ultimate Edition.
- API Throttling Rate setting for Throttle Limits implementation in Marketo.
- Support for parameters to filter and retrieve data.
- Retrieve multiple Lead Activity Types at once.
- Write to Marketo through 5 different write actions: Create, Update, Upsert, Merge or Delete.
- Identifier Field allows developers to select the field they would like to be used as the primary field and can be used as a key field for deduplication.
- Dedupe (de-duplicate) based on the Dedupe Fields or the Id Field.
SSIS Integration Toolkit for Microsoft Project Server
- High performing data integration for Microsoft Project Server using SSIS.
- Take advantage of the flexibility and power of SSIS ETL engine.
- Intuitive user interface to manage different aspects of your integration development in a codeless, drag and drop environment.
- Robust error handling and superior performance.
- Immersive development productivity thanks to the easy learning curve and familiar development experience using Microsoft Visual Studio.
- Integrate with virtually any application or data source.
- Available on its own or as part of a package with our other enterprise data integration solutions in our Ultimate Edition including Microsoft Dynamics 365 and SL, SharePoint, Salesforce and many more.
- 7 available objects to retrieve data from: Project, Task, Timesheet, TimesheetAction, TimesheetLine, TimesheetLineDetails, or Resource.
- Specify which data store you are working with (PublishedStore, VersionsStore, WorkingStore or ReportingStore).
- 5 different actions for writing to Project Server: Create, Update, Upsert, Delete or Publish.
- Automatic field mapping based on a name-match.
- Includes Implicit Text Lookup functionality.
SSIS Integration Toolkit for Team Foundation Server
- Data integration can be done in a matter of minutes when using this powerful integration toolkit.
- Utilizes Microsoft SSIS as the data integration platform to take advantage of the flexibility and power of the SSIS ETL engine.
- Intuitive user interface to manage different aspects of your integration development in a codeless, drag and drop environment.
- Develop simple to complex data integration jobs without ever having to write a single line of code.
- A simple development process with built in features to help ease the process even further, including automatic field mapping.
- TFS data integration with virtually any other application or data source through other SSIS components and the Ultimate Edition which includes Project Server, Salesforce, SharePoint, Microsoft Dynamics 365 and many more.
- Built in retry on intermittent errors helps eliminate integration disruptions due to temporary service outages or disruptions.
- Option to retrieve TFS data based on on predefined or custom queries.
- Option to retrieve attachments and comments.
- Write to TFS using Create, Update, Delete, or Upsert actions.
- Automatic field mapping based on a name-match.
SSIS Integration Toolkit for Oracle Marketing Cloud
- Data integration for Oracle Marketing Cloud can be done in a matter of minutes when using this powerful integration toolkit.
- Utilizes Microsoft SSIS as the data integration platform to take advantage of the flexibility and power of the SSIS ETL engine.
- Intuitive user interface to manage different aspects of your integration development in a codeless, drag and drop environment.
- Develop simple to complex data integration jobs without ever having to write a single line of code.
- A simple development process with built in features to help ease the process even further, including automatic field mapping.
- Currently supports integration with Oracle Eloqua with the ability to integrate with additional Oracle Marketing Cloud products using components found in our Ultimate Edition.
- Ultimate Edition includes support for integration with virtually any other application or database system such as Salesforce, NetSuite, Oracle CRM On Demand, and many more.
- Built in retry on intermittent errors helps eliminate integration disruptions due to temporary service outages or disruptions.
- Support for retrieving data from child objects with additional column configuration.
- Source object parameter settings adapt to the selected object's specific parameter options.
- Column/field filtering capabilities to retrieve only the data you need.
- Write to Oracle Eloqua using Create, Update, Upsert or Delete write actions.
- Supports secondary inputs for writing to child objects.
- Automatic field mapping based on a name-match.
Microsoft Dynamics GP Technical Requirements
Microsoft Dynamics GP, either: |
SQL Server Integration Service, either: |
Microsoft Dynamics SL Technical Requirements
- Dynamics SL, either:
- Dynamics SL 2018,
- Dynamics SL 2015, or,
- Dynamics SL 2011.
- 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.
NetSuite Technical Requirements
- 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.
Salesforce Technical Requirements
- Salesforce CRM, either:
- Salesforce Professional Edition,
- Salesforce Enterprise Edition, or,
- Salesforce Unlimited Edition.
- Big Data
- Salesforce Wave Analytics (Einstein Analytics)
- Marketing
- Salesforce Marketing Cloud
- 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.
Microsoft Dynamics GP Technical Requirements
- Microsoft Dynamics GP, either:
- Microsoft Dynamics GP 2018,
- Microsoft Dynamics GP 2016,
- Microsoft Dynamics GP 2015,
- Microsoft Dynamics GP 2013,
- Microsoft Dynamics GP 2010, or,
- Microsoft Dynamics GP 10.0.
- SQL Server Integration Service, 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.
Microsoft Dynamics SL Technical Requirements
- Dynamics SL, either:
- Dynamics SL 2018,
- Dynamics SL 2015, or,
- Dynamics SL 2011.
- 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.
Directory Services Technical Requirements
- Any of the following directory services
- Microsoft Active Directory, either Active Directory (On-Premises), or, Azure Active Directory (on the cloud).
- Any LDAP-compatible directory services
- Google Directory
- 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.
Microsoft SharePoint Technical Requirements
- Microsoft SharePoint, either,
- Microsoft SharePoint Online (Office 365),
- Microsoft SharePoint 2019,
- Microsoft SharePoint 2016,
- Microsoft SharePoint 2013,
- Microsoft SharePoint 2010, or,
- Microsoft SharePoint 2007.
- SQL Server Integration Service, either:
- Azure Data Factory,
- 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 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.
- Microsoft SQL Server Integration Services, either:
- Oracle CRM On Demand WSDL Files (see Help Manual for details)
QuickBooks Technical Requirements
- QuickBooks, either:
- QuickBooks Online Subscription, or,
- QuickBooks Desktop
- 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, or,
- Microsoft SQL Server 2008 R2.
HubSpot Technical Requirements
- HubSpot Supported Browser
- 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, or,
- Microsoft SQL Server 2008 R2.
Marketo Technical Requirements
- 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, or,
- Microsoft SQL Server 2008 R2.
Microsoft Project Server Technical Requirements
- Microsoft Project Serve, either:
- Microsoft Project Server Online, or,
- Microsoft Project Server On-Premises.
- Microsoft SQL Server Integration Service, 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.
Team Foundation Server Technical Requirements
- Team Foundation Server
- 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, or,
- Microsoft SQL Server 2012.
Oracle Marketing Cloud Technical Requirements
- Oracle Marketing Cloud
- Oracle Eloqua
- 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.