Improvado vs. Oracle Autonomous Data Warehouse vs. ZAP Data Hub

This solution helped us when we were stuck trying to explore data deeper and didn’t have enough resources to prepare data for further analysis. The software solves data integrity problems bringing more granularity to all insights. Integration with data visualization tools and well-arranged insights shows how each of the company’s marketing channels performs in real-time. Improvado is also useful for risk mitigation when launching or adjusting marketing strategies. It may also become a valuable tool for businesses, who are aiming at automation and the elimination of routine processes. ETL processes automation unleashes marketing analysts’ potential granting them more time for research of marketing reports.

II would recommend Oracle Autonomous Data Warehouse to someone looking to fully automate the transferring of data especially in a warehouse scenario though I can see the elasticity of the suite that is offered and can see it is applicable in other scenarios not just warehouses.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

ZAP is an incredible tool for those IT Organizations that need to stay lean. Within days, I was able to implement the ZAP solution instead of hiring Developers and ETL developers to tie into multiple Data infrastructures.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• ETL processes. Once adjusted, Improvado never fails to streamline data from our advertisement platforms to the data warehouse.
• Variety of data sources. Improvado extracts data from over 200 sources, including both well-established platforms and the ones that are rapidly gaining momentum.
• Full-cycle support. Improvado provided us with a dedicated manager available 24/7. Any issues that arose during the product integration were settled in a matter of minutes.
• Flexibility and client-focused approach. After the integration, we adjusted our marketing campaign and needed new ad platforms to be integrated. The vendor allocated the development team ASAP to add new connectors to our existing network.
• Professional services package. The company doesn't provide dashboard views by default. However, we had no time to figure out how to do it ourselves, so we hired a team of Improvado's analysts that set everything up for us.

• Very easy and fast to load data into the Oracle Autonomous Data Warehouse
• Exceptionally fast retrieval of data joining 100 million row table with a billion row table plus the size of the database was reduced by a factor of 10 due to how Oracle store[s] and organise[s] data and indexes.
• Flexibility with scaling up and down CPU on the fly when needed, and just stop it when not needed so you don't get charged when it is not running.
• It is always patched and always available and you can add storage dynamically as you need it.

• Extremely Robust Interface
• Implementation and Connection to Data Stores extremely fast. I was able to implement BI reporting within days.
• Fantastic Support
• Cost Effective Tool for any IT organization. Reduction in FTE, Data Reporting Deployment, and Cube Creation.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Improvado didn’t have all the integrations that we needed. However, they offered full coverage and quickly found ways to extract data from the sources we required.
• The user interface for BI tools may be confusing to inexperienced users. Personally, I didn't have any problems. However, some of the junior marketing specialists from my department needed more time to adapt to the UI. Otherwise, the interface is great.

• It is very expensive product. But not to mention, there's good reasons why it is expensive.
• The product should support more cloud based services. When we made the decision to buy the product (which was 20 years ago,) there was no such thing to consider, but moving to a cloud based data warehouse may promise more scalability, agility, and cost reduction. The new version of Data Warehouse came out on the way, but it looks a bit behind compared to other competitors.
• Our healthcare data consists of 30% coded data (such as ICD 10 / SNOMED C,T) but the rests is narrative (such as clinical notes.). Oracle is the best for warehousing standardized data, but not a good choice when considering unstructured data, or a mix of the two.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• I would love to see a strong integration with Google Analytics. ZAP works great with CRM platforms but would be interested to get the metrics on how marketing campaigns are tied to organic traffic and PPC.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Because

• It is really simple to provision and configure.
• Does not require continous attention from the DBA, autonomous features allows the database to perform most of the regular admin tasks without need for human intervention.
• Allows to integrate multiple data sources on a central data warehouse, and explode the information stored with different analytic and reporting tools.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Understanding Oracle Cloud Infrastructure is really simple, and Autonomous databases are even more. Using shared or dedicated infrastructure is one of the few things you need to consider at the moment of starting provisioning your Oracle Autonomous Data Warehouse.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

We chose Improvado for the following reasons:

• Their data transformation framework cleans, normalizes and prepares data for loading into our data visualization tool;
• We connected our CRM to our analytics tool and as ad account;
• Extensive social media reports - the marketing team can view our ads, posts, comments right from the dashboard.
• Scheduled reports and immediate data sync options help us to get the reports with the most accurate data at the time we need them;
• Google Ads auto-connect new ad accounts.

Our marketing team evaluated Funnel.io and has opted for Improvado because of the following drawbacks:

• With Funnel we’d have to set up an extraction process for each campaign and account manually;
• The more accounts you need to connect or integrations to use, the more you’ll pay;
• Limited data storage options;
• Complicated account export. We had to filter accounts to export through the custom filter rules.

As I mentioned, I have also worked with Amazon Redshift, but it is not as versatile as Oracle Autonomous Data Warehouse and does not provide a large variety of products. Oracle Autonomous Data Warehouse is also more reliable than Amazon Redshift, hence why I have chosen it

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

ZAP has a better interface and user-friendly.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Increased ROI
• Improved cost of acquisition analysis
• Improved CPA, CPI, CPL report drawing process

• Overall the business objective of all of our clients have been met positively with Oracle Data Warehouse. All of the required analysis the users were able to successfully carry out using the warehouse data.
• Using a 3-tier architecture with the Oracle Data Warehouse at the back end the mid-tier has been integrated well. This is big plus in providing the necessary tools for end users of the data warehouse to carry out their analysis.
• All of the various BI products (OBIEE, Cognos, etc.) are able to use and exploit the various analytic built-in functionalities of the Oracle Data Warehouse.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info