Why Actian DataConnect goes head to Head with the Big Boys
We use Actian DataConnect to load data in and out of Oracle CRM On Demand and Oracle Sales Cloud. The inbound data comes from many …
Overview
What is Actian DataConnect?
Actian DataConnect is a hybrid integration solution that enables users to integrate anything, anywhere, anytime. It can be deployed in on-premise, cloud, and/or hybrid environments and offers quick onboarding. With its emphasis data quality, data reuse, adaptability and self-service integration,…
Recent Reviews
Pricing
N/A
Unavailable
What is Actian DataConnect?
Actian DataConnect is a hybrid integration solution that enables users to integrate anything, anywhere, anytime. It can be deployed in on-premise, cloud, and/or hybrid environments and offers quick onboarding. With its emphasis data quality, data reuse, adaptability and self-service integration,…
Entry-level set up fee?
- Setup fee optional
For the latest information on pricing, visithttps://www.actian.com/data…
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Would you like us to let the vendor know that you want pricing?
Alternatives Pricing
What is Dataloader.io?
Dataloader.io delivers a cloud based solution to import and export information from Salesforce.
What is Skyvia?
Skyvia is a cloud platform for no-coding data integration (both ELT and ETL), automating workflows, cloud to cloud backup, data management with SQL, CSV import/export, creating OData services, etc. The vendor says it supports all major cloud apps and databases, and requires no software except a web…
Product Details
- About
- Competitors
- Tech Details
What is Actian DataConnect?
Actian DataConnect is a hybrid integration solution that enables users to integrate anything, anywhere, anytime. It can be deployed in on-premise, cloud, and/or hybrid environments and offers quick onboarding. With its emphasis data quality, data reuse, adaptability and self-service integration, DataConnect is designed to support rapid onboarding and deliver the fast time to value.
Actian DataConnect Features
Data Source Connection Features
- Supported: Connect to traditional data sources
- Supported: Connecto to Big Data and NoSQL
Data Transformations Features
- Supported: Simple transformations
- Supported: Complex transformations
Data Modeling Features
- Supported: Data model creation
- Supported: Metadata management
- Supported: Business rules and workflow
- Supported: Collaboration
- Supported: Testing and debugging
Data Governance Features
- Supported: Integration with data quality tools
- Supported: Integration with MDM tools
Additional Features
- Supported: Intuitive design and management
- Supported: Connect anything
- Supported: Design once, deploy anywhere
- Supported: Seamless Migration
- Supported: Data profiling
- Supported: Data Quality
- Supported: Scales rapidly
- Supported: Future-proof and Portable
- Supported: End-to-end Security and Compliance
- Supported: Simplified Architecture
- Supported: Performance Tuning
- Supported: Web Service API Invoker
- Supported: Built-in Text, XML, and JSON Editors
- Supported: Hybrid Agent
Actian DataConnect Screenshots
Actian DataConnect Technical Details
| Deployment Types | On-premise, Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Windows, Linux |
| Mobile Application | No |
| Supported Countries | North America, Europe, Asia-Pacific |
| Supported Languages | English |
Actian DataConnect Customer Size Distribution
| Consumers | 0% |
|---|---|
| Small Businesses (1-50 employees) | 20% |
| Mid-Size Companies (51-500 employees) | 40% |
| Enterprises (more than 500 employees) | 40% |
Comparisons
Compare with
Reviews and Ratings
(17)Reviews
(1-2 of 2)Companies can't remove reviews or game the system. Here's why
We use Actian DataConnect to load data in and out of Oracle CRM On Demand and Oracle Sales Cloud. The inbound data comes from many different sources including JD-Edwards, SAP, IMS, and other CRM type products. Most of the outbound data feeds to other systems via CSV type of files. We use DataConnect for our customer base. Each customer has their own licenses and we support their integrations.
- 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.
- Integration Manager needs better scheduling improvements. Like dependencies, and not running a process again if the prior run is still running.
- New connector development does not seem a priority.
95%
9.5
100%
10.0
100%
10.0
95%
9.5
- Our customer likes the consistent reliable integrations we have built so we [got] a definite return on investment.
- Problems are fairly easy to handle and rework.
- Boomi
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.
May 03, 2016
Data Integrator - A worthy competitor to SSIS?
We use Data Integrator to bridge data from our Admissions software to our Student Information System. It is used by the IT developers only, with guidance from both the Admissions department and Registrars department. We have three bridges we have built using Data Integrator, one for each main branch/type of student. This product allows us to successfully transition the data appropriately into our core system.
- Map multiple source and destination tables - what would be done in many steps in SSIS can be done in one or two "maps" in Data Integrator.
- Platform independent, cloud based, no client software.
- Conversion of data types, write flat files - this helps us with integrating systems.
- Fairly straightforward to use if the user has ETL experience.
- 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.
35%
3.5
70%
7.0
26%
2.6
N/A
N/A
- 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.
Data Integrator was initially a part of a package deal for us with our new Student Information System. It was chosen prior to my arrival at the institution. Since I discovered we have SQL Server licenses, we have decided to use SSIS instead since I have a background in the MSBI stack and SSIS appears to be more straightforward (process flow philosophy vs "map" philosophy.)