Who Uses This Software?

Astera Software offers data integration the energy, financial, manufacturing, education, insurance, government, healthcare,media and telecommunications and retail industries.


Average Ratings

24 Reviews
  • 4 / 5
    Overall
  • 4.5 / 5
    Ease of Use
  • 5 / 5
    Customer Service

Product Details

  • Free Trial
  • Deployment
    Installed - Windows
  • Training
    Documentation
    Webinars
    Live Online
    In Person
  • Support
    Online
    Business Hours

Vendor Details

  • Astera
  • www.astera.com
  • Founded 1990
  • United States

About This Software

Centerprise Data Integrator provides a powerful, scalable, high-performance, and affordable integration platform designed for ease of use by your business information experts, yet robust enough to overcome even the biggest and most complex data integration challenges.


Centerprise Data Integrator Features

  • Dashboard
  • ETL - Extract / Transfer / Load
  • Metadata Management
  • Multiple Data Sources
  • Web Services

Centerprise Data Integrator Reviews

Centerprise Data Integrator makes moving and manipulating data fast and easy, new look is slick!

Jul 19, 2017
4/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: Not
Likely
Extremely
Likely

Pros: I like how easily I can create workflows to stage, move, manipulate data to specifications on the destination table. This process improves our new client integration process dramatically. The ability to save workflows and contain them in projects allows us to reuse them saving priceless time.

Cons: New look is good, but the pins on each box it is hard to tell which item they align with. Also, sometimes when changing source files like a csv or excel to a different file Centerprise will freeze and crash. Lastly, previewing large amounts of data make take a long time.

Overall: Reusability is a huge feature savings us priceless time bringing in new client data into our software package. We also use Centerprise for quick data imports from client requests.

Centerprise has been a great asset for any data solution we need

May 23, 2017
4/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: Not
Likely
Extremely
Likely

Pros: Centerprise Data Integrator from Astera has provided us with a universal toolkit for dealing with any of our data. We are a large Federally Qualified Health Center, servicing over 70,000 patients a year. We've recently started to launch a data warehouse and an analytics platform. Centerprise Data Integrator has been crucial to the success of these projects by providing us with a simple toolset to create complex ETL's.

We've also recently used this to take data generated from Citrix SecureForms and integrate it into our Electronic Health Record system. These efforts dramatically reduce printing, scanning, and shredding costs as we develop forms that can be filled out by a patient electronically on a tablet device. Centerprise Data Integrator is a tool that we know we can use in almost any project that requires the movement, cleansing, or translation of data.

Cons: We had some issues with getting the software to run on our Citrix desktop initially. We weren't quite able to have it up in time for our training classes, but support and our trainer worked with us to get these issues resolved. They made sure to provide us with the support we needed as we embarked on our first major projects with the product.

Overall: The product allowed us to have a low barrier of entry to create ETL packages for our data warehouse and analytics platform. It also opens up integration between our already-owned assets. We can create high quality data integration without needing to have staff highly trained in SQL and SSIS. This has enabled multiple teams and users in our agency to be able to create solutions that would've taken us months to create before.

Centerprise data integrator

Apr 17, 2017
5/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
Likelihood to Recommend: Not
Likely
Extremely
Likely

Pros: Creating dataflows gives my team the ability to reuse what I have built for future integrations and build on them for better usability.

Cons: Slight learning curve to the software. Not a lot of tutorials available for many cases of data transformations.

Overall: we use Centerprise for new client data integrations to move old client data from their previous software to ours. So far it has been easy and everything we build is reusable.

Vendor Response

by Astera on April 17, 2017

Hi Kyle! Thanks for the great review. We're currently expanding our documentation and would love it if you could send us your feedback on which transformations you would like to see covered most.

Great features for the money!

Apr 17, 2017
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money

Comments: I was very impressed at the east at which I've been able to connect Salesforce to our Data Warehouse along with multiple other database sources!

Centerprise

Apr 13, 2017
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: Not
Likely
Extremely
Likely

Pros: Easy to use, Easy to learn. Most new employees can pick it up really quickly.

Cons: With large dataset it can take hours to process a workflow. It isn't easy to quickly add a row index without doing multiple steps.

Overall: Centerprise definitely makes new client integrations easy. With the ability to create workflows my team and I can bring in new clients quickly and efficiently. Centerprise takes all the hard work of writing SQL and puts it into an easy to use gui interface. Only thing I wish was easier was to have the ability to add a computed column for row number with out having to do it in multiple steps or within a sql statement.

Recommendations to other buyers: No, love the product.

Simple manipulations/migrations are fine, but maybe not for complex transformations

Mar 12, 2015
2/5
Overall
4 / 5
Ease of Use
5 / 5
Customer Support

Comments: Pro: is the ability to quickly, and with little technical knowledge, start an interface in/out of any system. I can't stress enough that it is easy to setup, use, and create as many integration tasks as you need. Customer Service is kind and helping if you have an issue. Please look through their videos if you can't seem to complete your task.

