Task Factory System Requirements

Download: For more information about Task Factory pricing or downloading a trial, see the Task Factory product page.

System Requirements

Hardware

Hardware Requirements

Component
Minimum Requirements
Recommended Requirements
MemoryFour GBAt least eight GB
Processor Speed1.4 GHz2.0 GHz or higher
Process TypeNot Applicable
  • AMD Opteron
  • AMD Athlon 64
  • Intel Xeon with Intel EM64T support
  • Intel Pentium IV with EM64T support

Note:  Hardware requirements can vary based on workloads and other processes.

Important:  Running Task Factory on a virtual machine is slower than running natively because of the overhead of virtualization.

Software

Software Requirements

The following is required to use Task Factory:

  • SQL Server Integration Services 2012, 2014, 2016, or 2017.
  • SQL Server Data Tools 2012, 2014, 2016 (for Visual Studio 2015), or 2017 (for Visual Studio 2015 or 2017).

Note:  SSDT is a development environment requirement, however, it's not required on a server installation.

The following operating systems are supported by Workbench:

64-bit (x64) Operating Systems:
32-bit (x86) Operating Systems:
Windows Server 2003 (at least Service Pack 2) *Windows XP (at least Service Pack 3)
Windows Vista (at least Service Pack 2)Windows Server 2003 (at least Service Pack 3) *
Windows Server 2008 R2Windows Vista (at least Service Pack 2)
Windows Server 2012Windows Server 2008 R2
Windows Server 2016Windows Server 2012
Windows 7Windows 7
Windows 8Windows 8
Windows 10Windows 10

Important:  Windows XP and Server 2003 have been deprecated from full support. Any issues encountered on either Windows XP or Server 2003 must be reproducible on newer versions of Windows to be eligible for support.

Warning: A few of our customers have encountered issues with Windows Server 2003 installations of Task Factory. Packages with Task Factory may not run until the Windows 2003 server is restarted. If you are planning on installing Task Factory on Windows 2003, please wait until you can reboot the machine or restart the SSIS Service after installation.

Additional

Additional Requirements

The following are Oracle Upsert Destination Requirements:

For 64-bit Task Factory:
For 32-bit Task Factory:
  • 64-bit Oracle Data Access Components (ODAC) 11g with Oracle Developer Tools for Visual Studio
  • 64-bit Oracle 12c Managed Data Access Client
  • 32-bit Oracle Data Access Components (ODAC) 11g with Oracle Developer Tools for Visual Studio
  • 32-bit Oracle 12c Managed Data Access Client
Check for BIDS & SQL Server Data Tools

Verifying that BIDS or SQL Server Data Tools is Installed

Complete the following steps to see if BIDS is installed:

  1. Open Start  > All Programs > Microsoft SQL Server 2005, 2008, 2012, or 2014. You should be able to see Business Intelligence Development Studio or SQL Server Data Tools if it's installed.

Task Factory install SQL Server Business intelligence Development Studio

Task Factory install SQL Server Data Tools

Verifying that the SSIS Components are Installed

Complete the following steps to see if SSIS components are installed:

  1. Open BIDS or SQL Server Data Tools.
    Task Factory Open BIDS or SQL Server Data Tools
  2. Once open, select File > New > Project.
    Task Factory select File > New > Project
  3. In the New Project dialog box, select Business Intelligence Projects on the left hand side. If you see Integration Services Project on the right hand side, then the SSIS components are installed.
    Task Factory select Integration Services Project