Actian DataConnect

(10)
4.1 out of 5 stars

The Actian Cloud Edition offers Actian DataConnect (previously Pervasive Data Integrator Cloud) – a fast, powerful, cost-effective and easy-to-use data integration tool.

Work for Actian DataConnect?

Learning about DataConnect?

We can help you find the solution that fits you best.

Actian DataConnect Reviews

Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • User Industry
Ratings
Company Size
User Role
User Industry
Showing 10 DataConnect reviews
LinkedIn Connections
DataConnect review by <span>Nick H.</span>
Nick H.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

A developers perspective on Pervasive's Data Integrator

What do you like best?

The flexibility that the solution allows when mapping, moving, and transforming data. Using the data integrator, it was very easy to program for all sorts of incoming data and handle all types of situations based on events, data quality, variables, etc.

What do you dislike?

I wish they would get rid of that proprietary scripting language they use (RIFL) and instead go with c# or python or any other more standardized language. RIFL was hard to lookup when we had questions or problems because it's not used anywhere else.

Recommendations to others considering the product

I have an interesting perspective on Data Integrator because I worked with it for almost 4 years before switching companies. To be honest, when I started working with Data Integrator I didn't like it at all. I found it tough to program in, specifically the RIFL scripting because there is very little community support when compared to the likes of c# or javascript. After the initial learning curve, it got much better for me but I still wasn't 100% sold on the product. It wasn't until I got to my new company where we DON'T have Data Integrator that I fully understood the value Pervasive brings to the industry. At this company, we use SSIS to perform the same kind of data movements that I did previously using Data Integrator. While I do see some benefits of using SSIS, I am currently pushing management to move over to Pervasive. It's a million times more flexible and user friendly.

What business problems are you solving with the product? What benefits have you realized?

My primary role when working with Pervasive's Data Integrator was as a data migration analyst. We would migrate massive databases between software suites, vendors, and software versions. Without this software, the migrations would have been a million times harder and far less consistent. Using Data Integrator, we could push out hundreds of migrated data sets each month with relative ease and we were also able to scale the product out to help with the largest of our migrations.

Sign in to G2 Crowd to see what your connections have to say about Actian DataConnect
Headshots
DataConnect review by <span>Steve H.</span>
Steve H.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Healthcare and Automation

What do you like best?

The variety of connectors to read different file formats. This is important especially in the healthcare space where maintaining HIPAA compliance is becoming mandatory.

What do you dislike?

Not a large user community rely upon for help. Now that our users are proficient, we are continually finding better, more creative ways to use the tools. To that end, having access to samples, use cases and insight into how other customers are using the tools would have enabled us to get to the point we are at even faster.

Recommendations to others considering the product

Before purchasing speak with Actian on the direction they are taking with regard to their integration tools.

What business problems are you solving with the product? What benefits have you realized?

We receive and processes large amounts of data from a broad spectrum of sources. With growth in business came the realization that data volumes would ultimately outpace their manageability. To prevent this, we needed a set of tools that could not only digest and transform a variety of file types (ASCII, COBOL, EDI), but that also provided added functionality to enable full “lights out” automation of our loading process. Pervasive Data Integrator gave us this capability. We now pull files from a secure FTP server, decrypt, stage, transform and load them to our SQL databases without the need for human manipulation. This significantly reduces the time required to process data, and the data itself is inherently more secure. Analysts can spend more time turning this data into usable information.

What ETL Tools solution do you use?

Thanks for letting us know!
DataConnect review by <span>Brian L.</span>
Brian L.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Using Pervasive

What do you like best?

its ease of use, and its functionality. It was really easy for me to pick it up quick.

What do you dislike?

I felt that it had a few limitations with integrating with our automation services when we were doing ETL. Pervasive would sometimes freeze when mapping the different fields from different sources to our fields.

What business problems are you solving with the product? What benefits have you realized?

We were using Pervasive as a tool for data integration from a variety of different data formats from across the real estate agencies, associations and data repository centers. Pervasive came in very handy in matching the fields from different data sources to our standard data sources. I think the ease of use and as long as someone has a basic idea of data integration, Pervasive is easy to pick up.

DataConnect review by Consultant in Biotechnology
Consultant in Biotechnology
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Its an Awesome product to use especially when working with XML files

What do you like best?

I like the way how pervasive recognizes the unstructured XML files and its own way of transformations which are user friendly.

What do you dislike?

in most of the case it is not a quick learning tool just like the other tools in the market. and some transformations are not user friendly like upto the market standards

Recommendations to others considering the product

its very nice product when your organisation is very small and dealing mainly with unstructured targets or sources.

What business problems are you solving with the product? What benefits have you realized?

we used this product to load the web user reviews to and flow to third parties as well for analytic purposes.

we see significant differences in sales using the reviews.

DataConnect review by <span>Tu L.</span>
Tu L.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Exploring and evaluating product

What do you like best?

It is a SaaS model so you can say it got all advantages of SaaS

What do you dislike?

It is a SaaS model so you can say it got all disadvantages of SaaS

Recommendations to others considering the product

Yes

What business problems are you solving with the product? What benefits have you realized?

Integrate of data from different database vendors

DataConnect review by <span>Aspen O.</span>
Aspen O.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Used Data Integrator in classroom to show students how to do ETL without coding

What do you like best?

I loved the ability to have secure integration without coding

What do you dislike?

More developer information is needed to build custom plug ins

What business problems are you solving with the product? What benefits have you realized?

Continuous ETL between ERP and CRM systems

Kate avatar
Kate from G2 Crowd

Learning about Actian DataConnect?

I can help.
* We monitor all Actian DataConnect reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.