Pervasive Migration Utility Demonstration – v9 to v10

Pervasive has recently developed an effective utility for migrating Data Integrator v9 projects into Pervasive Data Integrator v10. The process is quick and relatively smooth; however, there is the potential for challenges to arise due to the complex nature of most DI projects.  If you are thinking about transitioning from v9 to v10, please reach out to Emprise to learn how our team of Certified Pervasive Developers can help your transition to v10 be successful.

Advertisements

Emprise Sponsoring Pervasive IntegrationWorld 2013

Emprise Technologies is proud to be a Platinum sponsor of Pervasive IntegrationWorld 2013.  We are also sponsoring the Data Clinic. If you are going to be at IntegrationWorld, come by the Data Clinic and ask one of our Pervasive certified consultants questions about Data Integrator. Bring your toughest Data Integration questions: The Emprise team has collective 30,000 hours of Pervasive work, so we doubt you’ll be able to stump us. But we’re open to your trying! See you at IntegrationWorld 2013. We’ll be in the Hyatt Hill Country Ballroom A-C from 10:15 a.m. until 4:00 p.m. on Monday, April 15 and again on Tuesday, the 16, from 9:20 a.m. – 12:00 p.m.

Secret #2 to Maximize Pervasive Data Integrator

What
When using an Excel document as a source, the header row is used to determine the names of the fields for the source connector. In order to ensure the field names will be consistent, one can insert a row into the beginning of each document before it is processed. For example, today our client sent us an Excel document that contained the following header in column A: “Account Number”, but yesterday, the value in column A was: “Acct Num”.

Why
Dynamically inserting a static header row into an Excel document allows for the processing of Excel documents regardless of whether or not they contain a consistent header row from the client.

When
This should be done when you are asked to process an Excel document that is missing a header row or does not have a consistent header row.

Who
The use of consistent column headers is beneficial to the:

  • Developer – Implements the code to add a header row to the Excel document prior to processing.
  • End User – Is able to review and utilize the new data loaded into the system.

Where
Inserting a header row to an Excel document is implemented using a RIFL step within Pervasive Data Integrator Process Designer.

How
Before the Excel document is processed, use a RIFL step to open the document and insert a static header row at the beginning of the document that matches the column names identified in the Map’s source schema. If the file may come in with or without a header, you can add a Source Filter to your Map that processes the Excel document. The filter can validate each row to filter out any extra or unwanted header rows and rows that only contain whitespace, which will allow you to process the data in the document successfully.

More
Subscribe to the Emprise Technologies YouTube channel to access our library of video demos.

Secret #1 to Maximize Pervasive Data Integrator

What
In most cases, Pervasive Data Integrator users want to react and handle errors has they occur. By default, Pervasive will exit a Process as soon as an error is encountered. Alternatively, a Process can be configured to allow errors, which will allow the Process to continue executing through completion regardless of an error occurring. What we have found is that neither option is practical with Pervasive Data Integrator.

Responsive error handling can be introduced to ensure that the business needs are met and all errors are handled appropriately as they occur. For example, if a step in a Process cannot find a file, the Process should not abort, nor should it continue execution as if the file exists. Instead, use responsive error handling to manage the missing file exception and send an email to the appropriate recipients.

Why
With Pervasive Data Integrator, custom error handling should be used to ensure that a Process is behaving as intended and as defined by business rules. By introducing responsive error handling, you can gather and react to errors as they occur, versus digging through error logs to identify why a Process aborted.

When
Data Integrator Processes that contain steps which are dependent upon the success of a previous step, are ideal candidates for implementing responsive error handling.

Who
The use of responsive error handling is beneficial to the:

  • Developer – Implements the code for responsive error handling.
  • End User – Defines business rules and reviews results of responsive error handling.

Where
Responsive error handling is implemented within Pervasive Data Integrator Process Designer.

How
During the execution of a Process, Pervasive stores metadata about the Process and its steps and session objects. The metadata can be accessed via RIFL Script in both RIFL steps and Event Handlers. One approach is to create a RIFL Script step immediately after each step that ignores an error. This ensures that errors are caught immediately as they occur and can be handled appropriately. To implement responsive error handling, the Process must not be configured to “Break on First Error”. Additionally, all steps should be set to “Ignore Error”. Then, insert RIFL steps to handle errors appropriately.

More
Subscribe to the Emprise Technologies YouTube channel to access our library of video demos.

Pervasive Data Integrator – Macro Definition Variables, Part 2

Continued from Part 1. Learn more about how to use macro definition variables along with tips & tricks when using  Pervasive Data IntegratorEmprise Technologies has created a 2 part video demo for developers using DI. Don’t forget to subscribe to our Emprise Technologies YouTube channel to watch more informational videos from us.

Pervasive Data Integrator – Using Macro Definition Variables, Video Demo Part 1

Want to learn more about how to use macro definition variables Pervasive Data Integrator? Emprise Technologies has created a 2 part video demo for developers using DI. This video is part 1 of the demo for using macro definition variables. Don’t forget to subscribe to our Emprise Technologies YouTube channel to receive more informational videos from us. We’ll post the 2nd video shortly.