Astera Data Pipeline Builder (Centerprise) vs. Hevo Data

Astera Centerprise is specific to EDI files. From what I've seen it can be used on EDI files across multiple industries. We use it specifically for healthcare EDI files. We do not create any files using this software because we do not have that need at CCHP, but I know the software could be used for that. CCHP uses the software to correct EDI errors and to import EDI data to our SQL data warehouse. EDI files have a layered structure so they need to be broken down in order to be loaded into the data warehouse. Without this tool we would not be able to import the files. Also, with the layered structure, fields, segments, dependencies and hierarchy, making changes manually is both risky and time consuming. Centerprise reduces the amount of time used to correct files and removes the possibility of creating other errors.

Hevo Data is professionally sound in data management and credible analytical processes, where there is proper sourcing and data connectivity, from the different sources. Further, Hevo Data brings huge transformation and analytical approaches, which increases the viability of every operation in the company, and results are credibly issued. The integration that Hevo Data provides is comprehensively sound, and it gives quality coordination.

Incentivized

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

• 5 Minute Sync with Salesforce
• Transformations
• Auto Schema Mapping
• Push to Salesforce

Incentivized

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

• If we are getting data from other sheets then sheet which is connected to Hevo Data doesn't updates in real-time.
• Hevo Data change time in it's workbench on its own. For e.g. If our database timestamp is in UTC format then Hevo Data will automatically change the time to IST but if I run the same code outside the Hevo Data workbench then time is still in UTC. This creates lots of confusion while working on Hevo Data.

Incentivized

We've been using Astera Centerprise application for the last 6 years and we've already added EDI connect to it. Both applications are working really well for our enterprise needs so far with no issues, so we'll continue renewing the licenses.

It's very intuitive and visually descriptive. The interface is standard windows drag and drop although cut and paste are not universally available depending upon what function you're trying to do. You see the ETL and what it's doing. You can inspect the data elements the transformations and perform data previews incrementally along the data flow. You actually SEE what the results are and you can make adjustments without black box testing

In most cases Astera is stable. However, our client experiences the error from time to time. Mostly they are related to cdc file and ServerAdminConfig.xml file.

Incentivized

I think the performance for Astera is great when compare with other similar software.

Incentivized

Support is great! No matter if you need technical assistance or you have general questions about the tool - the support is very responsive and provides solutions quickly. They are available via various channels, which makes it very convenient to get in touch with them (Support portal, direct email contact, LinkedIn).

Incentivized

Astera support provided us implementation/installation tutorial and we were able to perform all the activities. Also one of the support was there to shadow us to make sure the process was smooth with no issues

We looked at continuing to use SSIS as an alternative. Although we own SSIS as part of our SQL licensing, we found that it takes a much higher skill level to create solutions. It also does not have the ability to parse unstructured data the way that Centerprise Data Integrator can. We also looked at Datawatch Monarch as a possibility but found it over-all to be cost-prohibitive. We also looked at a cheaper alternative called SimX but did not have a strong confidence in the product as we evaluated it. We landed on Centerprise Data Integrator as it met all of our business requirements and we know we could leverage it for many uses across our enterprise.

1. Cost efficient 2. Creation of automated pipeline 3. Can load data from multiple data sources 4. Updates data in near real-time - We were able to get near real time insights from the data model which we have created in hevo 5. It has good integration with different BI tools

Incentivized

I think Astera can do multiple things. However, we are not sure what it can do. We only know the basic features. If they can give us some kind of training, then we maybe able to benefit for it. We are planning to use their Azure connection in the future. If they can provide the training for it, it will be wonderful.

Incentivized

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

• Increased Time
• Decreased Failures
• Increased User Happiness

Incentivized