What users are saying about
3 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.2 out of 101
22 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.5 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

PowerCenter

PowerCenter is well equipped to handle large amounts of data movement in an organization with many disparate sources and a structured development team. It excels in enforcing enterprise development standards through things like metadata manager and the monitoring capabilities (as well as being able to design monitoring rules for everything from naming standards to design practices). It is especially well suited at handling flat-file data in addition to its many connectors and native support for just about any ANSI standard database. For large development teams or the desire to remain flexible at an enterprise scale, Powercenter is a top-tier solution.For small projects or even smaller development teams with mostly a single data source, expect frustration with being able to quickly test a solution as the design flow is very structured. It is also designed in a way that segregation of duties at a very high level can also cause small development teams to be counter-productive. Each step in the design process is a separate application, and although stitched together, is not without its problems. In order to design a simple mapping for example, you would first need a connection established to the source (example, ODBC) and keep in mind that it will automatically name the container according to how you named your connection. You would then open the designer tool, import a connection as a source, optionally check it in, create a target, optionally check it in as well, and design a transformation mapping. In order to test or run it, you will need to open a separate application (Workflow Manager) and create a workflow from your mapping, then create a session for that workflow and a workflow for those one or more sessions at which point you can test it. After running it, in order to observe, you then need to open a separate application (Monitor) to see what it is doing and how well. For a developer coming from something like SSIS, this can be daunting and cumbersome for building a simple POC and trying to test it (although from the inverse, building an enterprise scalable ETL solution from SSIS is its own challenge).
Jody Gitchel profile photo

Feature Rating Comparison

Data Source Connection

Actian DataConnect
9.5
PowerCenter
8.2
Connect to traditional data sources
Actian DataConnect
10.0
PowerCenter
8.9
Connecto to Big Data and NoSQL
Actian DataConnect
9.0
PowerCenter
7.5

Data Transformations

Actian DataConnect
10.0
PowerCenter
8.7
Simple transformations
Actian DataConnect
10.0
PowerCenter
8.6
Complex transformations
Actian DataConnect
10.0
PowerCenter
8.8

Data Modeling

Actian DataConnect
10.0
PowerCenter
7.0
Data model creation
Actian DataConnect
10.0
PowerCenter
5.9
Metadata management
Actian DataConnect
10.0
PowerCenter
7.3
Business rules and workflow
Actian DataConnect
10.0
PowerCenter
6.8
Collaboration
Actian DataConnect
10.0
PowerCenter
8.1
Testing and debugging
Actian DataConnect
10.0
PowerCenter
6.9

Data Governance

Actian DataConnect
9.5
PowerCenter
6.6
Integration with data quality tools
Actian DataConnect
9.0
PowerCenter
6.7
Integration with MDM tools
Actian DataConnect
10.0
PowerCenter
6.5

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
  • Informatica is a proven enterprise ETL tool that scales and provides a graphical interface to code your data mappings.
  • Reading, Transforming and Loading Data to and from databases.
  • Process incoming data such as messages in real-time.
No photo available

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
  • Data Cleansing.
  • Web Services / Services.
  • Modeling your data models.
No photo available

Likelihood to Renew

No score
No answers yet
No answers on this topic
PowerCenter10.0
Based on 1 answer
It is a good, efficient product. Lots of developers are easily available in the market to perform the work.
Sadu Kurahatti 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
Alternatives:
  • Talend (open source, cheaper, longer development time, not intuitive UI, harder to troubleshoot, etc)
  • Pentaho (cheaper, better talend)
  • Oracle Integrator (similar as capabilities Informatica PowerCenter, but not as mature, similar cost)
No photo available

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
  • The data pipeline automation capability of Informatica means that few resources are needed to pre-process the data that ultimately resides in a Data Warehouse. Once a workflow is implemented, manual intervention is not needed.
  • PowerCenter did require more resources and time for installation and configuration than was expected/planned for.
  • The lack of or minimal support of unstructured data means that newer sources of dynamic/changing data cannot be easily processed/transformed through PowerCenter workflows.
No photo available

Pricing Details

Actian DataConnect

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

PowerCenter

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