Astera Data Pipeline Builder (Centerprise)

It is used by the software development department. We are using this for the ETL process to move and transform the data from one data source to another based on the business rules. We also use this to read the data from the source, transform the data and then feed our application.

• The ability to exchange and valid the data between different data sources

• It is quickly adapted by many of my co-workers and easy to learn. That saved a lot of training time.
• As I am dealing with a big data set, it helps us to move and verify the data quickly.
• It took me some time to get used to the error message, as it is a bit too technical. This has also caused some issues as other users may need more support on it.
• The cdc file caused the issue a lot. We have to remove that from our design.
• Astera provides a fast response for support.

Informatica B2B Data Exchange

Microsoft SQL Server, Microsoft 365 Business Premium, Microsoft Visual Studio, Microsoft Visual Studio Code, Oracle SQL Developer, FME

Loading data from customers into setup/UAT environments for ERP deployments. We use Centerprise to bypass the need for full SQL access/scripting experience in order to load data in a more timely fashion. Mostly addresses issues with bottlenecks & availability of dedicated data developers.

• Faster turnarounds on pre-live data loads

Smartsheet, Aha! Roadmaps, DevOps board

Astera Centerprise is being used by the IT Application Department in Aspen Medical Products. It is being used to integrate the Magento eCommerce platform to host the company's website with ERP Application (IQMS). I've been using the Astera Centerprise for the last 5 years to create Integration Dataflows, Workflows, Scheduled jobs to integrate the Magento and IQMS APIs. These jobs run round the clock from 4 am till midnight 7 days a week to keep the data flowing between the applications. The data includes customers orders, customer's account setups, address information updates, Credit limit updates, Customer's product pricing updates, etc...

Adobe Commerce (Magento Commerce), Microsoft SQL Server, Microsoft Power BI, IFS Applications

• REST API client, Rest Connection to generate refresh API tokens
• EDI Connect features like EDI message parser, source, destination.
• Loop feature to loop the records in the workflows
• Sending Outbound EDi files like 940, 855, 856, 810 etc..

• Instead of using Mulesoft which was very costly tool, we chose Astera Centerprise which helped in saving thousands of dollars in licensing fees per year.
• Last year we were looking for EDI tools for our needs to consume EDI files like 850 and also generate the outbound EDI files like 810, 856 etc. but after comparing others in the market, Astera's EDI Connect was the best choice for us as it was much cheaper and Integrating with our existing Astera CDI tool was easier.

MuleSoft Anypoint Platform

We are using Astera Centerprise for automatically capturing data from PDF files and uploading to different databases. We are also using this for integration of different systems, data comparison, data validation, data extraction, and data transformation.

We initially purchased Astera Centerprise for us to automatically capture and load data from PDF documents to improve our data quality. With all the available functions in Centerprise, we expanded to different areas and continue to grow in terms of application. We also continue to work with Astera support group on possible improvements and functionalities.

• Data parsing
• System integration
• Data loading

• Productivity improvement
• Quality improvement
• Cost reduction as a result of improved productivity

Altair Monarch

Blue Prism Intelligent RPA, TIBCO Spotfire, Microsoft SQL Server

Our business intelligence group uses it to run our ETLs to pull data from over 10 source systems to our enterprise data warehouse. We also use it to generate data feeds to other systems from EDW.

• data connectors
• ease of use transformations

• Because of Astera we have been able to evolve and manage our EDW which has data from multiple sources today and is being used across our organization.

IBM Cognos Analytics with Watson, Microsoft BI (MSBI)