Con: Nothing too complicated please. A multiple step process in one work/data flow just can't be done. The amount of tiny pieces I need to create to acheive a more complex task is infuriating. It's almost exponential the amount of objects/workflows/dataflows needed for each workflow step that can't be cached into memory. And as for debugging, if you are doing massive bulk movements there's no way to preview your data before hand unless you know exactly which row it will be in in the `preview data` view. There is no filtering or sorting on the sample data.

Vendor Response

by Astera on March 12, 2015

Thank you for sharing your thoughts in this review. We take these reviews very seriously and we're sorry that you are experiencing frustration with Centerprise Data Integrator. Most of our customers are very happy with our software and we want you to be too. We will be in touch directly to see how we can help you resolve your problems.

Centerprise Surprise

Mar 12, 2015
4/5
Overall
5 / 5
Ease of Use
5 / 5
Customer Support

Comments: Centerprise was chosen for our DW project after researching several other tools in the ETL space. It is very flexible and easy to use, and allows for previewing of data within transforms, which is a useful feature. Reconfiguring dataflows and any complex logic contained within them is a snap. I have used SSIS for ETL work in the past and found it to be error-prone and a bit tempermental in its management of metadata, which tends to disappear with the slightest editing or adjustment causing much rework and frustration. Centerprise does not cause or suffer with such headaches. The various components of Centerprise have a clean, crisp interface that makes using them straightforward. The diffferent components have help videos and text available, but I wish there were more plentiful and robust examples that would show how to perform common ETL tasks in real world scenarios, such as loading dimension and fact tables from source data where many SCD Type 2 changes have taken place. On the whole Centerprise is an excellent product; I believe it will enable us to achieve our data warehousing goals quickly and efficiently.

Comprehensive and robust

Feb 27, 2015
4/5
Overall
4 / 5
Ease of Use
5 / 5
Customer Support

Comments: I've been using Centerprise for a few months and found it to be one of the most comprehensive and robust data integration tool in the market. It provides an endless number of great features to address any data transformation needs. It also provides a wide range of data connections for data source/target. During a demo we witnessed how data from a report can be manipulated and transformed to get it into a simple flat file. Ceterprise does take a lot of practice and time to learn, but once well acquainted with it, the work goes fast, smooth and more efficient. Data Integration with Salesforce are still a fuzzy area for me, but the little I used seemed okay. Customer support is great. Cases are usually review within a couple of hours of submitting a case online and resolved within that time or within the same day.

Gets the job done (mostly)

Feb 26, 2015
3/5
Overall
4 / 5
Ease of Use
4 / 5
Customer Support

Comments: Centerprise has its good parts and its bad parts. It handles basic, simple ETL quite well. The amount of features and abilities cover a wide range of tasks. Some of the features, however, are immature and feel like they were added before they were ready.

Customer service response time is very quick, and they are eager to solve issues as they arise.

The UI looks nice and it rather intuitive, though it also lacks polish. Many things don't work as one might expect - for instance; in some places one can use CTRL+ C to copy highlighted content, while in other places one must right click the content and select "copy" from the context menu - and still other places, one may highlight content, but not copy it at all. Scrolling, panning and re-draw also have room for improvement.

Overall, it does what we need it to do, even if we have to create some work-a-rounds for the few shortcomings.

Centerprise is easy to use

Feb 26, 2015
4/5
Overall
4 / 5
Ease of Use
4 / 5
Customer Support

Comments: Centerprise Data Integrator is easy to learn and easy to use. It allows me to move data from one database to another with the click of a button.

Great Concept, Easy to Use

Feb 25, 2015
5/5
Overall
5 / 5
Ease of Use
5 / 5
Customer Support

Comments: This is a great tool. The flexibility it offers is amazing, and the customer service whenever I've had an issue has been exemplary.

Vanderbilt

Feb 25, 2015
4/5
Overall
4 / 5
Ease of Use
4 / 5
Customer Support

Comments: Astera has met all our business needs.

Centerprise Data Integrator

Feb 25, 2015
5/5
Overall
5 / 5
Ease of Use
5 / 5
Customer Support

Comments: Speaking from a Procurement specialist standpoint, the process of purchasing and obtaining updates for such product has been nothing but positive.

Working with Munira Lalani on our account has been successful and very helpful.

A great ETL tool!

Feb 24, 2015
4/5
Overall
4 / 5
Ease of Use
4 / 5
Customer Support

Comments: It works great as a stand-alone desktop tool to quickly transform or check your data. There are occasions where there are steps that did not take place or only took place partially, ie. 23 records are loaded when there should be 40 records. Although it can easily be resolved by rerunning the Astera package, but one has to be extra careful of this.

Outstanding features and flexibility, QA is maturing

Feb 23, 2015
4/5
Overall
5 / 5
Ease of Use
4 / 5
Customer Support

