These application solutions are designed to give you ideas for how you can use one or more of the Pervasive DataTools products to solve data conversion and data migration challenges for virtually all applications.

In this section we have included information about migrating, converting, and transforming data between disparate applications such as Microsoft CRM, Saleslogix, Siebel CRM, NetSuite, SugarCRM, QuickBooks, SAS, SPSSand many more.

Reading Source Data | Writing Target Data | Putting it All Together

Reading Source Data

On the "read" or "source" side of any data project where you need to extract data from an application, one or more categories of the DataTools product line offers a method of source data connectivity, as follows:

Source Connection Ideas

Based on the information in the above table, consider each of these scenarios, and find the one that most closely matches the type of source connection that works best for your project.

• Direct Connection - Use the Pervasive DataTools Data DownLoader that provides a source-side adapter to connect directly to your application.
• Intermediate Connection - If there is no DataTools Data DownLoader that connects directly to your application, use one of the following methods:
  • Connect to Backend Database - Use the Data DownLoader that connects directly to your application's backend database to read the source data table or join multiple tables.
  • Parse Legacy Flat Files - Use the Data Parser to parse fixed text or legacy flat files into fields and records on the source side.
  • Connect to a CSV Text File - Export the data from your application to a Delimited ASCII text file. Use the Data DownLoader from CSV Text to read the source data file.
  • Extract Data from a Print File - Create a report in your application and print the report to a file (rather than to a printer). Use the Data Extractor to extract the useful data from the report file.

Back to Top

Writing Target Data

On the "write" or "target" side of any data project where you need to load data into an application, one or more categories of the DataTools product line offers a method of target connectivity, as follows:

Target Connection Ideas

Based on the information in the above table, consider each of these scenarios, and find the one that most closely matches the type of target connection that works for your data project.

• Direct Connection - Use the Pervasive DataTools Data UpLoader that provides a target-side adapter to connect directly to your application.
• Intermediate Connection - If there is no DataTools Data UpLoader that connects directly to your application, write the data using one of the following methods:
  • Connect to Backend Database - Use the Data UpLoader that connects directly to your application's backend database to write the target data to one or multiple tables.
  • Create a CSV Text File - Use the Data UpLoader to CSV Text to write the data to a target data file. Then import the data into the application.
  • Create a Load File - Use one of the Data Builders to write out a target data file in the exact load format required by the application. Then load the data into the application.

Back to Top

Putting it All Together

The huge variety of applications, databases, and file formats creates an endless combination of connection options. In the following section, we will try to describe these options in broad terms. In that way, you can determine which method of connecting to your source and/or target application works best for you, and which of the DataTools products you need.

Here are some examples of how one or more DataTools products can be used to solve your data challenges.

Direct Connections to Source and Target

If you are converting data between any of the directly-supported applications listed above in the Reading Source Data or Writing Target Data sections, simply purchase a subscription for the Data DownLoader from "your application" or the Data UpLoader to "your application" and connect to both applications using the supplied adapters, create the data mapping, and go!

Direct Connection to Source / Intermediate Connection to Target

If a Data Builder is available for your target application, purchase a subscription for that Data Builder. It will connect to your source application directly and will help you create application load files that "fit" your target application perfectly.

If a Data DownLoader is available for your source-side application, purchase a subscription for that Data DownLoader. Then use a target adapter, such as the Delimited ASCII adapter, in the Data DownLoader to write the data to a file format that can be imported into your target application.

Intermediate Connection to Source / Direct Connection to Target

The first step is to export the data out of the source application to an intermediate file format. Then, depending on the exact format of the exported data file, any one of several options are available for this combination, as follows:

Source File is a CSV Text File

If a Data UpLoader is available for your target application, purchase a subscription for that DataTool. Then use the Delimited ASCII source adapter in the Data UpLoader to read the data from the intermediate source file format. The Delimited ASCII adapter can read virtually any delimited text file, regardless of the record separators and field separators.

Source File is a Fixed Text File

Purchase a subscription for the Data Parser for Fixed Text. Use the Data Parser to parse the fixed text data into records and fields, then export the data from the Data Parser to a CSV text file format.

If a Data UpLoader is available for your target application, purchase a subscription for that DataTool. Then use the Delimited ASCII source adapter in the Data UpLoader to read the data from the CSV text file that was exported by the Data Parser.

