Centerprise Data Integrator - XML the easy way
Updated August 10, 2015
Centerprise Data Integrator - XML the easy way
Score 10 out of 10
Vetted Review
Verified User
Software Version
6.3
Overall Satisfaction with Astera Centerprise
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.
Using Astera Centerprise
1 - IT
1 - knowledge of etl
- XML mapping
- 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
Evaluating Astera Centerprise and Competitors
- Product Features
- Product Usability
- Third-party Reviews
Ease of use.
I would not change anything
Astera Centerprise Implementation
- Implemented in-house
Yes - 1st phase - manual processing of files
2nd phase - optimization of integrator data/sub flows
3rd phase - automation, which probably requires upgrade
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
Astera Centerprise Support
| Pros | Cons |
|---|---|
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 Astera Centerprise
| Pros | Cons |
|---|---|
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.