Actian DataConnect Reviews & Product Details

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Before purchasing speak with Actian on the direction they are taking with regard to their integration tools. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

its very nice product when your organisation is very small and dealing mainly with unstructured targets or sources. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Yes Review collected by and hosted on G2.com.

Integrate of data from different database vendors Review collected by and hosted on G2.com.

Continuous ETL between ERP and CRM systems Review collected by and hosted on G2.com.

Mapping medical data from vendor extracts to internal standardized database structures. Data loads are faster and streamlined. Review collected by and hosted on G2.com.

I need to keep data in sync across prod systems. DI does this well. Review collected by and hosted on G2.com.

Most of the data request problems are solved Review collected by and hosted on G2.com.

Try looking at cast iron or web methods if integrating to on non standard system (which they do not have a plug for) Review collected by and hosted on G2.com.