What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
44 Ratings

Astera Centerprise

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
44 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.9 out of 100
122 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Feature Set Ratings

    Data Source Connection

    7.9

    Astera Centerprise

    79%

    Oracle Data Integrator

    Feature Set Not Supported
    N/A
    Astera Centerprise ranks higher in 2/2 features

    Connect to traditional data sources

    8.6
    86%
    25 Ratings
    N/A
    0 Ratings

    Connecto to Big Data and NoSQL

    7.3
    73%
    1 Rating
    N/A
    0 Ratings

    Data Transformations

    8.3

    Astera Centerprise

    83%

    Oracle Data Integrator

    Feature Set Not Supported
    N/A
    Astera Centerprise ranks higher in 2/2 features

    Simple transformations

    8.6
    86%
    25 Ratings
    N/A
    0 Ratings

    Complex transformations

    7.9
    79%
    23 Ratings
    N/A
    0 Ratings

    Data Modeling

    7.5

    Astera Centerprise

    75%

    Oracle Data Integrator

    Feature Set Not Supported
    N/A
    Astera Centerprise ranks higher in 4/4 features

    Data model creation

    8.6
    86%
    15 Ratings
    N/A
    0 Ratings

    Business rules and workflow

    8.4
    84%
    23 Ratings
    N/A
    0 Ratings

    Collaboration

    6.4
    64%
    1 Rating
    N/A
    0 Ratings

    Testing and debugging

    6.7
    67%
    21 Ratings
    N/A
    0 Ratings

    Data Governance

    8.2

    Astera Centerprise

    82%

    Oracle Data Integrator

    Feature Set Not Supported
    N/A
    Astera Centerprise ranks higher in 2/2 features

    Integration with data quality tools

    8.2
    82%
    1 Rating
    N/A
    0 Ratings

    Integration with MDM tools

    8.2
    82%
    1 Rating
    N/A
    0 Ratings

    Cloud Data Integration

    Astera Centerprise

    Feature Set Not Supported
    N/A
    7.8

    Oracle Data Integrator

    78%
    Oracle Data Integrator ranks higher in 6/6 features

    Pre-built connectors

    N/A
    0 Ratings
    7.7
    77%
    12 Ratings

    Connector modification

    N/A
    0 Ratings
    7.8
    78%
    12 Ratings

    Support for real-time and batch integration

    N/A
    0 Ratings
    7.3
    73%
    13 Ratings

    Data quality services

    N/A
    0 Ratings
    8.0
    80%
    12 Ratings

    Data security features

    N/A
    0 Ratings
    8.0
    80%
    12 Ratings

    Monitoring console

    N/A
    0 Ratings
    8.1
    81%
    13 Ratings

    Attribute Ratings

    • Astera Centerprise is rated higher in 2 areas: Likelihood to Recommend, Implementation Rating
    • Oracle Data Integrator is rated higher in 1 area: Likelihood to Renew

    Likelihood to Recommend

    8.1

    Astera Centerprise

    81%
    38 Ratings
    8.0

    Oracle Data Integrator

    80%
    29 Ratings

    Likelihood to Renew

    8.2

    Astera Centerprise

    82%
    3 Ratings
    10.0

    Oracle Data Integrator

    100%
    4 Ratings

    Usability

    8.0

    Astera Centerprise

    80%
    5 Ratings

    Oracle Data Integrator

    N/A
    0 Ratings

    Support Rating

    8.4

    Astera Centerprise

    84%
    21 Ratings

    Oracle Data Integrator

    N/A
    0 Ratings

    Implementation Rating

    9.1

    Astera Centerprise

    91%
    6 Ratings
    7.0

    Oracle Data Integrator

    70%
    2 Ratings

    Likelihood to Recommend

    Astera Centerprise

    Suited scenarios: 1) It is really good in integrating the REST APIs 2) Data preview feature is really good which helps in debugging of dataflow easier and faster. Per my knowledge, Astera Centerprise is not very well suited for very large data loads.
    RAHUL SINGHAL | TrustRadius Reviewer

    Oracle Data Integrator

    Oracle Data Integrator is well suited in all the situations where you need to integrate data from and to different systems/technologies/environments or to schedule some tasks. I've used it on Oracle Database (Data Warehouses or Data Marts), with great loading and transforming performances to accomplish any kind of relational task. This is true for all Oracle applications (like Hyperion Planning, Hyperion Essbase, Hyperion Financial Management, and so on).I've also used it to manage files on different operating systems, to execute procedures in various languages and to read and write data from and to non-Oracle technologies, and I can confirm that its performances have always been very good.It can become less appropriate depending on the expenses that can be afforded by the customer since its license costs are quite high.
    Paolo Borghi | TrustRadius Reviewer

    Pros

    Astera Centerprise

    • Astera's customer service and help team are quick to respond and have always found solutions to my questions or problems. They also follow up after completing a support request to make sure everything was working correctly. If it's not something the current version allows, as far as functionality, they develop a solution for the next version because they assume if one company has that need that others will as well.
    • I've never lost touch with our sales representative. She checks in at least twice a year, if not more, to make sure that we are happy with their product and to see if we need anything. I've rarely needed anything, but when I did she made sure to have the correct person contact me regarding what I asked for and she followed up to make sure the request was resolved.
    • EDI is a very complex language and making any changes can cause errors in other areas that you aren't aware of. Astera Centerprise creates an environment that is much easier to understand than looking at a raw data file. The functionality allows us to make changes to each transaction within a file in under a minute with no errors created. Making these changes before we had Astera Centerprise took a week for one file. We can now get to more files to create clean data for the state and have reached 97% acceptance.
    • Centerprise's functionality can be applied at any level. It can be a broad change to an entire segment, or it can be a single digit that is changed. You can program the system to look for specific items within a file and change only the records that need to be changed. It can sequence items, it can remove items and it can add items when specifically programmed to. And if you run into a wall creating the program, Astera's help desk will help you get past it. And the program language used is easy to understand as well. If you understand functions in Microsoft Excel or SQL statements, you will be able to use this product.
    Amanda Moede | TrustRadius Reviewer

    Oracle Data Integrator

    • Oracle Data Integrator nearly addresses every data issue that one can expect. Oracle Data Integrator is tightly integrated to the Oracle Suite of products. This is one of the major strengths of Oracle Data Integrator. Oracle Data Integrator is part of the Oracle Business Intelligence Applications Suite - which is highly used by various industries. This tool replaced Informatica ETL in Oracle Business Intelligence Applications Suite.
    • Oracle Data Integrator comes with many pre-written data packages. If one has to load data from Excel to Oracle Database, there is a package that is ready available for them - cutting down lot of effort on writing the code. Similarly, there are packages for Oracle to SQL, SQL to Oracle and all other possible combinations. Developers love this feature.
    • Oracle Data Integrator relies highly on the database for processing. This is actually an ELT tool rather than an ETL tool. It first loads all the data into target instance and then transforms it at the expense of database resources. This light footprint makes this tool very special.
    • The other major advantage of Oracle Data Integrator, like any other Oracle products, is a readily available developer pool. As all Oracle products are free to download for demo environments, many organizations prefer to play around with a product before purchasing it. Also, Oracle support and community is a big advantage compared to other vendors.
    Anonymous | TrustRadius Reviewer

    Cons

    Astera Centerprise

    • 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.
    Andre Beaumont | TrustRadius Reviewer

    Oracle Data Integrator

    • ODI does not have an intuitive user interface. It is powerful, but difficult to figure out at first. There is a significant learning curve between usability, proficiency, and mastery of the tool.
    • ODI contains some frustrating bugs. It is Java based and has some caching issues, often requiring you to restart the program before you see your code changes stick.
    • ODI does not have a strong versioning process. It is not intuitive to keep an up to date repository of versioned code packages. This can create versioning issues between environments if you do not have a strong external code versioning process.
    James Parks | TrustRadius Reviewer

    Pricing Details

    Astera Centerprise

    General

    Free Trial
    Yes
    Free/Freemium Version
    Premium Consulting/Integration Services
    Yes
    Entry-level set up fee?
    No

    Starting Price

    $0 Lifetime License per Seat

    Astera Centerprise Editions & Modules

    Edition
    Centerprise EnterpriseContact rep1
    1. Lifetime License per Seat
    Additional Pricing Details
    Discounts are provided for 10 pack, 20 pack, 50 pack, and enterprise wide Centerprise Professional licenses.

    Oracle Data Integrator

    General

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services
    Entry-level set up fee?
    No

    Starting Price

    Oracle Data Integrator Editions & Modules

    Additional Pricing Details

    Likelihood to Renew

    Astera Centerprise

    Astera Centerprise 8.2
    Based on 3 answers
    We renew yearly, it is a core part of our department's functionality.
    Anonymous | TrustRadius Reviewer

    Oracle Data Integrator

    Oracle Data Integrator 10.0
    Based on 4 answers
    It is maturing and over time will have a good pool of resources. Each new version has addressed the issues of the previous ones. Its getting better and bigger.
    Anonymous | TrustRadius Reviewer

    Usability

    Astera Centerprise

    Astera Centerprise 8.0
    Based on 5 answers
    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
    Phil Nacamuli | TrustRadius Reviewer

    Oracle Data Integrator

    No score
    No answers yet
    No answers on this topic

    Support Rating

    Astera Centerprise

    Astera Centerprise 8.4
    Based on 21 answers
    The customer support at Astera is amazing. The support team is always friendly, quick to respond, and very knowledgeable of the product and features. Mike O'Quinn went above and beyond and provided great technical assistance when we migrated to a new version of Centerprise. Munira Lalani was also very helpful in answering any licensing and product questions our team encountered.
    Jeffrey Wilson | TrustRadius Reviewer

    Oracle Data Integrator

    No score
    No answers yet
    No answers on this topic

    Implementation Rating

    Astera Centerprise

    Astera Centerprise 9.1
    Based on 6 answers
    Extremely fast implementation. From install to completed data flows in under a day.
    Mark Rubin | TrustRadius Reviewer

    Oracle Data Integrator

    Oracle Data Integrator 7.0
    Based on 2 answers
    No answer on this topic is available.

    Alternatives Considered

    Astera Centerprise

    After the purchase of the new company, we were required to go with their software choices until after TSA. The ETL product they had in use was Informatica. I'm sure Informatica has some great benefits for huge companies, but I am having a hard time adjusting to their style. Centerprise has Dataflows (Informatica has Mappings). You can run a Dataflow all by itself (Informatica you cannot run a Mapping by itself therefore requiring a workflow to run which doubles up your objects and maintenance). With Centerprise you can preview your data in every object in the Dataflow saving development time (with Informatica you cannot). Centerprise has a very nice scheduler to use (An Informatica consultant suggested not using the scheduler in Informatica because it wasn't very good thus, requiring a 3rd party purchase | we are using JAMS). Centerprise is a stand-alone product (Informatica had to be put on an Unix Box--thus requiring unix knowledge). Centerprise can pass variables quick easily between Flows (Informatica has to read parameter files from a stored/LAN location). Both products have the exact same project set up for the Government file transmissions: Centerprise had a total of 112 objects (DataFlows and Workflows). Informatica has 651. The once nice thing about Informatica is that you can call unix jobs to run (not sure if this was available in Centerprise)
    Dawn Bauer | TrustRadius Reviewer

    Oracle Data Integrator

    I have used Trifacta Google Data Prep quite a bit. We use Google Cloud Platform across our organization. The tools are very comparable in what they offer. I would say Data Prep has a slight edge in usability and a cleaner UI, but both of the tools have comparable toolsets.
    Cameron Gable | TrustRadius Reviewer

    Return on Investment

    Astera Centerprise

    • 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.
    Don Smith | TrustRadius Reviewer

    Oracle Data Integrator

    • From a business intelligence perspective, it allows us to provide users with the necessary data and information to make informed decisions.
    • Compared with other Oracle products and licensing, I do not think the pricing was unreasonable.
    • It is part of a larger install, so for ease of use, we purchased it with other Oracle products.
    Anonymous | TrustRadius Reviewer

    Screenshots

    Add comparison