Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Actian DataConnect, and make your voice heard!
Entry-level set up fee?
- Setup fee optional
For the latest information on pricing, visithttps://www.actian.com/data…
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Would you like us to let the vendor know that you want pricing?
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.
- Supported: Connect to traditional data sources
- Supported: Connecto to Big Data and NoSQL
- Supported: Simple transformations
- Supported: Complex transformations
- Supported: Data model creation
- Supported: Metadata management
- Supported: Business rules and workflow
- Supported: Collaboration
- Supported: Testing and debugging
- Supported: Integration with data quality tools
- Supported: Integration with MDM tools
- 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
|Small Businesses (1-50 employees)||20%|
|Mid-Size Companies (51-500 employees)||40%|
|Enterprises (more than 500 employees)||40%|
|Deployment Types||On-premise, SaaS|
|Operating Systems||Windows, Linux|
|Supported Countries||North America, Europe, Asia-Pacific|
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.
The choice to use Actian DataConnect really comes down to pricing and the type of integration project you are performing, specifically with the requirements, whether you want the integration to be on-premise or in the cloud, can you install agents on your servers etc. For integration tools it runs head to head with its competitors.
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.
I wouldn't recommend Data Integrator over SSIS, but it may be a better tool than other ETL offerings. Having a background in the Microsoft Stack, I am hesitant to recommend any other products especially in a Microsoft-centric company. If this was the only option to use, I think it does a good job at integrating systems after taking time to learn the approach. "Maps" in Data Integrator is definitely different than "process flow" philosophy in SSIS.