What users are saying about
13 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9.2 out of 100
7 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 7.8 out of 100

Likelihood to Recommend

Actian DataConnect

If your company houses a lot of data locally and needs to free up space, the Actian DataConnect Hybrid Cloud Data Warehouse is an excellent solution for the price. It also allows for complex queries and even some basic data analytics, like Market Basket Analysis. Their free trial period is extremely convenient and you may discover more uses for it than you originally think.
Kyle Moninger | TrustRadius Reviewer

Phocas Business Intelligence

If you would like your data in one place with easy access, this is the software for you. You can have data from multiple systems and bring it into one view so that you have a quick and easily visible dashboard for the data you wish to see.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Actian DataConnect
9.0
Phocas Business Intelligence
Connect to traditional data sources
Actian DataConnect
10.0
Phocas Business Intelligence
Connecto to Big Data and NoSQL
Actian DataConnect
8.0
Phocas Business Intelligence

Data Transformations

Actian DataConnect
9.5
Phocas Business Intelligence
Simple transformations
Actian DataConnect
10.0
Phocas Business Intelligence
Complex transformations
Actian DataConnect
9.0
Phocas Business Intelligence

Data Modeling

Actian DataConnect
8.0
Phocas Business Intelligence
Data model creation
Actian DataConnect
8.0
Phocas Business Intelligence
Metadata management
Actian DataConnect
8.0
Phocas Business Intelligence
Business rules and workflow
Actian DataConnect
8.0
Phocas Business Intelligence
Collaboration
Actian DataConnect
8.0
Phocas Business Intelligence
Testing and debugging
Actian DataConnect
8.0
Phocas Business Intelligence
feature 1
Actian DataConnect
8.0
Phocas Business Intelligence

Data Governance

Actian DataConnect
9.0
Phocas Business Intelligence
Integration with data quality tools
Actian DataConnect
8.0
Phocas Business Intelligence
Integration with MDM tools
Actian DataConnect
10.0
Phocas Business Intelligence

BI Standard Reporting

Actian DataConnect
Phocas Business Intelligence
9.4
Customizable dashboards
Actian DataConnect
Phocas Business Intelligence
9.4
Report Formatting Templates
Actian DataConnect
Phocas Business Intelligence
9.4

Ad-hoc Reporting

Actian DataConnect
Phocas Business Intelligence
9.4
Drill-down analysis
Actian DataConnect
Phocas Business Intelligence
10.0
Formatting capabilities
Actian DataConnect
Phocas Business Intelligence
8.6
Report sharing and collaboration
Actian DataConnect
Phocas Business Intelligence
9.6

Report Output and Scheduling

Actian DataConnect
Phocas Business Intelligence
9.0
Publish to PDF
Actian DataConnect
Phocas Business Intelligence
10.0
Report Versioning
Actian DataConnect
Phocas Business Intelligence
8.0
Report Delivery Scheduling
Actian DataConnect
Phocas Business Intelligence
9.2

Data Discovery and Visualization

Actian DataConnect
Phocas Business Intelligence
8.3
Pre-built visualization formats (heatmaps, scatter plots etc.)
Actian DataConnect
Phocas Business Intelligence
8.0
Location Analytics / Geographic Visualization
Actian DataConnect
Phocas Business Intelligence
9.0
Predictive Analytics
Actian DataConnect
Phocas Business Intelligence
8.0

Access Control and Security

Actian DataConnect
Phocas Business Intelligence
8.8
Multi-User Support (named login)
Actian DataConnect
Phocas Business Intelligence
8.8
Role-Based Security Model
Actian DataConnect
Phocas Business Intelligence
8.8
Multiple Access Permission Levels (Create, Read, Delete)
Actian DataConnect
Phocas Business Intelligence
8.8

Mobile Capabilities

