Breaking News

Time is Ticking: Register Now for Metamorphosis 6.0
and IntegratioNext

Knowledge. Opportunities. Austin. It’s a win-win-win. Don’t Miss Metamorphosis 6.0, IntegratioNext.

At Metamorphosis 6.0, learn directly from your peers how agile integration has delivered huge ROI. Connect with 100+ partners both future and current, and spend quality time on mutual growth. Extend your reach, your understanding, and your opportunities for market development. Speed your time to market, your ROI, and your path to success. Stop by the Metamorphosis 6.0 site, see the latest agenda and get on board.

At IntegratioNext, learn more about advanced data flows, SOA integration, extending the value of legacy systems, repeatable integration and event-based integration. Add it up and you get a great value: three deep-dive parallel tracks, one wide-open Data Clinic, 14 customer presentations, 30+ hours of learning time and 100+ peers and speakers. Take a few minutes now and register.

Radio Integration

Radio Integration: Time to delve into 8.12!

Director of Product Management Emilio Bernabei gives you a briefing on the features and benefits of Pervasive Integration 8.12, as well as a peek at the upcoming 8.14.

Click on the player button below to listen to Integration Radio. This audio requires the Flash plug-in, which you can download for free here.

You can also download the audio in MP3 format here. An archive of all of our audios can be found here.

Product News

8.12: A Significant Release for Your Significant Opportunities

8.12 is a significant release to help you master your significant challenges. You now have even more connectors, easier development and improved documentation: You asked for it – we listened, and made it real. Take a few minutes and learn about the new integration possibilities open to you.

Here’s what you’ll receive:

Tech Tip

Using Macros for Passwords

Using macros for your database passwords can be a security risk, unless done properly. Here’s how to do it right.

First a little about Macros:

Macros are symbolic names assigned to text strings, usually in file paths. They are defined in the Macros dialog and are used when creating Maps in Map Designer or Processes in Process Designer. Assigning a meaningful Macro name like “TARGET “ to a file path and using it when creating connections saves time and possible errors.

The main reason to use macros, though, is that they enable you to redefine the text string that a Macro name refers to without having to change your original transformation. You can redefine Macros from the Integration Engine's command line, or create RIFL expressions triggered by events to dynamically redefine a macro during a transformation.

Macros are stored in your workspace in a XML file called macrodef.xml. Once you have created a macro, it can be used by any Process or Transformation in that workspace.

Now it is possible to use a Macro for the password part of a connection, but the password value is stored in clear text in the macrodef.xml file. Granted, someone would need to know where to look to find it, but still it’s a security risk.

If you enter a plain text password into the Map Designer in a source or target connection, then the password is masked in the GUI and is encoded in the tf.xml file that is created when that Map is saved. This is secure, but not dynamic. Changing the password would require opening the Map and changing it.

We can use this encoding, though. Open Map Designer and create a connection to your database that includes the password, then save the Map. Look in the tf.xml file that is created for the encrypted password. It will be in the “ConnectionInfo” tree and it will look something like this:

<Password><![CDATA[AQB7ACAA]]></Password>

The value we want is inside the square brackets, “AQB7ACAA.” So, now we define a Macro, and give it the encoded value.

Then build your Map or Maps. When putting information into the database connection, leave the password blank.

Then put the Map or Maps into a Process. In a Scripting Step in the Process before the Map(s), you can set the Session information to call the Macro. It looks like this:

Project("SessionName").Password = Chr(02) & Macrovalue("MacroName")

The “Chr(02)” is an escape character that tells the program that what follows is encrypted. The Macrovalue function just returns the value of the Macro specified.

So now your Process will run and the password is never written out in clear text anywhere. Down the line, when the password has to be changed, you use Map Designer to encode the new password as above, then set the Macro to the new encoded value. No manipulation of the Maps or Processes is necessary. And it’s secure and dynamic.

Training News

Ramp Up Your Integration Projects Faster With
Pervasive Training

Wring every drop of power and functionality from your investment in Pervasive® Business Integrator™ or Pervasive Data Integrator™ and get your projects moving faster. Pervasive has Integration Training in October in Austin.

Here's the lowdown on the program:

Pervasive Data Integrator and Pervasive Business Integrator Fundamentals is three days of hands-on, workshop-style coursework covering each of the design interfaces and the command line interface to the Integration Engine.

Then Advanced Transformation Techniques is a fourth day covering advanced topics in Map and Process Designers and an introduction to Repository Manager.

Or purchase the Integration Boot Camp (both classes), you get expert training at a $400 savings.

Dates for the October classes:

October 9-11: Pervasive Data Integrator and Pervasive Business Integrator Fundamentals

October 12: Advanced Transformation Techniques

October 9-12: Integration Bootcamp
Combine the Fundamentals and Advanced classes for a savings.
Register now.

If you would like instructions in EDI / HIPAA maps using Document Schema Designer and Validator technology, please contact your Account Executive to arrange a fifth day of class that covers those concepts exclusively. An additional charge will be applicable.

Can’t make it to Austin? Have several techs that you need to bring up to speed? We can come to you. Contact your salesperson about bringing a Pervasive Integration Instructor to your location.

And don’t forget – the User Conference in November. There will be training at the conference as well as special savings. Get Accelerated Pervasive Data Integrator and Pervasive Business Integrator Fundamentals for 25% off during post-conference extended training. Register now!

To Add Pervasive Software to Your Safe Senders List

Due to spam filters differing, and that at times they filter legitimate email, it is highly recommended that you add Pervasive Software domain to your Safe Senders list in your email client. This will ensure that our email correspondence will get to you successfully.

For Outlook 2000 and higher

In your email from Pervasive Software:

1. Open the email from Pervasive Software



2. Click on the Actions menu on the top of your email window.
3. Choose Junk Email.
4. Select Add Senders Domain .... to Safe Senders List to add Pervasive Software to your safe sender list.