Join your peers in Boston for
the Data Integration Summit

Metamorphosis, now in its third year, brings ISVs, ASPs, systems integrators, technology partners, and industry analysts together to discuss best practices for delivering integration, share successes, and foster partnerships for growth.

"If I could only attend one integration event for ISVs this year, it would be Metamorphosis."
– Dan Beck, Senior Product Manager, Intuit

"Our systems integration business is always looking for repeatable processes and continuous optimization — Metamorphosis was a great help."
– Krishna Prabhu, Sr. Vice President, Caritor, Inc.

Preview our Agenda or see some of the presentations from past Metamorphosis events. Past presenters have included executives from Intuit, salesforce.com, Epicor, Artemis, Pivotal, CGI-AMS, Eloqua, and other leading solution providers.

If you qualify, the Summit is complimentary. To register, go to http://www.pervasive.com/events/meta5/howtoqualify.asp or
call 1-888-296-5964.

Hoskins: Integration is key to successful SaaS offerings

The recent Opource SaaS Summit was an ideal site for CTO Mike Hoskins to deliver an address on the importance of integration to successful SaaS adoption. "The SaaS adoption rate is gated by the ability of SaaS vendors to deliver data integration capabilities with their solutions," Hoskins said.

"Even if the most optimistic growth projections are achieved, SaaS applications will have to coexist for the next decade with existing applications behind each organization's firewall. Organizations adopt SaaS in many cases to reduce the complexities of software ownership and maintenance. Successful SaaS vendors, therefore, must ensure that they enable the rapid flow of critical data to and from existing applications," Hoskins emphasized.

As an "agent of integration," Pervasive has led the way in helping its customers successfully overcome SaaS adoption barriers with affordable, lightweight integration solutions.

For more information about our solutions, click here.

PostgreSQL's growing acceptance evident in survey

The results from January's PostgreSQL migration survey speak well for PostgreSQL adoption in the months ahead.

Here's a summary:

Some 11% of respondents confirmed they have already migrated, a solid percentage for early adopters. Next, and more striking, around 70% of respondents said they are preparing to make the move to PostgreSQL within the next year. The motivation? Over 50% of participants said costs were the driving factor for migration to PostgreSQL, and around 25% cited features. Interest in PostgreSQL as a mainstream business database continues to be encouraging!

The biggest OS source of migrations is Windows (71%), with Linux (19%) and Unix (5%) a distant second and third. With Linux representing 38% of the responses for target OS, it looks like there might be a significant move from Windows to Linux as part of PostgreSQL migration.

SaaS 101 from Pervasive CTO Mike Hoskins

SaaS and the data integration challenge are discussed in this month's Radio Integration. Learn more about Pervasive's ability to meet the challenge.

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.

Update: Beta release on track!

Pervasive is on track for a Beta release of "Project Dataflow," and we hope to pre-announce it at Java One in May. The dataflow engine has already proven its scalability and flexibility with customers such as the Department of Defense where it serves as the core engine of a data-profiling project for the Defense Logistics Agency.

We will soon be launching a Web micro site with downloads, SDKs and Beta developer support forums. So stay tuned!

J2EE vs. 'Project Dataflow'

It is safe to say that Enterprise Java (J2EE) was invented to provide OLTP (On Line Transaction Processing) for the enterprise Web application developer, with a main focus on managing many, short-lived business transactions. However, if you have a longer-running, data-intensive Java application to write, there really isn't much out there to help. That's where Pervasive's "Project Dataflow" comes in. It is a server framework that provides a component-level SDK so that difficult data manipulation and processing tasks can be broken down into components, arranged in data processing flows (or steps), and replicated into parallel operations where appropriate. All of the hard stuff threading, concurrency, deadlock issues, data reading, data writing, data operators (sum, average, join, split, etc.) is handled by the framework.

So, when you think real-time transaction processing think J2EE. When you think large amounts of data, lots of computations and little time, think "Project Dataflow" from Pervasive.

Email us today for a special edition of Radio Integration – "A Peek Under at Project Dataflow."

Thank for your interest.

Emilio P. Bernabei
Director, Worldwide Product Marketing

PS – We invite you to visit our Integration Online Demo Center, where you can select from different online demos providing you with an extensive overview of our Integration products and solutions.

Pervasive lowers integration costs for healthcare industry