Source File is a Report File

Purchase a subscription for the Data Extractor for Fixed Text. Use the Data Extractor to extract and assemble useful data into records and fields, then export the data from the Data Extractor to a CSV text file format.

If a Data UpLoader is available for your target application, purchase a subscription for that DataTool. Then use the Delimited ASCII source adapter in the Data UpLoader to read the data from the CSV text file that was exported by the Data Extractor.

Intermediate Connections to Source and Target

The first step is to export the data out of the source application to an intermediate file format. Depending on the exact format of the exported data file, any one of several options are available for this combination, as follows:

Source File is a CSV Text File

If a Data Builder is available for your target application, purchase a subscription for that DataTool. Then use the Delimited ASCII source adapter in the Data Builder to read the data from the intermediate source file format and map the data to the exact format to load into your target application.

If a Data Builder is NOT available for your target application, purchase a subscription for the Data UpLoader to CSV Text to read the data from the intermediate source file format and write the data to a CSV Text file that can be imported into your target application.

Source File is a Fixed Text File

Purchase a subscription for the Data Parser for Fixed Text. Use the Data Parser to parse the fixed text data into records and fields, then export the data from the Data Parser to a CSV text file format.

If a Data Builder is available for your target application, purchase a subscription for that DataTool. Then use the Delimited ASCII source adapter in the Data Builder to read the data from the CSV text file that was exported by the Data Parser and map the data to the exact format to load into your target application.

If a Data Builder is NOT available for your target application, purchase a subscription for the Data UpLoader to CSV Text to read the data from the CSV text file that was exported by the Data Parser, and map and manipulate the data to a CSV Text file that can be imported into your target application.

Source File is a Report File

Purchase a subscription for the Data Extractor for Fixed Text. Use the Data Extractor to extract and assemble useful data into records and fields, then export the data from the Data Extractor to a CSV text file format.

If a Data Builder is available for your target application, purchase a subscription for that DataTool. Then use the Delimited ASCII source adapter in the Data Builder to read the data from the CSV text file that was exported by the Data Extractor and map the data to the exact format to load into your target application.

If a Data Builder is NOT available for your target application, purchase a subscription for the Data UpLoader to CSV Text to read the data from the CSV text file that was exported by the Data Extractor, and map and manipulate the data to a CSV Text file that can be imported into your target application.

Back to Top

List of Applications

Here is a partial list of applications for which the DataTools can be used to import and export data.

• ACCPAC
• Act!
• Business Objects
• Capterra
• Clarity
• COGNOS
• Crystal
• CYMA
• DacEasy
• Dynamics Solomon
• E-Intelliprise
• Eloqua
• FishBowl
• Lexys
• Goldmine
• Hyperion
• IBS
• ICSoft
• IFS
• Intelisis
• Invaris
• IGMS
• JDA
• Jeeves
• Lexys
• LogicTools
• Macola
• made2manage
• Maximizer
• MBA
• MerchantPOS
• MicroBiz
• Microsiga
• Microsoft SBA
• MicroStrategy
• mPower
• MYOB
• mySAP
• Navigator
• Nexus
• Onyx
• Open Systems
• OpenMFG
• Oracle EBS
• Oracle eBusiness
• Oracle Financials
• Oracle PeopleSoft
• ORCA
• Orion
• Pacifica
• Peachtree
• PeopleSoft
• PFW
• Pivotal
• Platinum
• Plexis
• Plexus
• POSCentral
• Powyr
• ProcessPro
• Pronto
• Provision
• GAD
• QuickSell
• Ramco
• ReceiptCity
• Registware
• Retail Pro
• RetailSoftware
• RM6000
• Sage
• SalesBoom
• salesforce.com
• SAP
• SAP R3
• Scala
• SCM
• Sentai
• Siebel
• SKEP
• Skyway
• Smartops
• Softbrands
• Solomon
• Spectrum
• SysPro
• System21
• TCLogic
• TechniData
• TRAX
• TurboTrade
• UA
• VersaPOS
• Vigilant
• xPeria
• Zilliant

For a more complete list of applications - but certainly not all! - click here...

And of course, if you need assistance, please enter a brief description of your project - along with your question(s) - in one of our user forums. The Pervasive DataTools Team is always happy to help you determine which of our data tools will work for your data project.

Back to Top