Please browse our site—but you must be a registered user to download files, purchase products, leave comments, or post in the forums. It's quick, easy and free to become a member of the Pervasive DataTools community.
Pervasive DataTools Screen Shots
These screen shots will give you a view into the main windows in each of the products. Click on any of these links to jump to that product's screen shots.
Launcher | UpLoaders | DownLoaders | Builders | Extractors | Parsers | Joiners | Investigators | Viewers
DataTools Launcher
The Pervasive DataTools Launcher is a convenient way to obtain new or missing license files from Pervasive, and to launch any of the DataTools for which you have downloaded a trial or purchased a subscription. The following are the basic windows in the Pervasive DataTools Launcher.
License File Web Service Login
)
The Launcher's Web Service Login window prompts you to enter the UserID and Password you used to purchase your DataTools subscription on the Pervasive DataTools web site. Each time you start the DataTools Launcher, it checks the server for new or missing license files.
License File Downloads
)
The License File Downloads window displays new or missing license files and lets you select the file(s) you want to download to your workstation.
Launch a DataTools Product
)
From the Launcher's list of license files, select the DataTools product you want to launch. The "Active Licenses" list provides useful information to help you know which subscriptions are active and which subscriptions are about to expire. The "Inactive Licenses" tab lets you see a history of your DataTools subscriptions.
Data UpLoaders
The following are the basic windows in the Pervasive DataTools UpLoaders.
Source Connection
)
On the UpLoader Source tab, you select any one of dozens of available connectors. Select the format that matches the format of the file/table type to which you want to connect and read the data.
Target Connection
)
On the UpLoader Target tab, you select the connector that matches the format of the file/table to which you want to map the data. For UpLoaders, the available target connections depend on the DataTools UpLoader to which you subscribe.
Internal Data Browsers (Source and Target)
)
The built-in Data Browsers allow you to view the contents of the source and target data file/table in tabular (row and column) format. This is a great way to verify that you are connected to the correct source file/table and that the Loader is reading the file correctly. It is also an easy way to verify that your target data is being written correctly...and without the need to exit the Loader or open another application.
Field Mapping
)
On the Map Fields tab, you may use a variety of techniques to create the schema of your target file/table and to control the exact format of the data that is written to your target. If the target file/table already exists, you may drag and drop, type, use the Mapping Wizard, or use the RIFL expression builder to map source fields to target fields.
RIFL Expression Builder
)
The Rapid Integration Flow Language (RIFL) includes functions, operators, statements, variables, object variables and error objects that allow you to transform the data as it is written to the target file/table, log verbose messages to the log file, and many other purposes. This powerful feature includes text, math, date/time, conversion, parsing, file, and flow control functions. And there is an Expression Wizard to help you write simple or complex transformation expressions.
Read about some of the special features in the Data Loaders.
Data DownLoaders
The following are the basic windows in the Pervasive DataTools DownLoaders.
Source Connection
)
On the DownLoader Source tab, you select the connector that matches the format of the file/table from which you want to read the data. For DownLoaders, the available source connections depend on the DataTools DownLoader to which you subscribe.
Target Connection
)
On the DownLoader Target tab, you select any one of dozens of available connectors. Select the format to which you want to map and write your data.
Internal Data Browsers (Source and Target)
The built-in Data Browsers allow you to view the contents of the source and target data file/table in tabular (row and column) format. This is a great way to verify that you are connected to the correct source file/table and that the Loader is reading the file correctly. It is also an easy way to verify that your target data is being written correctly...and without the need to exit the Loader or open another application.
Field Mapping
)
On the Map Fields tab, you may use a variety of techniques to create the schema of your target file/table and to control the exact format of the data that is written to your target. If the target file/table already exists, you may drag and drop, type, use the Mapping Wizard, or use the RIFL expression builder to map source fields to target fields.
RIFL Expression Builder
The Rapid Integration Flow Language (RIFL) includes functions, operators, statements, variables, object variables and error objects that allow you to transform the data as it is written to the target file/table, log verbose messages to the log file, and many other purposes. This powerful feature includes text, math, date/time, conversion, parsing, file, and flow control functions. And there is an Expression Wizard to help you write simple or complex transformation expressions.
Read about some of the special features in the Data Loaders.
Data Builders
The following are the basic windows in the Pervasive DataTools Builders.
Source Connection
)
On the Builder Source tab, you select any one of dozens of available connectors. Select the format that matches the format of the source file/table type to which you want to connect and read the data.
Target Connection
)
On the Builder Target tab, you select the connector that matches the format of the import file to which you want to map the data. For Builders, the available target connections and specific pre-built formats depend on the Data Builder to which you subscribe.
Internal Data Browsers (Source and Target)
)
The built-in Data Browsers allow you to view the contents of the source and target data file/table in tabular (row and column) format. This is a great way to verify that you are connected to the correct source file/table and that the Loader is reading the file correctly. It is also an easy way to verify that your target data is being written correctly...and without the need to exit the Data Builder or open another application.
Field Mapping
)
On the Map Fields tab, you may use a variety of techniques to map source fields to the pre-built schema of the target import file and to control the exact format of the data that is written to your target. You may drag and drop, type, use the Mapping Wizard, or use the RIFL expression builder to map source fields to target fields. Visual clues and tips help you know what to map...and how.
RIFL Expression Builder
The Rapid Integration Flow Language (RIFL) includes functions, operators, statements, variables, object variables and error objects that allow you to transform the data as it is written to the target file/table, log verbose messages to the log file, and many other purposes. This powerful feature includes text, math, date/time, conversion, parsing, file, and flow control functions. And there is an Expression Wizard to help you write simple or complex transformation expressions.
Read about some of the special features in the Data Builders.
Data Extractors
The following are the basic windows in the Pervasive DataTools Extractors.
Select Text File
)
The first step in the Data Extractor is to select a text or report file from which you want to extract useful data.
Define Line Styles
)
To define patterns of text within your file, hightlight a block of data, right click, and use the selections in the Line Style Definition window. These rules are used to identify matching lines of data throughout your text file.
Define Data Fields
)
Hightlight a block of data, right click, and use the selections in the Data Field Definition window to define patterns of text within your file. These rules are used to identify matching fields of data throughout your text file.
View the Extracted Data
)
The combination of Line and Field rules determine how the useful data will be extracted from the raw file. In the built-in Data Browser, the extracted data displays in tabular (row and column) format for easy viewing, and lets you verify the rules you created.
Export the Data
)
After verifying your extraction rules in the Extractor's browser window, you can save the rules for reuse and then export the extracted data to a CSV (comma separated) file format. The CSV file may be imported directly into your application, or you may use one of the DataTools Loaders to further clean and transform the data to fit into your application.
Read about some of the special features in the Data Extractors.
Data Parsers
The following are the basic windows in the Pervasive DataTools Parsers.
Source Connection
)
Select the connector that matches the format of the data file you want to parse into records and fields. For the Parsers, the available source connection depends on the Data Parser to which you subscribe.
Select Parsing Method
)
The Data Parser includes two methods of parsing your source data file - dictionary file support and a visual parser. Refer to the screen shots of each below, and read more details in the Data Parser online help.
Dictionary File Support
)
If you have access to a dictionary file that defines the schema of your source data file, select that type of dictionary file from the list. The Data Parser will use the definitions to auto-parse the data file into records and fields, and will unpack a wide variety of packed and binary data types.
Visual Parser
)
If you do not have access to a dictionary file, but know the structure of the data file, the visual parser allows you to manually parse the data file into records and fields. Where packed and binary data exist, you can select the correct data type for each field to unpack the data into a "human readable" format.
Internal Data Browsers (Source and Target)
)
The built-in Data Browsers allow you to view the contents of the unpacked source data file in tabular (row and column) format. This is a great way to verify that the Parser is reading the data file and field definitions correctly. It is also an easy way to verify that your target data is being written correctly...and without the need to exit the Data Parser or open another application.
Export Options
)
When you click the Export Data toolbar button, an export dialog will open where you can choose the export target connector type, filename, file location, target connector properties, and rules for record filtering.
Read about some of the special features in the Data Parsers.
Data Joiners
The following are the basic windows in the Pervasive DataTools Joiners.
Source1 Connection
)
The first Data Joiner tab is for specifying one of your two sources. Think of it as the left side of a join. Choose from dozens of available factory source connectors or create and save your own connections for reuse.
Source2 Connection
)
The second Data Joiner tab is for specifying one of your two sources. Think of it as the right side of a join. Choose from dozens of available factory source connectors or create and save your own connections for repeated reuse.
Join Settings
)
In the Join Settings tab, select the fields from each of your sources that you want to export. Then select the key field on which the Joiner will match records from both sources.
Export the Joined Data
)
When you click the Export Joined Data toolbar button, an export dialog will open where you can choose the export target connector type and file location, target connector properties, and rules for record filtering.
Data Browser (Sources and Target)
)
After connecting to either or both of your sources, you can view the data in a tabular (row and column) format. After choosing the join settings, you can view the joined data as it will appear in the export file. And after running the export, you can view the exported data and the log file...all in the same convenient browser.
Read about some of the special features in the Data Joiners.
Data Investigators
Coming Soon
Data Viewers
The following are the basic windows in the Pervasive DataTools Viewers.
Viewer Connectors
)
The Data Viewer allows you to connect to dozens of data file/table formats. Simply select the desired format from the list and enter the required connection information.
Viewer Browser
)
After you connect to your data file or table, the data browser window opens where you can view the data in tabular (row and column) format. This is a great way to view those data files for which you do not have access to the native application.
Read about some of the special features in the Data Viewers.
Copyright © 2007 Pervasive Software, Inc. All Rights Reserved.
All Pervasive brand and product names are trademarks or registered trademarks of Pervasive Software Inc. in the United States and other countries. All other marks are the property of their respective owners.
Your transaction secured by high-grade AES-256 encryption.
Quick Links
PDT.Blog
- 16 weeks 5 days ago
- 17 weeks 6 days ago
- 18 weeks 20 hours ago
- 18 weeks 4 days ago