Actian DataConnect
Phocas Business Intelligence
9.5
Responsive Design for Web Access
Actian DataConnect
Phocas Business Intelligence
9.0
Dashboard / Report / Visualization Interactivity on Mobile
Actian DataConnect
Phocas Business Intelligence
10.0

Pros

Actian DataConnect

  • The large connector base for DataConnect is outstanding. However even when they do not have a custom connector, they have a web services Invoker which allows you to connect to any web services.
  • The underlying scripting language is Visual Basic-ish. Very easy to start.
  • The product has been around a long time, through multiple company acquistions, and still is a competitive player via pricing.
  • Support team is awesome.
  • Large user community.
David Byrd | TrustRadius Reviewer

Phocas Business Intelligence

  • Custom reports are simple to create.
  • The ability to manage users and their dashboards is solid.
  • Easy to navigate web interface makes the software accessible from anywhere.
Kenny McGarrity | TrustRadius Reviewer

Cons

Actian DataConnect

  • Sometimes the screen does not load- since it is a web based software, this can be seen as a reliability issue.
  • "Maps" can become somewhat complex, and between multiple developers this can be painful when sharing or explaining others' work.
  • The concept of macros adds flexibility in how to solve problems, but is a separate language and can take time to learn and master.
Justin Duperre | TrustRadius Reviewer

Phocas Business Intelligence

  • Phocas needs to make it easier to connect to different types of databases.
  • The data in Phocas needs to be updated faster in some cases.
  • It needs to provide functions to create better charts and graphs.
Anonymous | TrustRadius Reviewer

Usability

Actian DataConnect

No score
No answers yet
No answers on this topic

Phocas Business Intelligence

Phocas Business Intelligence 9.0
Based on 1 answer
It is a very user-friendly product and is easy to understand. You can get your data from just a quick click and the dashboard loads. You can take the data and drill down easy to find what you are looking for.
Anonymous | TrustRadius Reviewer

Support Rating

Actian DataConnect

Actian DataConnect 8.0
Based on 2 answers
Actian DataConnect is a great product for data storage, processing, and complex querying. It also has the added benefits of basic data analytics and data mining. We were surprised at how easy it was to perform Market Basket Analysis. I would highly recommend this system to a large business and encourage you to start a free trial period.
Kyle Moninger | TrustRadius Reviewer

Phocas Business Intelligence

Phocas Business Intelligence 9.0
Based on 1 answer
Support is responsive. You log a call and they will respond quickly and resolve your issues. We have only had great experiences with the support team.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Actian DataConnect

As I stated earlier, DataConnect makes a head-to-head run against the others. It has advantages and disadvantages compared to the competitors. The choice really comes down to pricing and specific requirement needs for the project you are planning. Questions such as On-premise or Cloud, Security, and Specific Connectors available will drive your decision.
David Byrd | TrustRadius Reviewer

Phocas Business Intelligence

Phocas is easy to use for end users and can be used on desktops, laptops, and phones.
Anonymous | TrustRadius Reviewer

Return on Investment

Actian DataConnect

  • This tool was chosen prior to my arrival and was used to build three integrations. We have decided to switch to SSIS since we have licenses for it and it is a more common tool for ETL integrations.
  • It has been difficult to network with individuals that have experience with this tool.
  • Having been a part of a software package purchased, we have chosen to use a different tool for future integrations and plan to rewrite existing integrations.
Justin Duperre | TrustRadius Reviewer

Phocas Business Intelligence

  • It has given our business a view on data
  • We can access it from anywhere
  • You can have multiple dashboards for different information
Anonymous | TrustRadius Reviewer

Screenshots

Actian DataConnect

Pricing Details

Actian DataConnect

General

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

Phocas Business Intelligence

General

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

Rating Summary

Likelihood to Recommend

Actian DataConnect
8.0
Phocas Business Intelligence
8.1

Usability

Actian DataConnect
Phocas Business Intelligence
9.0

Support Rating

Actian DataConnect
8.0
Phocas Business Intelligence
9.0

Add comparison