What users are saying about

SSIS

152 Ratings

Actian DataConnect

3 Ratings
Score 8.3 out of 101

SSIS

152 Ratings
Score 7.9 out of 101

Add comparison

Likelihood to Recommend

Actian DataConnect

The choice to use Actian DataConnect really comes down to pricing and the type of integration project you are performing, specifically with the requirements, whether you want the integration to be on-premise or in the cloud, can you install agents on your servers etc. For integration tools it runs head to head with its competitors.
David Byrd profile photo

SSIS

Well suited:
  1. Full refresh loading files (Excel and Flat File) into SQL Server.
  2. Integrating .Net (VB/C#) scripting
Less suited:
  1. Incremental loading
  2. OLAP database loading
Not suited:
  1. Streaming, real-time/near real-time loading
  2. Big data loading
David Milillo profile photo

Feature Rating Comparison

Data Source Connection

Actian DataConnect
9.5
SSIS
8.1
Connect to traditional data sources
Actian DataConnect
10.0
SSIS
9.1
Connecto to Big Data and NoSQL
Actian DataConnect
9.0
SSIS
7.1

Data Transformations

Actian DataConnect
10.0
SSIS
8.7
Simple transformations
Actian DataConnect
10.0
SSIS
9.3
Complex transformations
Actian DataConnect
10.0
SSIS
8.0

Data Modeling

Actian DataConnect
10.0
SSIS
7.5
Data model creation
Actian DataConnect
10.0
SSIS
7.1
Metadata management
Actian DataConnect
10.0
SSIS
6.6
Business rules and workflow
Actian DataConnect
10.0
SSIS
8.6
Collaboration
Actian DataConnect
10.0
SSIS
6.9
Testing and debugging
Actian DataConnect
10.0
SSIS
8.2

Data Governance

Actian DataConnect
9.5
SSIS
7.7
Integration with data quality tools
Actian DataConnect
9.0
SSIS
7.7
Integration with MDM tools
Actian DataConnect
10.0
SSIS
7.7

Pros

  • The large connector base for DataConnect is outstanding. However even when they do not have a custom connector, they have a web services Invoker which allows you to connect to any web services.
  • The underlying scripting language is Visual Basic-ish. Very easy to start.
  • The product has been around a long time, through multiple company acquistions, and still is a competitive player via pricing.
  • Support team is awesome.
  • Large user community.
David Byrd profile photo
  • SSIS Integrates very well with other Microsoft products including Excel and Access. Other ETL tools may have a difficult time integrating with Access, so we have observed SSIS to be superior in this regard.
  • SSIS has the capacity to do a fast bulk load (BCP) with transformations, within the bulk load itself. This feature is not available when utilizing the BCP utility outside of SSIS or from other ETL tools. To be clear, the transformation is occurring within the BCP component itself. Other ETL tools will have to utilize a non-BCP load (slower) or do the ETL after the load. This is a great feature I have not seen replicated in other tools.
  • SSIS integrates seamlessly with SQL Server RDBMS, including SQL Jobs and Stored Procedures.
  • SSIS has nice support, tools, and wizards for fixed length file processing.
Eugene LaRoche profile photo

Cons

  • Integration Manager needs better scheduling improvements. Like dependencies, and not running a process again if the prior run is still running.
  • New connector development does not seem a priority.
David Byrd profile photo
  • SSIS IDE (SQL BIDS) is lacking, particularly when compared to Visual Studio for .NET development. It was carried over (at least in look and feel) from the legacy DTS tool. It could use a complete redesign from scratch. Considering how superior the VS .NET IDE is, the inferior SSIS BIDS IDE is unacceptable.
  • SSIS is very Microsoft centric. This is a strength when dealing with pure MS technologies, but becomes a weakness when dealing with disparate, distributed systems, including cloud computing. Other ETL tools for example easily integrate with everything from AWS to Google Drive to Sales Force.
  • SSIS deployment model is clunky and non-intuitive.
Eugene LaRoche profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
SSIS6.0
Based on 2 answers
A bit outdated compared to competitors, esp in the open source community
No photo available

Usability

No score
No answers yet
No answers on this topic
SSIS8.0
Based on 2 answers
Easy to use, however there are functionality limits
No photo available

Support

No score
No answers yet
No answers on this topic
SSIS9.0
Based on 3 answers
They are generally responsive and knowledgeable too
No photo available

Implementation

No score
No answers yet
No answers on this topic
SSIS10.0
Based on 1 answer
The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools
Luca Campanelli profile photo

Alternatives Considered

As I stated earlier, DataConnect makes a head-to-head run against the others. It has advantages and disadvantages compared to the competitors. The choice really comes down to pricing and specific requirement needs for the project you are planning. Questions such as On-premise or Cloud, Security, and Specific Connectors available will drive your decision.
David Byrd profile photo
Pancratius Mukeh profile photo

Return on Investment

  • Our customer likes the consistent reliable integrations we have built so we [got] a definite return on investment.
  • Problems are fairly easy to handle and rework.
David Byrd profile photo
  • Automation leading to cost savings due to less headcount
  • Eliminate redundancy
  • Better customer service
Pancratius Mukeh profile photo

Pricing Details

Actian DataConnect

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

SSIS

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details