Centerprise Data Integrator - XML the easy way
Mark Rubin | TrustRadius Reviewer
Updated August 10, 2015

Centerprise Data Integrator - XML the easy way

Score 10 out of 10
Vetted Review
Verified User
Review Source

Software Version

6.3

Overall Satisfaction with Centerprise Data Integrator

Centerprise Data Integrator is used to process XML data. The software is currently used by myself only. Data Integrator replaced SSIS as our XML mapping tool. Due to a very aggressive implementation timeline, SSIS was not feasible. Data Integrator allowed me to map complex XML data very quickly and without much ramp-up time.
  • Maps XML data exceptionally well
  • Integrates flawlessly with SQL 2012
  • Extremely robust set of transformations and functions which allows a huge amount of flexibility with ETL
  • The help functionality. Needs better search and more examples.
  • Definitely increased our data processing efficiency
  • Allowed the company to penetrate a new health care maket space
  • data migrator,talend,pervasive,cloveretl,liquid data mapper
By magnitudes...the time to implement a map. I was up an running in under an hour. The interface is extremely well designed and simple to use. Logging is very robust. Transformations and functions are much easier to use than other vendors I have tried.
I am fairly new to Centerprise Data Integrator, but this software is perfect for those have ETL projects that require rapid concept to production solutions.

Using Centerprise Data Integrator

1 - knowledge of etl
  • have not had a chance to evaluate how this product will support other areas of our business yet.
  • converting some of our very old SSIS packages
Best product I have evaluated. No need to seek alternatives.

Evaluating Centerprise Data Integrator and Competitors

  • Product Features
  • Product Usability
  • Third-party Reviews
Ease of use.
I would not change anything

Centerprise Data Integrator Implementation

Extremely fast implementation. From install to completed data flows in under a day.
Yes - 1st phase - manual processing of files
2nd phase - optimization of integrator data/sub flows
3rd phase - automation, which probably requires upgrade
Change management was minimal
  • due to the ease of use, there were no significant issues encountered. I did identify a bug, which was confirmed by Centerprise, but it did not prevent me from loading data.
  • Due to the very large XML schemas the government utilizes for health care, some limitations of the GUI created some lag when developing maps. These GUI issues have been relayed to Centerprise

Centerprise Data Integrator Support

Couple lingering issues that they are looking into. Otherwise, support has been great.
ProsCons
Good followup
Knowledgeable team
Problems get solved
Kept well informed
No escalation required
Support understands my problem
Quick Initial Response
None
No - not required (at least....not yet).
Yes - it has not been resolved, but is currently being addressed.
1st time I utilized the product, I was attempting to move through the tool a 1GB file. I kept running out of memory. I was up against an extremely aggressive timeline, so I reached out to Astera for support and within a few hours, I had what I needed to continue.

Using Centerprise Data Integrator

With the few things I have found with the GUI, I give it a 9. Otherwise it would have been a 10.
ProsCons
Like to use
Relatively simple
Easy to use
Technical support not required
Well integrated
Consistent
Quick to learn
Convenient
Feel confident using
Familiar
None
  • built in functions provide a nearly limitless way of handling data
  • love the data preview feature. beneficial when mapping xml data
  • when dealing with large xml schemas and having to make a change (like converting an xml source to a transformation) you sometimes have to remap, which in my case, can be hundreds of data points
  • the GUI contains several areas there the display does not show the entire element/field name. The government schemas all contain field names that are very long. The GUI cuts off the ends of these field names, which makes it difficult to select the correct one.