Pervasive Data Profiler 4.2 - Readme
General Release - February 2008

Contents

Welcome to Data Profiler release 4.2. This document contains the most up-to-date information on the software and may supersede certain information in the product documentation. It contains the following sections:

What’s New in Data Profiler 4.2?

The following features are enhancements to previous versions of Data Profiler:

Environments Supported

This release has been tested on the following environments:

System
Supported Versions
Hardware Platform
Microsoft Windows
2003 Server R2 SP1
XP SP2
Vista Ultimate, Enterprise and Business
x86
Linux
Redhat, Suse (engine only)
x86

Windows System Requirements

The following resources are the minimum recommended:

These system requirements are the minimum for satisfactory operation. For higher performance, be certain that there is physical memory to meet the requirements of the local system and all applications.

A large, complex profile may consume so much memory that it will not execute. Where business processes permit, redesign of the profile may resolve this issue.

Data Profiler 4.2 is a 32-bit application. Using a 64-bit operating system and more than 4 GB RAM is not recommended and does not help performance.

Best practice is to execute large, complex processes only on machines that have sufficient memory to load all components of the process while supporting the operating system and all other open applications.

Note  Windows 95/98/ME/NT/2000 are not supported in this release. Technical support is not provided for these operating systems.

Frequently Asked Questions

This section presents frequently asked questions you may encounter.

How do I install a license file for Data Profiler?

I tried to open Data Profiler and received the error message:

“Unable to locate license file. The profiler engine may not operate properly until a valid license file is installed.”

To install a license

  1. Click License Manager (also available from Help > License Manager).
  2. Navigate to select your Data Profiler .slc file.

    3. The default location for the License directory is:

    \Program Files\Pervasive\Data Profiler 4.2

    Note  If you do not have a .slc license file, contact your sales representative to obtain one.

  3. Click OK.

    4. The Data Profiler application opens.

Known Issues

This section presents selected known issues for Data Profiler as of the release date. If you encounter an issue not found here, see Technical Support.

Issue
Problem / Description
Workaround
32594
Opening a large engine .log file returns a browser error.
  • Close any other open .log files to free memory.
  • Use a text editor to browse the file, such as WordPad.
32673
Data sets with a large number of fields display only part of the header in the data viewer. At times, the header disappears and reappears while scrolling.
Scroll more slowly through the fields.
32833
After moving the data source file for a profile and returning to the profile editor, the properties pane is blank.
None.
32857
You cannot create a connection to SQL Server using the JDBC Generic connector. After you download the sqljdbc_1.1 driver, copy the sqljdbc.jar into the InstallDir\Data Profiler 4.2\jre\lib\ext directory, type the parts for the JDBC Generic connection and click the Test Connection button, a JDBC Driver class error is returned.
None.
34110
Connecting to an ASCII Delimited file with 10 million records results in a browser failure with no records displayed.
None.
34200
A distinct values text file open in the data browser is locked even after project is closed.
None.
32694
If you choose the CP737 or CP775 encoding values in a data set, save the data set, and reopen it, Data Profiler stops responding.
None.
34355
Rounding of minimum and maximum values for Int and Long data types should be rounded to the nearest whole number.
None.
34647
When trying to browse an IBM DB7.2 database using ODBC 3.x, if the table has a mixed case name, an error is returned.
None.
34662
After you create a metric that generates a derived field and create another metric that uses the derived field as input, you delete the first metric. You have deleted the second metric’s input field, but no warning is displayed.
None.
34723
The 508 Government standards require Data Profiler to work with Narrator on Windows. Narrator announces the menu items properly, but also announces the separator in menu items.
None.
34728
When using the Summary Metrics metric, if you rename the metric names, the new metric names are not displayed in the graph.
None.
34756
When you are editing a data set, and the Browse Data link is selected, Narrator on Windows does not announce that the link is selected.
None.
34898
If you have source data sets that include both record sampling and macros, the join profile fails.
Do not select record sampling in join data sets that include macros.
34911
When you open a profile that uses a Pervasive PSQL connection and a join, leave the profile open in the editor, close the application and restart, the application stops responding right after the splash screen displays.
None.

Installing Data Profiler

Prerequisites

Obtain Installation and License Files

You are provided with an .msi installation file and an .slc license file. To obtain either of these files, contact your sales engineer or sales representative.

Important Notes for Version 4.0 Users

If you have version 4.0 installed, before you install version 4.2, follow the instructions in Exporting Version 4.0 Projects into a 4.2 Workspace. Then once you have exported the projects, you can install version 4.2. If you have already removed version 4.0, see Alternate Method for Importing Version 4.0 Projects.

You cannot have both Data Profiler versions 4.0 and 4.2 installed on the same computer. When you begin your installation of version 4.2, you are informed that version 4.0 will be removed. Only the application is removed, leaving all your project artifact files in their original locations. If you wish, back up the Workspace and License folders.

To install Data Profiler 4.2

  1. Double-click the Pervasive Data Profiler 4.2.msi file.
  2. Click Next.
  3. Accept the terms of the license agreement. Click Next.
  4. Accept the default installation folder or click Change to select an alternate location.
  5. Click Next.
  6. Choose from one of the two available installation configurations:
    • Data Profiler Analyst Workstation (default)
    • Data Profiler Engine
  7. Click Next.
  8. To begin the installation, click Install.

    9. Status messages appear during the installation, which may take several minutes.

  9. Click Finish to exit the setup.

