If you need to view data, parse data, extract data, load data, unload data, migrate data, convert data, transfer data, map data, cleanse data, transform data, and/or analyze data, Pervasive's data tools can help. Each of the following briefly describes what our DataTools can do for you and your data conversion projects.

UpLoaders | DownLoaders | Builders | Extractors | Parsers | Joiner | Viewers

Data UpLoaders

The Pervasive Data UpLoaders are the data tools to use to read and export data from virtually any source database, application, or data file format, and map and insert data directly into a specific target database, application, or file format. Data UpLoaders are available to convert data into virtually any SQL/DBMS database, desktop database, spreadsheet, application, or data file format. Read more...

Data DownLoaders

The Pervasive Data DownLoaders are the data tools to use to read or export data from a specific source database, application, or data file format, and load or insert data directly into virtually any target database, application, or data file format. Read more...

The Data Converters are in development...and we will publish information on them soon. Please check back!

The Data Investigators are in development, and we will publish information on them soon. Please check back!

Welcome! You're one of the industry opinion leaders with whom we want to share our excitement about the Pervasive DataTools™ launch.

The Need: Every data application on earth is incompatible at some level with every other application, and the challenge compounds daily with the proliferation of new applications and formats.

The Goal: To enable users to rapidly and economically...

• Build maps to migrate and transform data from and to various applications and data file formats
• Build report data extraction rules in a user interface, rather than write code
• Create data joins in a user interface, rather than requesting custom queries/reports from IT
• Create import files that ensure clean data uploads into popular Internet stores and other applications
• and much more...

The Innovation: Subscribe to the DataTools ONLY for the amount of time you need them. No need to purchase expensive perpetual licenses!

The Tools: Here are the categories/types of DataTools that solve the most common data challenges and are currently available for you to evaluate.

Pervasive DataTools^TM Data Loaders for Salesforce.com are powerful mapping tools for use in uploading data into or downloading data from Salesforce.com. The DataTools are a subset of components found in Pervasive’s award winning Integration suite of products.

Pervasive Software is a recognized leader in integration technology and has been a Salesforce.com partner since 2001. Pervasive DataTools leverage 20 years of leadership experience to deliver robust integration solutions allowing users to leverage critical business data into Salesforce.com.

Two Data Loaders are available for Salesforce.com...

UpLoader to Salesforce.com | DownLoader from Salesforce.com

Data UpLoader to Salesforce.com

The Data UpLoader to Salesforce.com allows developers, data analysts and IT users to quickly and easily Extract, Transform and Load (ETL) data from dozens of databases and file format sources into Salesforce.com. The Data UpLoader to Salesforce.com utilizes the core component of the Pervasive deployment suite: Map Designer^TM. Users can connect, view, transform, and insert data directly Salesforce.com entities. Prebuilt functions can be used to parse, concatenate, aggregate data from dozens of sources and map clean data directly into Salesforce.com via the Salesforce API.

Try or Buy the Data UpLoader Now

The following are the basic screens in the Data UpLoader to Salesforce.com.

Data DownLoaders Overview

The Pervasive Data DownLoaders are the tools to use for reading source data directly from a specific source application or file format, and writing the data to dozens of available targets. The Data DownLoaders support data extraction from a variety of data sources - including databases, text files, spreadsheets, application exports, etc. - all via native connectivity. The graphical tool gives you the power to completely view all the source data in its native format, so you can see the contents of the source data before mapping it to your target.

And that is only the beginning. A world class source-to-target drag-n-drop data mapping UI is available (with online video training) to perform any needed data re-structuring before it is written to the target. A full-blown transformation capability is in the same mapping UI, with easy wizards for record filtering and editing, reformatting, cleansing and manipulation of the data on-the-fly so that only clean data is loaded into your target!

SQL Databases | Applications | File Formats | ODBC

SQL Databases

For RDBMS sources, the Data DownLoader supports reading data from a single table, a database view, or joining multiple tables via SQL statements to read exactly the data you need. Many features are available (in fact, too many to mention here, give it a try!): e.g., single-step visual debugging of transformations, detailed logging, before and after views of the data...and more!

