Astera Centerprise vs Matillion

• 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.

Read full review

• The workspace is drag and drop, which makes it intuitive and easy to use.
• Server creation and management is robust. We haven't had to worry too much about it once we got it created.
• The job scheduler is very simple and intuitive.
• Matillion allows you to run Python, which grants almost unlimited flexibility, even without using any other components.

Read full review

• 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 full review

• Limited selection of instance sizes - Larger organizations and groups my need to set up multilple instances depending on estimations on concurrent users.
• Lack of complete github, gitlab, or other source control integration - it has internal versioning but it is limited. Manual job exports currently don't lend well for useful DIFFs comparison when using those technologies.
• Needs more options for authentication and security - User creation is very manual and can be tedious and difficult to manage for larger installations.

Read full review

• 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.

Read full review

• I was able to build a complete commissions processing system for over 3500 employees using Matillion in just over a month. This included gathering data from 5 different sources, combining them together appropriately and building in the business rules. I was awarded one of the top awards our company gives for this project.
• Our big three Business Intelligence tools: Matillion, Redshift and DOMO allow us to give our employees the right data at the right time. Our productivity has increased as 75%+ of our employees look at their data every day they work.

Read full review