See Also

What to Do Next

Known Issues

Exporting Version 4.0 Projects into a 4.2 Workspace

In Data Profiler 4.0, the workspace directory path was the following:

\Program Files\InstallDir\Data Profiler 4.2\workspace

But because of changes to accommodate Windows Vista users, the workspace directory path has changed to the following:

\Documents and Settings\All Users\Application Data\CompanyName\Data Profiler 4.2\workspace

Note  If you have already removed version 4.0, see Alternate Method for Importing Version 4.0 Projects.

To be able to see your 4.0 projects in the Project Navigator tree, do the following.

To export 4.0 projects and import into 4.2 workspace

  1. Open Data Profiler 4.0.
  2. Right-click anywhere in the Project Navigator and select Export.
  3. Expand the Data Profiler node, select Export Data Profiler project and click Next.
  4. Select individual projects to export or click Select All.
  5. At File, type the name of the .zip file.
  6. Click Finish.
  7. Open Data Profiler 4.2, right-click anywhere in the Project Navigator, and select Import.
  8. Expand the Data Profiler node, select Import Data Profiler project and click Next.

    9. Click Browse to navigate to the .zip file you created in step 6. The .zip file was written to the default installation directory:

    \Program Files\InstallDir\Data Profiler 4.2

  9. Select the file and click Open.
  10. Review the list of projects and click Finish.

    11. The imported projects are written to the Project Navigator tree. If any project contains errors, those errors are displayed in the Problems pane. For instance, if a data set is missing a part value, the resource and path are listed under Errors.

Alternate Method for Importing Version 4.0 Projects

If you have already have removed Data Profiler version 4.0, to avoid removing version 4.2 and reinstalling version 4.0, complete the following steps.

To import version 4.0 projects

  1. Using Windows Explorer, navigate to the workspace folder under C:\Program Files\InstallDir\Data Profiler 4.0.
  2. Create a .zip file containing the projects you wish to import into version 4.2. The .zip file must contain all project artifacts, including the following:
    • .project file
    • .dp.xml file
    • data set or connection files
    • script files
    • source files
  3. Open the .zip file to verify that all file paths start with project names.
  4. Open Data Profiler version 4.2, right-click anywhere in the Project Navigator, and select Import.
  5. Expand the Data Profiler node, select Import Data Profiler project and click Next.
  6. Click Browse to navigate to the .zip file you created in step 2.
  7. Select the file and click Open.
  8. Review the list of projects and click Finish.

    9. The imported projects are written to the Project Navigator tree. If any project contains errors, those errors are displayed in the Problems pane. For instance, if a data set is missing a part value, the resource and path are listed under Errors.

Removal Instructions

Technical Support Engineering may ask you to remove and reinstall Data Profiler. To do so in a Microsoft Windows environment, follow the steps in this section.

To remove the Data Profiler application

  1. Back up your Workspace and License folders.
  2. In the Control Panel, open Add/Remove Programs, select Pervasive Data Profiler 4.2, and remove it.
  3. Reinstall Data Profiler. For instructions, see Installing Data Profiler.

See Also

For instructions on applying a license file, see Frequently Asked Questions.

What to Do Next

Once you have successfully installed Pervasive Data Profiler, we strongly recommend you read the Data Profiler User’s Guide. Open the online help from your Windows Start menu or from the Help menu in the application.

Technical Support

Pervasive Software strives to ensure easy and successful product installation and operation.

If you encounter problems not covered in the user documentation, contact Technical Support Engineering.

Useful Links

Disclaimer

PERVASIVE SOFTWARE INC. LICENSES THE SOFTWARE AND DOCUMENTATION PRODUCT TO YOU OR YOUR COMPANY SOLELY ON AN "AS IS" BASIS AND SOLELY IN ACCORDANCE WITH THE TERMS AND CONDITIONS OF THE ACCOMPANYING LICENSE AGREEMENT.

PERVASIVE SOFTWARE INC. MAKES NO OTHER WARRANTIES WHATSOEVER, EITHER EXPRESS OR IMPLIED, REGARDING THE SOFTWARE OR THE CONTENT OF THE DOCUMENTATION; PERVASIVE SOFTWARE INC. HEREBY EXPRESSLY STATES AND YOU OR YOUR COMPANY ACKNOWLEDGES THAT PERVASIVE SOFTWARE INC. DOES NOT MAKE ANY WARRANTIES, INCLUDING, FOR EXAMPLE, WITH RESPECT TO MERCHANTABILITY, TITLE, OR FITNESS FOR ANY PARTICULAR PURPOSE OR ARISING FROM COURSE OF DEALING OR USAGE OF TRADE, AMONG OTHERS.

© Copyright 2008 Pervasive Software Inc.

All Rights Reserved

Pervasive Software Inc.
http://www.pervasive.com
12365 Riata Trace Pkwy, Bldg B
Austin, TX 78727 USA
Voice: (512) 231-6000
Fax: (512) 231-6010
Online Pervasive Contacts

*** END OF README ***