What users are saying about

Alteryx Analytics

Top Rated
111 Ratings

Alteryx Analytics

Top Rated
111 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101

Oracle Data Integrator

92 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.8 out of 101

Add comparison

Likelihood to Recommend

Alteryx Analytics

Well suited: if an organization already has a lot of running ETLs or pipelines but need to systemize them, Alteryx is a good choice. It would be good to figure out how well Alteryx would be harmonized with the existing components, but in a general sense, it may be well harmonized. Less appropriate: Alteryx is good for "automation", but some data developers and analysts may prefer to remain and keep using SQL tools. One should be careful of not just adding "one more layer or tool" into the existing pipeline and make it more complicated to manage.
No photo available

Oracle Data Integrator

  • You can switch to source, staging area or target to improve your querying performance. If you have to do a join from different source systems, you can decide which data to move to where and figure out the place for best output.
  • Variables can help you to perform loops and conditional statements in packages for helping ETL. What else do you need?
  • It helped me to reduce a slowly changing dimensions type 2 with the same output, from 22,000 seconds to 168 seconds.
  • Loaded 10.000+ files to a table from 1000+ different sources under 20 minutes with approximate 300GB of data per day.
Gurcan Orhan profile photo

Feature Rating Comparison

BI Standard Reporting

Alteryx Analytics
7.6
Oracle Data Integrator
Pixel Perfect reports
Alteryx Analytics
8.0
Oracle Data Integrator
Customizable dashboards
Alteryx Analytics
5.8
Oracle Data Integrator
Report Formatting Templates
Alteryx Analytics
9.0
Oracle Data Integrator

Ad-hoc Reporting

Alteryx Analytics
8.5
Oracle Data Integrator
Drill-down analysis
Alteryx Analytics
8.1
Oracle Data Integrator
Formatting capabilities
Alteryx Analytics
8.2
Oracle Data Integrator
Integration with R or other statistical packages
Alteryx Analytics
9.6
Oracle Data Integrator
Report sharing and collaboration
Alteryx Analytics
7.9
Oracle Data Integrator

Report Output and Scheduling

Alteryx Analytics
8.6
Oracle Data Integrator
Publish to Web
Alteryx Analytics
8.0
Oracle Data Integrator
Publish to PDF
Alteryx Analytics
8.6
Oracle Data Integrator
Report Versioning
Alteryx Analytics
9.0
Oracle Data Integrator
Report Delivery Scheduling
Alteryx Analytics
8.9
Oracle Data Integrator

Data Discovery and Visualization

Alteryx Analytics
8.1
Oracle Data Integrator
Pre-built visualization formats (heatmaps, scatter plots etc.)
Alteryx Analytics
8.0
Oracle Data Integrator
Location Analytics / Geographic Visualization
Alteryx Analytics
7.7
Oracle Data Integrator
Predictive Analytics
Alteryx Analytics
8.7
Oracle Data Integrator

Access Control and Security

Alteryx Analytics
8.3
Oracle Data Integrator
Multi-User Support (named login)
Alteryx Analytics
8.0
Oracle Data Integrator
Role-Based Security Model
Alteryx Analytics
8.0
Oracle Data Integrator
Multiple Access Permission Levels (Create, Read, Delete)
Alteryx Analytics
9.0
Oracle Data Integrator

Mobile Capabilities

Alteryx Analytics
4.0
Oracle Data Integrator
Responsive Design for Web Access
Alteryx Analytics
4.0
Oracle Data Integrator

Platform-as-a-Service

Alteryx Analytics
Oracle Data Integrator
7.1
Ease of building user interfaces
Alteryx Analytics
Oracle Data Integrator
7.3
Scalability
Alteryx Analytics
Oracle Data Integrator
8.2
Platform management overhead
Alteryx Analytics
Oracle Data Integrator
6.4
Workflow engine capability
Alteryx Analytics
Oracle Data Integrator
8.2
Platform access control
Alteryx Analytics
Oracle Data Integrator
7.3
Development environment creation
Alteryx Analytics
Oracle Data Integrator
7.3
Development environment replication
Alteryx Analytics
Oracle Data Integrator
7.3
Issue monitoring and notification
Alteryx Analytics
Oracle Data Integrator
6.4
Issue recovery
Alteryx Analytics
Oracle Data Integrator
6.4
Upgrades and platform fixes
Alteryx Analytics
Oracle Data Integrator
6.4

Pros

  • Cleaning datasets
  • Preparing data for analyzing
  • Customer data analytics
  • Transforming data from one format to other
