What users are saying about
16 Ratings
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
16 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.7 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

SAS/Access

SAS/Access is well suited for companies who need to manipulate and analyze large databases and data-sets. It does the same thing as SQL, and if you already know basic SAS coding it is easier to pick up. SAS/Access works well with analyzing data from multiple data-sources at once, including large databases stored in external and virtual environments like Hadoop. Data can be easily reassembled from relational databases for use by the user. SAS/Access is not necessary if you are only pulling data from one database that you have the physical file for.
Nikardi Jallah | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Actian DataConnect
9.0
SAS/Access
9.7
Connect to traditional data sources
Actian DataConnect
10.0
SAS/Access
10.0
Connecto to Big Data and NoSQL
Actian DataConnect
8.0
SAS/Access
9.5

Data Transformations

Actian DataConnect
9.5
SAS/Access
8.5
Simple transformations
Actian DataConnect
10.0
SAS/Access
9.0
Complex transformations
Actian DataConnect
9.0
SAS/Access
8.0

Data Modeling

Actian DataConnect
8.0
SAS/Access
8.8
Data model creation
Actian DataConnect
8.0
SAS/Access
9.0
Metadata management
Actian DataConnect
8.0
SAS/Access
9.0
Business rules and workflow
Actian DataConnect
8.0
SAS/Access
9.0
Collaboration
Actian DataConnect
8.0
SAS/Access
9.0
Testing and debugging
Actian DataConnect
8.0
SAS/Access
8.0
feature 1
Actian DataConnect
8.0
SAS/Access

Data Governance

Actian DataConnect
9.0
SAS/Access
9.7
Integration with data quality tools
Actian DataConnect
8.0
SAS/Access
9.5
Integration with MDM tools
Actian DataConnect
10.0
SAS/Access
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

SAS/Access

  • Secure connections to databases
  • Managed access to databases and data
  • Customized access to databases
Larry Burns | 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

SAS/Access

  • Syntax for the connection string can be tricky
  • Specification of the data source driver can be tricky
Jim Metcalf | 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

SAS/Access

SAS/Access 10.0
Based on 4 answers
I have always received excelled service working with SAS technical support. Additionally, the tool is used so widely that there are many online resources and use cases that allow you to see many other uses or support routes.
Larry Burns | 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

SAS/Access

Datastage might be the closest one. Being a full ETL tool, it's weird to compare both. Datastage might be more robust for extraction but it lacks the simplicity that the end users need for everyday data extract and analysis.
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

SAS/Access

  • Bring usable data together quickly for downstream consumption e.g. modelling and reporting.
Horst Wolter | TrustRadius Reviewer

Pricing Details

Actian DataConnect

General

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

SAS/Access

General

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

Rating Summary

Likelihood to Recommend

Actian DataConnect
8.0
SAS/Access
10.0

Support Rating

Actian DataConnect
8.0
SAS/Access
10.0

Add comparison