Pervasive's newest release to its product suite provides healthcare customers with a high-value, low-cost way to share data, to improve care delivery and to automate or outsource claims and billing processes with Pervasive MessageStore, Pervasive Data Integrator and Pervasive Business Integrator. Pervasive continues to lead the market, providing the lowest cost, broadest data and business integration functionality in an easy-to-use suite of products. The variety of connectivity – more than 150 data and application connectors – and the breadth of supported healthcare message formats are unmatched, including HL7, HL7v3 (XML), HIPAA, NCPDP, and UB92.

To date, Pervasive products have been used in some of the most demanding claims processing systems in the world. For example, working with technology partner CSC, Pervasive integration technology accelerated Medicaid processing, while meeting HIPAA regulations, for the State of New York. Currently, the New York Medicaid system processes millions of claims per week.

"CSC's core integration expertise, combined with Pervasive's extensive data translation experience, complete with complex mapping and HIPAA rules definition, enabled CSC to provide New York State with the nation's first HIPAA-compliant Medicaid system," said John Palter, CSC's Senior Partner and Program Architect. In addition to CSC and New York State, Pervasive works with technology partners ACS and EDS (First Health) and customers such as the State of California, Per-Se, PHCS, and MEDecision.

Find out more about Pervasive's healthcare solutions.

Integration support for real-time CDI

The breadth of traditional and SaaS connectivity – more than 150 data and application connectors – incorporated in Pervasive's platform underpins data integration services for any customer data model and for instant adaptability to changes in the data model. The new release includes support for salesforce.com, Siebel CRM OnDemand, SalesLogix, as well as Web Services standards. Designed for rapid data profiling and information integration without the high costs of custom programming, the release provides the data infrastructure to power 360-degree views of the customer from multiple CRM and ERP systems.

Pervasive is a trusted provider of integration software for the major CRM products, and has deployed hundreds of CRM and CDI implementations. "Pervasive is an innovative solution for enabling CDI projects, and allows companies to successfully integrate key customer information from salesforce.com with back office data from SAP," said Adam Gross, vice president, developer marketing, salesforce.com. Pervasive is one of the first vendors to provide both salesforce.com AppExchange and SAP-certified integration adapters along with pre-built integration processes for common integration tasks in a ready-to-configure solution.

"With access to transactional information that resides in ERP systems, CRM users have a comprehensive view of their customers," said Bruce Cameron, senior vice president, North American sales, Pivotal Corporation. "With Pervasive, Pivotal customers now have a fast, reliable way to extend Pivotal's platform to integrate their applications and hard to reach data sources, enabling them to maximize the value of their CRM investment."

Pervasive is also one of the few companies to provide data profiling as part of its product suite. Data profiling provides an essential layer of data analysis and integrity checking, allowing companies to pinpoint customer data anomalies before they impact CDI solutions, ensuring that business users and management can make informed decisions based on correct and complete data.

ClearSource actions

One problem encountered with mapping EDI/HIPAA and the many optional segments is the source buffer can carry over data that may not exist in the next occurrence of a repeating loop. The "Clear" in a ClearMapPut only clears the Target buffer.

In the following example, a loop (HL, NM1, and PER segment) occurs multiple times. If your target included fields from each of these segments and you placed your conditional ClearMapPuts as described above, you would find that the fields from the PER segment in the first loop occurrence will propagate to the second occurrence of the loop and still be in the Source buffer – and would be mapped to the target during the second CMP, even though there is no PER segment in the second occurrence of the loop.

ST*S0S*0001
BHT*DDDD*DD**19991231
HL*1**20*D
NM1*DDD*D*NM1Data1*****DD*AAAAA
PER*DD*PERData1*DD*PER1A*DD*PER1B*DD*PER1C
HL*2*1*20*0
NM1*DDD*D*NM1Data2*****DD*AAAAA2
HL*3*2*20*0
NM1*DDD*D*NM1Data3*****DD*AAAAA3
PER*DD*PERData3*DD*PER3A*DD*PER3B*DD*PER3C
SE*12*0001

To get around this, you have to add a ClearSource action (to somewhere like BeforeEveryRecord of the PER segment or AfterPut of the Target) to Clear the Source buffer before mapping the next occurrence of the same segment. This ClearSource action must be added to all optional Source segments to prevent the Source buffer from propagating segments that may not be there.

In instances where you do not have the experience, time, or manpower to create your own EDI/HIPAA maps/processes, check out Pervasive Software's Professional Services Group (PSG) to ensure the most efficient, compliant results.

If you are using any target other than Multimode, a ClearTree-Source action is available that will clear the entire loop if placed at the start of the loop (in the example above, you should place it in the BeforeEveryRecord event of the HL segment).

Next month, watch for tips on mapping repeating segments!

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.