Sanket Bharaswadkar profile photo
  • It's fast. If you have used OWB before, you will notice how much faster ODI is.
  • The Knowledge Modules (KMs) are extremely useful.
  • Integrates really well with the rest of the Oracle Technology Stack (GoldenGate, WebLogic, OEM, and, of course, the Oracle Enterprise Database).
Ely Turkenitz profile photo

Cons

  • Poor documentation
  • Costly
  • Overkill for simple tasks
  • Not many options for data visualization
Sanket Bharaswadkar profile photo
  • The product sometimes have small bugs, which are fixed with patches.
  • Very complex queries are difficult to do in graphics mappings
  • It has functionality versions but can not develop in parallel a same object.
Carlos Sanz Porro profile photo

Likelihood to Renew

Alteryx Analytics6.5
Based on 14 answers
I personally have moved to a different position that does not require data analysis tools. I really enjoyed working with Alteryx and think it is a great tool, but have moved to a different organization and role.
Mika Silverman profile photo
Oracle Data Integrator10.0
Based on 4 answers
ODI is your power to any kind of database, operating system, big data or others.
Gurcan Orhan profile photo

Usability

Alteryx Analytics10.0
Based on 2 answers
Through a graphical UI one can perform engineering and development, other vendors do not have such a code-less interface.
Nick Lensing profile photo
No score
No answers yet
No answers on this topic

Reliability and Availability

Alteryx Analytics10.0
Based on 1 answer
I use many programs and compared to others, Alteryx virtually never goes down, freezes up or gives an application error. Over a 4 year time period that I have used this program, any of these may have happened 3 times. It is an incredibly stable program that I feel completely confident in.
Dan Chapman profile photo
No score
No answers yet
No answers on this topic

Support

Alteryx Analytics9.9
Based on 2 answers
Overall pretty good. Depending on the quality of the question posed the CS team will get back as they are available
Nick Lensing profile photo
No score
No answers yet
No answers on this topic

Implementation

Alteryx Analytics10.0
Based on 1 answer
There is really not much to it (the installation, that is). Once you get it installed, along with any of the add-ons (demographics, R, etc.), you are up and running almost immediately. There is really no additional setup. You can immediately begin blending data, running demographics, performing spatial queries, running predictive analysis, etc. And for many of these functions, the learning curve is quite easy.
Dan Chapman profile photo
Oracle Data Integrator7.0
Based on 1 answer
No answer on this topic is available.

Breadth of Deployment

Our company kept it contained in the marketing department. Other departments may not understand it.
No photo available
No answers on this topic

Alternatives Considered

We tested this against several COTS packages and found Alteryx to be a more cost effective solution that could be deployed to a variety of user types
Mark Frisch profile photo
We thought IBM was too expensive and more difficult to use. With Microsoft, since we have our main application running with Oracle DB, we understood it’d be easier for us to work with ODI.
Federico Shortrede profile photo

Collaboration and Sharing

Alteryx Analytics7.2
Based on 16 answers
Other than being able to load my colleagues modules, I don't really use any other collaborative features in Alteryx.
Darrell Haley Jr. profile photo
No score
No answers yet
No answers on this topic

Data Integration

Alteryx Analytics8.9
Based on 16 answers
Range of sources is the definitely the reason it deserves a 9 out of 10. From someone lacking a technical background, I enjoy using Alteryx in some of my project management responsibilities, and being able to load all the deliverables I am tracking is a huge differentiator from an Excel spreadsheet.
Darrell Haley Jr. profile photo
No score
No answers yet
No answers on this topic

Return on Investment

  • Faster data processes (appending various data)
  • Non-gis people have been able to to geocode/build trade areas (this is positive and negative)
  • Quickly generate a standardized way of research processes
No photo available
  • Oracle support is not productive when it comes to ODI
  • Getting resources is a pain
  • Quick turn around time in building code
No photo available

Pricing Details

Alteryx Analytics

General
Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
No
Alteryx Analytics Editions & Modules
Alteryx Analytics
On-premise Edition
Alteryx Designer
$3,9951
Alteryx Designer with Spatial
$12,9951
Alteryx Designer with Data
$29,9951
Alteryx Server
$45,0002
1. per user, per year
2. per server, per year
SaaS Edition
Alteryx Analytics Gallery
$1,5001
1. per user, per year
Additional Pricing Details
The above prices are in USD for Alteryx products and are per-year subscription prices based on a 3-year contract, with annual payment.

Oracle Data Integrator

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Oracle Data Integrator Editions & Modules
Oracle Data Integrator
Additional Pricing Details