Centerprise Data Integrator Reviews

18 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.7 out of 100

Do you work for this company? Manage this listing

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-15 of 15)

Anonymous | TrustRadius Reviewer
May 24, 2018

Great data tool!

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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
Read this authenticated review
Andre Beaumont | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read Andre Beaumont's full review
Dawn Bauer | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read Dawn Bauer's full review
Don Smith | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read Don Smith's full review
Mario Ferrer | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read Mario Ferrer's full review
Phil Nacamuli | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Reseller
Review Source

Pros and Cons

  • The links to many different data sources made it real easy to gain access to the key data elements and integrate the data across many different systems.
  • The graphical approach is self documenting and permits the rapid assimilation of existing work by new team members.
  • It makes it VERY easy to build source/destination data reconciliations.
  • The ability to incrementally see the data transformation results at any point in a data flow is invaluable.
  • The XML processors make it real easy to process and integrate XML data. We've even used Centerprise on its own data logs to pull out and report on the XML job log data for custom reporting.
  • Centerprise is an invaluable tool for addressing data integration particularly dealing with 'Shadow IT' Excel spreadsheets.
  • The dataflow architecture will take some getting used to as you have to understand the various data flow objects and THINK about how a data flow will work to accomplish what you want.
  • The scheduler and job monitor are areas where the product can be improved. We would like to see an independent job monitor as a separate read only component so that a client use license is not not needed to see the working jobs.
  • The job scheduler interface is not that intuitive and adding jobs, particularly in 100's, is VERY time consuming using the interface.
  • The mapping between UTC and local times need work and the scheduler needs to handle switching back and forth between day light savings.
Read Phil Nacamuli's full review
David Farler | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Parses fields from reports. Vertical reports can be transformed into one single row in Excel.
  • Process PDF reports. Very helpful. So far, the best tool for this task that I have used.
  • Easy to use. No need have a strong developer background to use.
  • PDF reports are tricky at times. The columns line up when printed on paper. But Centerprise does not always see the columns this way.
Read David Farler's full review
Dave Worthington | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • We often receive PDF-based reports from a competitor's financial and payroll management system. A normal cut and paste operation makes a mess of the data, whereas the Centerprise Data Integrator parses and aggregates the data.
  • In some cases, we have to generate a value for a proprietary field in our database based on multiple fields of competitive data. Rather than support multiple versions of our own data importer, we can build the value on the fly, saving time and effort.
  • The Data Integrator is intelligent in its ability to parse reports, map and modify fields, and export data. We are just now going into more depth from starting at the tip of the Centerprise iceberg. The more we see, the more impressed we are.
  • I haven't seen any areas for improvement, but as I become more proficient with its usage, there's an outside chance I could provide suggestions.
Read Dave Worthington's full review
Carlos Manzanares | TrustRadius Reviewer
Score 3 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Centerprise Data Integrator makes it very easy for non-technical people to create and maintain data mappings from one data source type to another. This is beneficial to allow developers and engineers to focus on other parts of the business needs and not be bogged down with constant work flow changes desired by the customers.
  • Centerprise Data Integrator is very good at moving and translating large blocks of data efficiently.
  • Our biggest problem is with updates. We feel we have to thoroughly test each and every update with complete regression testing before we can apply that update to our production environment. This is due to previous updates often containing bugs or changing existing functionality.
  • Centerprise Data Integrator could do a much better job at moving a lot of small sets of data instead of a few large sets.
  • Web services connection could be much better. It is difficult to get some web services to work properly.
  • Could really benefit from allowing 32-bit integers instead of only 64-bit integers.
Read Carlos Manzanares's full review
Venkat Prasad Sunkara M.S, PMP, CBIP, ITIL | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Easy to learn. We were able to train new employees and get them to speed within a week.
  • Easy for business users.
  • Would like to see template based development. For example I should be able to select a new TARGET table to be a TYPEII table, the tool should have a wizard to create the right map.
Read Venkat Prasad Sunkara M.S, PMP, CBIP, ITIL's full review
Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Allows for integration of custom functions.
  • Allows us to easily migrate data to and from any data source. Our department has become the go-to for automated data extracts.
  • We use emails from jobs we run in Centerprise to ensure all jobs run successfully.
  • I have not upgraded to the latest version, but in the last version, could use better descriptions in error messages.
  • I have not upgraded to the latest version, but in the last version, it would be nice to have reports we could run or have emailed daily/weekly with success/failure of all jobs scheduled.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 5 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • The mapping interface is easy to use.
  • It works well with our code repository.
  • It does not work well in an environment where you run a lot of small jobs. The queue processor leaves much to be desired.
  • Jobs fail for no apparent reason and do not automatically restart. We have to come in every morning and manually restart jobs that have failed overnight.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Easy to learn
  • I liked it because I was converting older historical files with packed fields (COBOL) and it did a good job of converting without a lot of effort.
  • You could reuse structures you build instead of having to redo it.
  • I think in the beginning there were some issues with more complex data flows but they usually fixed them. I think they have made a lot of improvements since we first started using the software.
Read this authenticated review

Feature Scorecard Summary

Connect to traditional data sources (2)
8.2
Connecto to Big Data and NoSQL (1)
7.3
Simple transformations (2)
9.1
Complex transformations (2)
8.2
Business rules and workflow (2)
8.1
Collaboration (1)
6.4
Testing and debugging (1)
7.3
Integration with data quality tools (1)
8.2
Integration with MDM tools (1)
8.2

About Centerprise Data Integrator

Centerprise Data Integrator is a complete data integration solution that includes data integration, data transformation, data quality, and data profiling capabilities in a user-friendly interface that promises to enable business users to handle data with minimal IT support. The vendor says Centerprise enables users to exchange data with virtually any application, database, and format.
Categories:  Data Integration

Centerprise Data Integrator Features

Has featureIntegrated development environment
Has featureData quality and profiling
Has featureJob flow, scheduling, and execution
Has featureExtensibility and openness
Has featurePerformance and scalability
Has featureEase of use for business users

Centerprise Data Integrator Screenshots

Centerprise Data Integrator Integrations

Microsoft SQL Server, SAP Adaptive Server Enterprise, SoapUI Pro, SAP CRM, Salesforce.com, MySQL, Microsoft Dynamics 365 (formerly Microsoft Dynamics CRM), Salesforce, Oracle, Netezza, Teradata, XML, Excel, X12, PRN, IBM DB2, REST, ODBC, Ole DB, Delimited, flat, fixed length files, COBOL, HIPAA, JSON

Centerprise Data Integrator Competitors

Informatica, Adeptia, Talend

Pricing

  • Has featureFree Trial Available?Yes
  • Does not have featureFree or Freemium Version Available?No
  • Has featurePremium Consulting/Integration Services Available?Yes
  • Entry-level set up fee?No
EditionPricing DetailsTerms
Centerprise EnterpriseContact repLifetime License per Seat

Discounts are provided for 10 pack, 20 pack, 50 pack, and enterprise wide Centerprise Professional licenses.

Centerprise Data Integrator Customer Size Distribution

Consumers
0%
Small Businesses (1-50 employees)
11%
Mid-Size Companies (51-500 employees)
47%
Enterprises (> 500 employees)
42%

Centerprise Data Integrator Support Options

 Free VersionPaid Version
Phone
Live Chat
Email
Forum/Community
FAQ/Knowledgebase

Centerprise Data Integrator Technical Details

Deployment Types:On-premise
Operating Systems: Windows
Mobile Application:No
Supported Countries:USA
Supported Languages: English