Comments: The product is extremely flexible for many ETL situations. It is an easy product to learn and the user interface provides excellent visibility at all stages of the ETL. The Centerprise is still maturing since the quality assurance has at times been spotty, but Astera does provide immediate assistance / solution when an issue is discovered. Overall the product is an great value for the functionality, ease of use and customer support.

Centerprise Data Integrator - Surprisingly affordable compared to other ETL tools

Feb 22, 2015
5/5
Overall
5 / 5
Ease of Use
5 / 5
Customer Support

Comments: I was looking for a good ETL tool for my School District Project. Our budget was limited as I have taken up a project to build a EDW with a Shoe String Budget. So saving every penny is part of my project goals. At the same time, I want all the products to be salable, reliable and have high standards. I had the a list of criteria for the ETL product selection. Additional to the cost, I have looked at functionality, support and warranty, availability and adaptability. Centerprise Data Integrator was not in my original list as I was not heard this before. When I saw this name on my search, I did not had high hopes. But included in the mix of my tool comparison. We bought the product and we are very happy with it. I was surprised with its functionality. It is a very easy to use product and easy to learn. Further I am surprised with their product support. I am planning to use Centerprise Data Integrator for my future projects.

Robust Data Management/Transformation tool

Feb 20, 2015
5/5
Overall
4 / 5
Ease of Use
5 / 5
Customer Support

Comments: Centerprise makes data transformation easy with it's well equipped toolbox and easy customization.

Pros: Great out of the box functionality, ability to customize using self-coded libraries, multiple out of the box transformations provided.
Cons: We are on version 5 and it is somewhat intuitive, but requires some trial and error if you do not get the formal training; however, the customer technical and account support are both great and the online videos and documentation are extensive.

Centerprise Data Integrator 5.0

Feb 18, 2015
5/5
Overall
4 / 5
Ease of Use
5 / 5
Customer Support

Comments: This product was very useful for taking flat-file and convert into relational Oracle database tables. The batch processs was a great convenience.

Centerprise Data Integrator

Feb 18, 2015
4/5
Overall
4 / 5
Ease of Use
5 / 5
Customer Support

Comments: Centerprise has been the essential ETL tool for the past 5 years within our data mapping and conversion teams. It has allowed the MIS function to be centered back on the user in a controlled manner without a deep technical aptitude. The interfaces are easy to use and the product remains effective for our data needs with up to date features.

good

Feb 18, 2015
4/5
Overall

Comments: ease to use and learn

Novice User

Feb 18, 2015
4/5
Overall
4 / 5
Ease of Use
4 / 5
Customer Support

Comments: Within the first two weeks we were able to use centerprise in four different conversion processes and saved around 10 manhours. That means in 10 days we were able to perform 11 days worth of work.

Our biggest problem is that work gets in the way of us exploring even more ways of us benefiting from using Centerprise.

One area that is a con is the file definitions for Cobol structures that utilizes Trailing Separate Signs does not work via the Copybook. Customer service has confirmed this is a bug. The last reported was bug was corrected within two weeks of us reporting it.

Successful Data Syn

Feb 18, 2015
5/5
Overall
4 / 5
Ease of Use
5 / 5
Customer Support

Comments: Were were looking for a product to help us gather data from 50 entities on a variety of platforms, and to provide them with the tools necessary to send the data. Centerprise has enabled us to successfully synchronize the data on an automated scheduled basis. The beauty of Centerprise is its' flexibility in being able to standardized the data, and handle the entire process from collection, through cleaning and updating, to publishing.

Centerprise 6

Feb 18, 2015
4/5
Overall
4 / 5
Ease of Use
5 / 5
Customer Support

Comments: Centerprise Data Integrator is overall a very useful tool for data integration from legacy systems to the new.
Pros:
Lightweight
Easy to Use
Vast functionality to transform data
Logical work flows are re-usable and saves time
Flexible Expressions are very useful to logically transform data
Quick Support

Cons:
Some defects
Can't put notes in work-flow for instructions when someone else tries to use it

Great ETL tool, with excellent support

Feb 18, 2015
4/5
Overall
5 / 5
Ease of Use
5 / 5
Customer Support

Comments: We have been using Centerprise for 3 years now, and it is used throughout our integration department for daily and historical imports and exports.
Pros:
- extremely easy to use. We have handed off import mapping to non-technical people without issue
- thought out well. The product has a variety of useful and important features, and has bee able to handle most everything we have thrown at it.
- flexible and extensible. We have created our own C# functions which we have been able to integrate into the product. We are also using the API to programmatically start and monitor jobs.
- Great support. The team at Astera responds quickly to our questions and is prompt in addressing issues.

Cons:
- Some 'growing pains.' The product is young, and is sometimes releases have issues which means we must wait for a bug-fix release. this has been improving recently.
- some current issues with handling real-time API imports.

Other:
not an ESB solution (which is not a knock on the product, as it is not billed as one) Does a great job with batch processing. Was not designed or sold as a real-time data integration solution. So this isn't really a 'con' as long as you don't purchase it for that.

This has been a great product for simplifying the maze of thousands of different imports we must handle on a daily basis.