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
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.