Astera ReportMiner vs. Oracle Data Integrator (ODI)

ReportMiner is well suited for digitizing PDFs that includes data that follows a pattern such as a bank statement. It saves a bunch of time to make one report that will be able to be used each month for that bank. The program would not be useful if you had to spend the time making a new report each month for a new bank with a few lines of data

I tried various ETL tools and here is [where and] why I recommend Oracle Data Integrator. 1. When you want to process structured data from different databases - Teradata, Exadata, DB2, SQL, Oracle etc. 2. Oracle Data Integrator supports all platforms, hardware, and OS. This is a major advantage compared to other leading tools. 3. The ELT architecture giving a cutting edge performance over leading ETL tools. There is no need to align Oracle Data Integrator between source and target. ODI uses the source and target servers to perform complex transformations. 4. Speeds up the development and maintenance by reducing the code that developers need to write

Incentivized

• It performs its function well, with flexibility and relative ease.
• Ability to easily convert PDF into text, especially in those situations where PDF documents have complicated formats.

• Converts data from various sources into one target format using various business logic rules and integrates with various DBMS types.
• Transformed data from DB2, SQL Server and other Oracle databases into flat files and then used ETL jobs to load into Oracle DB target
• Data Integrator and Goldengate were used together to accomplish the data movement needed for business and data consolidation in live environment. Data Integrator helped with development and in reducing lead time to convert data into target.

Incentivized

• Could provide some features to help with advanced analytics for big data. (i.e. larger data sets)
• Too much clutter on their Youtube page, they should highlight the tutorials so they are easier to find for new users. Get rid of old tutorial video playlists so the organization is clean and up to date.
• Have sales rep follow up with customers to offer product updates, new product releases, and do check ins to see if customers have suggestions for feature improvement.

• Oracle support is not the best when needing help with the system
• The documentation is also very poor and takes very long to generate
• Some parts of it are not intuitive to use and get hard to troubleshoot
• Like other Oracle products, you must have very, very thorough knowledge about their systems to understand
• Like all Oracle products, cost is high

Incentivized

It is the best way to get a multi line record from pdf to Excel in one row.

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.

Astera ReportMiner had a more concentrated feature stack for what we were looking for at a cheaper price so we went with it instead of other competitors that had more features, more complicated UIs, and had more expensive subscription packages because of it. They also had an easy purchase/setup process at the time of our procurement.

Talend Data Integrator has been evaluated during the setup of the architecture for a customer, in comparison to ODI, since it's an open source ETL. But, differently from the meaning of "open source", it has licence costs too that aren't that different from ODI ones. Moreover, the other components of the business intelligence architecture of the customer were Oracle, so we thought that ODI would suit at best with them, more than a different vendor software.

Incentivized

• Efficient and automated data extraction. Saves time and resources.
• User-friendly interface and good documentation. It is therefore easiest to learn and apply in a short time.
• Documents, which have various formats of data tables or arrangement, needed a lot of manual fixing. So it required a lot of time for validation and quality control.

• Oracle Data Integrator helps provide a business with the data it needs to defend the decisions it makes.
• Oracle Data Integrator allows you to analyze data from what can be separate, different, and often outdated data sources. It allows you to make direct comparisons when analyzing data from different pieces of equipment.
• Data from Oracle Data Integrator was used to analyze manufacturing quality and drive down spoilage, saving the company money.

Incentivized