ReportMiner provides an automated solution for data ingestion and integration for unstructured document data sources. This data extraction software enables you to liberate business data trapped in documents such as PDFs, PDF forms, PRN, TXT, RTF, DOC,DOCX, XLS, and XLSX. With features for data scrubbing, business rules-based data quality verification, data transformation (merging, splitting, normalizing, denormalizing, and more), and loading into high-end database platforms, an integration flow…
N/A
Oracle GoldenGate
Score 8.2 out of 10
N/A
Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.
$250
Per License
Pricing
Astera ReportMiner
Oracle GoldenGate
Editions & Modules
ReportMiner Enterprise
Contact sales
per user
Data Integration
$250.00
Per License
Offerings
Pricing Offerings
Astera ReportMiner
Oracle GoldenGate
Free Trial
Yes
Yes
Free/Freemium Version
No
No
Premium Consulting/Integration Services
Yes
No
Entry-level Setup Fee
Optional
No setup fee
Additional Details
Discounts are provided for 10 pack, 20 pack, 50 pack, and enterprise-wide ReportMiner Professional licenses.
Astera ReportMiner is well suited for those who work with EMR Data or business operations data where different platforms may report on similar data but not everything is the same between the different systems and how they export their data. It works especially well when systems can't edit their exports so you need to clean up data a lot before they are combined into a single file. It is less appropriate a solution when you are trying to combine large data, let's say thousands of files and need some sort of platform to deduce analytic patterns out of it. This is more used for data preparedness rather than big data analysis. This may have changed with recent updates, however they do not do a good job of updating customers on new releases so keeping track of their developments is something worth doing if data management is an important part of your/your company's role.
I think it's a great product. We apply Oracle GoldenGate to several use cases in our organization. 1. Business Continuity Planning, 2. Query Offloading through data replication to a reporting instance of our data, 3. looking into data transformations to help support various queries for different teams within the business.
ReportMiner's OCR accuracy is flawless to my experience. I use the program to pull values from check details, and have yet to find an error.
ReportMiner's interface is easy to learn. I never even got formal training on the program. I watched some YouTube videos and learned as I went.
ReportMiner training personnel is very knowledgeable and quick to respond. Anytime I ran into a problem I could not figure out on my own, they would get back with me within a half a day.
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.
Once set up, it's very easy to use and keep running, it's getting to that point that can make it cumbersome to some. Also, depending on the data that you want to replicate, the configuration files can become quite cumbersome to maintain. Learning curve can be high for some who are not as experienced with databases and transactions.
Oracle Support for Oracle GoldenGate has been quite responsive and quite helpful in the few situations where we've needed it. Furthermore, the documentation on Oracle GoldenGate is so good that we often do not need to contact support with issues as the fix is already documented and able to be run by us without needing to open a ticket.
We've had Oracle consultants come as well for training days to talk about new features, parts of Oracle GoldenGate we may not be using and things of that nature. The consultants they send are great as they're very knowledgeable about all things Oracle GoldenGate and great resources for any questions or concerns you may have with the product.
We used Oracle University for our Oracle Golden Gate Training and it was top notch. We were able to turn our whole DBA team to Oracle GoldenGate newbies to Oracle GoldenGate troubleshooting experts in a matter of a few days, while this obviously did not come cheap, the company felt that it was worth the investment.
If Oracle GoldenGate is new to your organization, expose as many DBAs as possible to it. Having your whole team fluent in it will overcome early operational hurdles and allow it to more quickly become an accepted and supported part of your supported platform for your team that will enable the business to use it to its fullest.
I have never actually used another program like ReportMiner. Before I was just using PDF viewers such as Adobe that had OCR capabilities. I would have to select a range of numbers and copy and paste to Excel. It was tedious, slow, and sometimes error prone. I chose to learn ReportMiner because it saves me at least 4 times the amount of time I would have to use by copy and pasting.
We use Oracle Data Guard as a backup tool, but not for data replication. Data Guard is not suited for real-time data replication in our non-normalized reporting database nor for the database we are using for our upgrade project, as Data Guard is not able to transform data and is not able to synchronize data into different schemas, which is necessary for our project. Additionally, our project database is on Oracle 12g not 11i: I am not 100% sure Data Guard is able to replicate from 11i to 12g
Have never had any issues with scaling Oracle GoldenGate itself, however Oracle GoldenGate Monitor does have scaling issues, but with Oracle GoldenGate now able to be monitored by Oracle Enterprise Manager, this is no longer an issue, in my opinion.
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.
In earlier versions, DDL support was limited as well as the need of primary key constraints in the source tables. This made me create partitions, sub-partitions, truncatations and perform other operations upon they are performed in source systems and I need to discuss with source system administrators and need to convince them to let them create primary keys for replicated tables.
But both issues are solved now.
Installation is straightforward, easy.
Deployed everything within Oracle Data Integrator.
Developing 1000 of ODI interfaces for loading into Operational Data Store took not more than 100 man/days. But, adding them to Golden Gate is taking not more than 5 man/days.
Management Pack and VeriData are additional packs for your management and data verification needs.
