TrustRadius
Centerprise Data Integrator is an integration platform that includes tools for data integration, data transformation, data quality, and data profiling.https://dudodiprj2sv7.cloudfront.net/product-logos/o3/ca/HQSRO95Q7O1Q.pngAstera SoftwareGreat data tool!2018-05-24T21:38:15.856ZCenterprise is an integration tool we use for data manipulation and transfer. The tool makes it easy to transform database data from one endpoint and deliver it to another. This is an excellent tool that makes things like writing hard long SQL scripts into just a click and drag press the go button and done process. Centerprise saves us a huge amount of time when integrating legacy databases data into our application.,Slick drag and drop UI is easy to learn and get started with
Customer service is friendly and responsed quickly
Large array of built in functions makes data manipulation easy,Sometimes when previewing the data output or even running complex dataflows it can take a long time.
Occasionally crashes after long use
Could use some more functions like row number,10,Dramatically reduced new client integration processes
New employees who are not good with SQL can use this tool
Streamline tasks data importsVerified UserCenterprise Data Integrator is an excellent toolset for multiple uses in a healthcare agency2017-05-23T18:59:23.881ZWe are a large federally qualified health center that serves approximately 70,000 patients per year. Recently we began implementing a data warehouse and analytics platform, and have started a project to integrate our electronic health record system into other systems. Centerprise Data Integrator has become an essential toolkit for us in translating and moving our data. We use this as our main ETL tool to load our data warehouse from a variety of sources. We also use the product to transfer semi-structure data from Citrix SecureForms into our electronic health record system. We are able to develop tablet-based electronic forms that a patient can fill out, and then use Centerprise Data Integrator to validate the data and load it directly into the patient's chart. This saves on the overhead involved in paper processes. Since the tool is so user-friendly, we have multiple teams and users that do not have a extensive SQL or SSIS training creating high quality solutions.,The user friendly interface to develop integration packages means that you don't need to be highly trained in SQL code.
There is a huge variety of out-of-box functions, translations, and connectors. This means you can get up and running with using these different components right away.
Centerprise Data Integrator can mine data from unstructured and semi-structured data sources like pdf files and csv's. It means that virtually anything you have can be moved into a SQL database or fed into other systems.
Centerprise Support has been excellent and responsive to our needs.,We had some issues in getting the software running with their licensing model on our Citrix Desktop. They were very helpful in working with us on this issue.
With any product that creates SQL code in the background, I am skeptical of how optimized that will be for our specific environment. We have not yet had problems related to this, but customers may want to monitor closely.
They do not yet seem to have a large customer base and robust user community.,9,By enabling the integration between electronic forms and our electronic health record system, we've been able to reduce overhead related with printing, scanning, shredding of paper documents.
The low barrier of expertise needed to create data integration packages has saved significantly on labor and training in these practices.
The ease of use has enabled us to move data integration projects forward quickly and produce results in a short period of time. The features that allow users to preview the data allow us to be more agile with the solution and get feedback right away.,Datawatch Monarch,MicroStrategy Analytics, NextGen Healthcare Practice Management, Microsoft SQL Server,3Andre BeaumontFast and Simple. All-in-one package2015-08-17T14:27:15.855ZWe purchased Centerprise to be our ETL tool for our new "CloudNet" Crop Insurance Policy system. It was our tool to do our nightly loads to our Data Warehouse for all of our reporting needs. It was also our tool for sending and receiving all our daily RMA files to the government.,Once you get the feel around the interface, Centerprise is a real easy and fast tool to get up and running. You can have a Dataflow up and running in mere minutes compared to some other tools on the market. The interface is simple and pretty much everything is all in once place and easy to understand.
The Preview data on each object is a lifesaver. To be able to set up a Dataflow and preview it's data immediately without having to run or set up a workflow is a very time-saving benefit.
You can run Dataflows. They do not need to be incorporated into a Workflow in order to run.
You have the ability to pass in and out parameters to Dataflows. Very handy if you need specific information about a Dataflow (or data in that flow) in order to continue on processing the next step.
The scheduler is extremely nice and easy.
Centerprise is an all in one package. Everything is together. You do not need a separate scheduler or bits and pieces of other products in order to get full use of Centerprise. You can Read, write and parse files. You can send emails and/or FTP to government (any) sites. You can schedule your jobs or have your System (we had .NET) call and trigger a job for you.,Our main concern is backward compatibility with QA testing. We had a few releases of new code, changes or fixed that broke existing code which took us over 90 hours to run thru and refresh all our flows. We like the enhancements, but we don't have time to back thru everything, everytime there is a release to retest and refresh all the Flows. It's not feasible for us.
Help documentation. There needs to be a lot more with a lot of examples (so we aren't calling and bugging support all the time). Although, they were extremely helpful, but I'm sure they have other things to do than teach us how to use the product.
Pretty much any enhancement we needed at the time (or asked for) was given to us in a pretty timely manner. The Cobol objects were fixed/enhanced. The out variables were added. The only thing we didn't get to use that we asked for was the REST service calls. We had a lot more we wanted to do with the product.,10,It is tough to say on how Centerprise would have helped us with ROI. Unfortunately our project (after 3 years) was scrapped (put on hold) due to the impromptu purchase of another Crop Insurance company. But with that, Centerprise was huge in getting our warehouse loaded for our BI Team to make important decisions about our policies.,Informatica Enterprise Data Integration,2,2,No,Price
Product Features,After working with another product after Centerprise, I wouldn't change anything. Centerprise is the way to go.,Yes,8,Yes,Mike always gave us great support (even when I was impatient and pushy). They also went out of their way to give us exactly what we needed (enhancements),Setting up the basic Source to Target mappings/Flows are easy.
Scheduler is very nice and easy.,Help documentation. The help available is not that great. So, getting up-to-speed there was a lot of questions, but after that, things are easy.,9Dawn BauerWOW Why did we wait soooo long?2015-08-07T15:39:02.159ZWe mainly use Centerprise for two areas. Our team takes other systems' data and transforms that into our format for our developed software. We use Centerprise to pull the necessary information out of the other systems' reports to validate the completion of a conversion. We also use it to extract data from the other systems' reports to do the actual data transformation into our format when the other system's provider will not supply data for the conversion.,Because the standard reports from one system to another are not always compatible - Centerprise allows us to create a reusable template to standardize the information that we use to validate conversions. Standardizing the reporting data from two systems is an awesome strength that can be developed out of Centerprise.
We have had several instances that the supplier of software to a customer will not provide data out of their system for conversion. Sometimes it is a timing issue (you will need to wait 6 months for this) and other times it is a cost issue. We have been able to convert accounting and payroll information into our system just based on reports out of the legacy system. Because we can save the template we can now convert anyone on that legacy system without the involvement of the legacy system's software provider.,We have several support calls that have been labeled as to be done in the future. One is the reading of the File Definition in AcuCobol with the sign trailing in a numeric field. The handling of this would help us in several areas but we have been able to develop a work around at this point.
Some of the child/overlap configuration for the "RMD" seems awkward.,8,We have seen that the use of this package saved us 2 hours per conversion but now since the templates are already developed it is saving us more. This reduces our lead time for conversions, and increases our efficiencies as a conversion team.
We have four licenses and in one conversion this year it allowed us to do a conversion that would not have been done. This conversion generated more than enough money to cover the cost of these four licenses for the entire year. The customer is ecstatic about the information that we were able to pull out of their reports and most of all the upper management of our company had their socks shocked off of them. Since the supplier of the software for this customer would not provide data to us for a conversion our upper management was going to cancel the sale to this customer, unless the customer was going to build our system from scratch. We were able to provide nearly a complete accounting and payroll conversion to this customer all from the data on their reports thanks to centerprise.,Don SmithAstera Centerprise rules!2015-08-04T14:15:39.074ZCenterprise is primarily used to move data from our operational database into our newly created data warehouse. We also intend to use it to exchange data files between different applications. We are still in development, but we pull data from sources that span our whole organization into an enterprise data warehouse that will be accessed by our internal and external users through MicroStrategy, our reporting tool.,It's incredibly easy to use. The YouTube videos Astera provides are enough to get you started. People with no previous ETL experience can start building simple mappings very quickly.
It's incredibly easy to install and maintain. After I first installed Centerprise, I was able to start working in just a few minutes, and the maintenance releases are pretty straightforward.
I am particularly impressed with how much Centerprise simplifies transformations that require more work in other ETL tools. The perfect example is the SCD transformation, which handles all the logic in an Slowly Changing Dimension. Even with a market leader like Informatica, the SCD logic has to be manually built. With Centerprise this can be built in just a few minutes, and it impacts every mapping.,Performance is definitely an area to work on. My own benchmarking shows a notable difference when introducing simple transformations into a jobflow.
The tool lacks debugging capabilities
I would like to see more jobflow stats than the ones provided
It is Windows-based. Many companies (including ours) are UNIX shops, and try to avoid Windows servers as much as possible, so it would be nice to have a non-Windows version.,9,It's still too early to tell for us because this is a new data warehouse and reporting system, but I expect the difference will be like night and day.
Today we face long waits and timeouts just to get some simple data out of our database. Centerprise will make those a thing of the past.,Mario Ferrer
Windows
Centerprise Data Integrator
18 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