The Pervasive Data Joiner is the tool for joining data from heterogeneous data sources such as database tables, spreadsheets, and data files - and without the need to know/learn SQL scripting and without writing code!

Source Side

Some data can be easily read by humans in its native application's user interface. But how often do you need to access data that resides in multiple files or tables or even in different applications? And how often do you need to submit a request to your IT department and ask for a custom query or report? Much of the world's data is stored in databases and files that cannot be accessed by most users, and usually requires a custom script...thus requiring the services of a programmer. Pervasive Data Joiner is the solution!

The Pervasive Data Joiner enables virtually anyone to join data from multiple tables and files via a graphical interface and menu options. Simply connect to both data sources, select the key field, and select the columns of data you want to join. Then, using the built-in data viewer, verify that your data is being pulled as needed.

Target Side

Once your data displays correctly in the tabular row-and-column format, export the data to a delimited text -- including unicode -- file that can be imported into most applications.

Need Transformation?

If futher data manipulation, record filtering, or mapping is required, use one of the other Pervasive DataTools to map and manipulate the exported data into any of dozens of target databases, applications, or file formats.

Click here to download a trial or to purchase the Data Joiner now.

How many times has someone sent you a data file that you cannot open because you don't own the application from which the file originated?

The Pervasive Data Viewers are the solution to viewing the contents of data files without the need to own (or purchase!) an application for every file format you receive from your customers. Simply select the connector name from an extensive list -- dozens! -- of choices, enter the necessary connection options, and the data displays in a tabular (row and column) format in the Viewer's user interface. You can scroll through all the records, search for specific data content, and even print or export the data with the Data Viewer Plus.

The Data Viewer is a great way to determine if one of our other DataTools products can read your data files and help you with your data projects!

Click here to see how the Data Viewer works!

We offer two Data Viewers...

• Data Viewer
• Data Viewer Plus

Pervasive Data Extractors are the tools that extract and parse data from unstructured text and report files and convert the data to a structured data file format that can be imported into virtually any application, spreadsheet, or database.

The Data Extractor enables you to: extract data from log files, extract data from report files, extract data from HTML files, extract data from XML files, extract data from print files, extract data from text reports, extract data from ASCII or EBCDIC text files, extract data from data reports, extract data from news retrieval, financial, or real estate downloads. The Data Extractor supports virtually any report architecture as long as there are rules.

Here are just a few of the features of the Data Extractor: auto-parse tagged data fields, auto-parse columnar data, auto-parse mailing labels, support for large data fields and records, support for floating headers and floating footers, support for multi-line data fields, support for multi-record type reports, and much more!

The Problem

Reports are easily read by humans, but not by databases or data management systems. Much of the world's data is tied up in reports and unstructured text formats that cannot be consumed by most applications. The extraction of useful data from report files and print files usually requires a custom script...thus requiring the services of a programmer. Pervasive Data Extractors are the solution!

The Solution

The Pervasive Data Extractors enable virtually anyone to create data extraction rules via a graphical interface and menu options. Simply define rules that identify the various lines and fields of useful data. Then, using the built-in rule de-bugger and data viewer, verify that the rules are working as needed.

The Pervasive Data Builders are the tools to use for building perfectly-structured files for importing into a specific target application -- including online/hosted stores.

Source Side

The Data Builders support reading data from literally dozens of Sources - including databases, text files, spreadsheets, flat files, application exports, etc. The graphical tool gives you the power to completely view all the Source data in its native format, so you can see exactly what needs to be mapped to your Target. Filtering and sorting can be used to constrain the Source data sets.

Target & Mapping

A world class Source-to-Target drag-n-drop mapping UI is available to perform any needed re-structuring of fields and columns to get them into the exact Target format...that is pre-built for you!

A full-blown transformation capability is in the same mapping UI, with easy wizards for editing, reformatting, cleansing and otherwise manipulating the data contents on-the-fly so that only clean data is imported into your target application!

Many features are available. For example, single-step visual debugging of transformations, detailed logging, before and after views of the data, and the ability to save your maps for reuse.

Supported Target Formats

The Pervasive Data Builders include the following target import file formats: