Skip to main content

Installing Experian Pandora

On this page you can find detailed instructions on how to install and set up Experian Pandora for first time use, or to upgrade to the latest version.

Overview

New install

Experian Pandora can be installed in the following scenarios:

Upgrade

You can upgrade your previous version of Experian Pandora to the latest version in one of the following ways:

If you want to connect to the Experian Pandora server using ODBC, you will need to install ODBC drivers. For detailed information on how to do this, see the ODBC Installation and User Help document that is installed alongside your Experian Pandora program files.

Installing on a single computer

To install Experian Pandora on a single machine, follow these steps.

1. Download the installer

You will have been sent a link to enable you to download Experian Pandora. Follow the link in the email and download the latest setup executable.

The site is password protected and you should have received authentication details from your local Technical support representative via email. Note that these details are different to the login credentials you have been given to login to the Experian Pandora client.

If you haven't received a download link or don't know your authentication details, contact your local Technical support team.

2. Run the installer

  1. Navigate to the folder in which you downloaded the installer.
  2. Double-click the .exe file and run through the installer.
  3. On the Installation Type dialog, select whether you want the product to be available for everyone on the machine, or just for your user profile. The product is automatically installed to 1 of 2 default locations:
    Only Me (Username)
    • application: C:\Users\Username\AppData\Local\Programs\Experian
    • repository: C:\pandora.
    Everybody (all users):
    • application: C:\Program Files\Experian
    • repository: C:\pandora.
  4. On the Choose Setup Type dialog, select Typical
  5. Click Finish to complete installation wizard. Before you can open Experian Pandora, you will need to start the service.

3. Start the service

  1. Navigate to Windows Services. From the Start menu, in the Search programs and files box, type Services and press Enter.
  2. Locate Experian Pandora Database Server <version><operating system>.
  3. Right-click, and select Start.

4. Open Experian Pandora

  1. From the Start menu, click Experian Pandora Client <version>.
  2. In the pop up dialog, enter your credentials and click Login. The default credentials are:

    username: administrator
    password: administrator

    We recommend that you change the default credentials immediately after initial installation (in the Experian Pandora client, right-click Home > User > Change password...). For other users, we recommend that the administrator logs in and either changes the passwords before handing out login details or deletes them and creates their own set of users. The other default users (other than admin) are mainly for getting started or demonstrations.

    Got an error message? Click here to troubleshoot. 

  3. If you don't already have a license key, you will need to request one when you first log into Experian Pandora. On the License Key screen, clicking the Email button will populate an email with the information. Send the email, and when you receive your license key, paste it here.

You're all set! To get started on Experian Pandora, view the Quick start guide for an overview of the Experian Pandora workflow.

 

Installing as a client-server

To install Experian Pandora with multiple clients connecting to a single machine, follow these steps:

  1. View environment recommendations before you start the installation process.
  2. Carefully read through our hardware recommendations to determine the correct environment for your set-up type and to get the optimal performance out of your product.
  3. Install the Experian Pandora server on Windows or Unix/Linux. You can also optionally install the Experian Pandora client on this machine.
  4. Install Experian Pandora client(s) on the target machines.

Environment recommendations

The Experian Pandora client can be installed on both 32-bit and 64-bit Windows operating systems. The server must be installed on a 64-bit OS, on either Windows or Unix\Linux.

Certain Ports are used for various functions in Experian Pandora which will require rules to allow them through firewalls should they be needed; these are interchangeable but the defaults are below;

  • 7700 – Client/Server Communication port.
  • 7800 – ODBC Communication Port
  • 7900 – REST Web Server

Ideally for best performance, the database directory should be located on its own drive, separate from the OS. By default the database is on the same drive as the product files (C:/Pandora in Windows, /Pandora in Unix/Linux). For instructions on how to change the database location in Windows, see here and in Unix/Linux, see here.

The amount of disk space required will vary depending on the type and frequency of the data you will load. For guidelines, please see the Hardware recommendations guide or contact your local Technical support team.

Installing Experian Pandora server on Windows

To install the Experian Pandora server on a Windows machine, follow these instructions.

Recommendations and pre-requisites

Before starting the installation, it is important to familiarise yourself with the following:

1. Download the installer

You will have been sent a link to enable you to download Experian Pandora. Follow the link in the email and download the latest setup executable.

The site is password protected and you should have received authentication details from your local Technical support representative via email. Note that these details are different to the login credentials you have been given to login to the Experian Pandora client.

If you haven't received a download link or don't know your authentication details, contact your local Technical support team.

2. Run the installer

  1. Navigate to the folder in which you downloaded the installer.
  2. Double-click the .exe file and run through the installer.
  3. On the Installation Type dialog, select whether you want the product to be available for everyone on the machine, or just for your user profile. 
  4. On the Choose Setup Type dialog, select Custom. You have the options to:
    • install the Client
    • install the server as a Windows service (default) or as a Server (a standalone executable). In most cases we recommend installing the server as a Windows service, however you can install the service as a standalone program if required.
    • modify the application's installation location via the Browse button.

    The cross icon shows that the component will not be installed.

  5. Click Finish to complete installation wizard. You will now need to start the server.

3. Start the server 

Starting the Windows Service for the first time

If the Server is installed as a Windows Service, it will start and stop automatically. However this service will need to be started manually after initial installation. To start the service:

  1. Navigate to Windows Services. From the Start menu, in the Search programs and files box, type Services and press Enter.
  2. Locate Experian Pandora Database Server <version><operating system>.
  3. Right-click, and select Start.

The ‘Startup Type’ should have one of the following values:

To have the service start:Set this value
When the computer is restarted Automatic

When an explicit user action starts the service

Manual
Starting the standalone Server

The Experian Pandora server runs as a normal executable. To run the server as a standalone, from the Start menu, locate the program group for the Experian Pandora. Click Pandora Database Server <version number><operating system> to execute it. 

Virus Checkers

We strongly recommend that you ensure that any Anti-Virus software has exceptions to avoid scanning the directories containing the Experian Pandora repository (by default this is C:\Pandora), and any system sweeps are scheduled to run outside of periods where data loading will occur. This is to avoid any performance drops that might happen during critical operations.

4. Configure server properties – server.properties file

The server.properties file is installed along your Experian Pandora program files. It contains a wide range of configuration parameters that can be set, for example:

Modifying your database location using the server.properties file

The server.properties file on the server can contain a wide range of configuration parameters that can be set. There are some additional tuning parameters that are not documented and should not be set without advice from your support representative.

The following settings may be required if you wish to configure the directories used to store the Experian Pandora database before the server is first started. Changing these settings allows you to move, for example, the root path for the database, or to move the Temp directory to a different physical drive to the rest of the database.

Note: The file itself is blank by default, it only updates automatically when defaults are changed in the GUI.

Further settings can be customised through the user interface by navigating to Settings > Server Settings > Storage.

PropertyDefault valueDescription
DirName.ROOT C:\Pandora The root database directory
DirName.DATA C:\Pandora\data The root variable data file directory
DirName.INDEX C:\Pandora\data\index Directory for semi-permanent indexes
DirName.TABLE C:\Pandora\data\table Directory for tables (one sub-directory per table)
DirName.TEMP C:\Pandora\data\temp Directory for temporary files
DirName.EXPORT C:\Pandora\data\export Directory for exported tables
Changing the server port number

The default port number used by the Experian Pandora client is 7700. Should you wish to change this, the line to look at in the server.properties file is:  

                Server.port=7700

Note: Experian are not responsible for making port changes to your local network configuration, it is recommended to discuss any changes of this nature with your IT department.

Changing the location of the server.properties file

You can define a system-wide location for server.properties, which overrides the server.properties file you have in the default location (i.e. the server install directory). You may want to do this to avoid needing to copy the server.properties file to a new Experian Pandora installation directory after upgrade.

To do this in Windows, create a new Environment Variable called P_SERVER_PROPERTIES_FILE, and set the value as the full path to the server.properties file.

Java virtual machine settings

When setting up the Experian Pandora server, as much RAM as possible should be made available on the system. It is not necessary to dedicate all available memory to the Experian Pandora application, as there is a benefit to leaving memory for the OS file cache. This is something that can be adjusted at a later time based on resource needs or performance requirements.

These settings can be modified on Windows by editing the corresponding .ini file in the Experian Pandora installation directory (e.g. Experian Pandora service 64bit.ini).or on Unix/Linux in the installation directory under …/etc/<PLATFORM_NAME> in the corresponding files located there (e.g. pserver).

-Xmx<value>

This is the maximum amount of memory to be used. This is a loose limit as some memory will be allocated directly from the operating system, and, in general, should be set to around 75% of available system memory.

Default value: -Xms70:1000:32000P (70% of System memory between 1GB and 32GB system memory)

Example: to specify a fixed 24GB for the application: -Xms24g

-Xms<nnnnM>

This is the initial amount of memory to use upon start up. For the best performance this should be the same as the Xmx setting to avoid fragmentation of memory.

Default value: -Xms70:1000:32000P

Note: Xmx and Xms can take a memory argument in either gigabytes (g) or megabytes(m) – so 1g or 1024m are the same.

-XX:ParallelGCThreads=n
-XX:ConcGCThreads=n

These are the number of threads used for garbage collection (background de-allocation of server memory) and should be set to half the number of available processor cores on the machine.

Default values:

-XX:ParallelGCThreads=2

-XX:ConcGCThreads=2

6. Connect Experian Pandora client(s) to the server

If your Experian Pandora client(s) are already installed, follow these steps to connect them to the server, otherwise follow the instructions to install the client(s) on the target machine(s).

On the machine where the client is installed:

  1. From the Start menu, click Experian Pandora Client <version>.
  2. In the pop up dialog, enter the server address and port number, your credentials and click Login. The default credentials are:

    username: administrator
    password: administrator

    We recommend that you change the default credentials immediately after initial installation (in the Experian Pandora client, right-click Home > User Change password...). For other users, we recommend that the administrator logs in and either changes the passwords before handing out login details or deletes them and creates their own set of users. The other default users (other than admin) are mainly for getting started or demonstrations.

    Got an error message? Click here to troubleshoot. 

  3. If you already have a licence key, you will be able to connect to the server automatically. Otherwise, you will be presented with the License Key screen, and you will need to request a license key. Click the Email button to populate an email with the information. Send the email, and when you receive your license key, paste it here.

You're all set! To get started on Experian Pandora, view the Quick start guide for an overview of the Experian Pandora workflow.

 

Installing Experian Pandora server on Unix/Linux

The downloaded tarball is multi-platform, so the same installation works on all the supported versions of Unix/Linux. Experian Pandora will work on all OS versions that themselves support Java 1.8. We recommend Oracle JDK but also support OpenJDK.

To install the Experian Pandora server on Unix or Linux machine, follow these instructions.

Installation Pre-requisites

The following pre-requisites are in addition to the space required for data storage.

  • 64bit version of the Unix/Linux operating system
  • The latest version of 64bit Java 1.8 JDK must be installed.
  • Dedicated Experian Pandora user (default is pandora) with full access to the product and database directories
  • At least a base data directory for the Experian Pandora database (default is /pandora/data/ note: NOT /home/pandora/data/)
  • The server and the three required ports (default 7700, 7800 7900) should be made available to all client machines through all intermediate networks and firewalls.
  • User limits for the Experian Pandora user set to unlimited for each resource.
    • You can view your system’s limits by typing ulimit -a at the command shell.
    • It is critical that the application can open enough files simultaneously. Ensure this setting is set close to the operating system’s limit. For example, for RHEL/Centos set the hard limit to around 64000: When logged in as the Experian Pandora user ulimit -Hn should give the result 64000
    • Root access is not required for the installation once the pre-requisites are in place and the installation is completed.

Unix/Linux File System Recommendations

For the data storage directories:

  1. All partitions must use a block-size no smaller than 4096 bytes. This is the default for most Linux/Unix file systems.
  2. Disable file system journaling or use a non-journaling file system. This will boost performance and is highly recommended. This can be created by running a command such as (consult your system administrator first):
    sudo mke2fs -t ext4 -b 4096 -O ^has_journal /dev/xxx
  3. Disable the last accessed time processing (e.g. use the noatime,nodiratime mount options). This will improve the performance of the application since Experian Pandora reads/writes a lot of small chunks of data. This option can be modified at any time after the operating system has been installed.
  4. Access control lists are not required.
  5. Set file systems to write-back mode. This will provide a small performance boost, but exposes you to data loss in the event of power failure etc. Only recommended for benchmarking.

1. Download the tar.gz file

You will have been sent a link to enable you to download Experian Pandora. Follow the link in the email and download the latest tarball file.

The site is password protected and you should have received authentication details from your local Technical support representative via email. Note that these details are different to the login credentials you have been given to login to the Experian Pandora client.

If you haven't received a download link or don't know your authentication details, contact your local Technical support team.

2. Deploy the server

  1. Login in as the Experian Pandora user (default is pandora).
  2. Copy the tar file to the home directory of the Experian Pandora user and un-tar the distribution:
    tar –xvzf pandora_tar_file.tar.gz

    This will create a new directory, for the user pandora this is /home/pandora/pandora<version>.

  3. Add the install_directory>/bin to the $PATH environment variable:
    export PATH=$PATH:/home/pandora/pandora<version>/bin

    This sets the variable for the session. How to make this as a persistent change is dependent on your operating system.

3. Start the server

To start the server with default settings, run the following command:

./pserver start

4. (optional) Advanced configuration

If you're happy with the default settings, you can skip this section.

You can configure the following:

  • The pserver execution script 
    is a multi-platform execution script that controls how the server runs. You would use this to change the default settings. It is located in the Experian Pandora installation folder under /bin/pserver.
  • System env variables 
    The file is located in the Experian Pandora installation folder under /etc/env.
  • The Server .properties file 
    is the main configuration file for the Experian Pandora server that controls the server properties, such as database location and port number. It is located in the Experian Pandora root installation directory.
  • Java virtual machine parameters
    control JVM settings, such as memory allocation. /etc/pserver

For information about any configuration files not documented here, log into the Customer Hub and search for "Experian Pandora advanced Unix/Linux configuration settings".

pserver file

The multi-platform execution script pserver accepts a number of parameters and variables:

ArgumentDescription

?

Lists all available parameters for the script.

execute

Executes a beanshell script to run against the server. Arguments can be supplied to specify the hostname for the server, username for the Experian Pandora user, password, port number as environment variables (beginning with PS_SCR_). These have preset defaults. The script is supplied on the command line, but if not supplied then execution is taken from standard input (until CTRL+D is pressed)

Any additional arguments supplied are passed directly to the executed script.

initialise

Initialises the database. This removes all data but retains metadata such as users, user roles etc.

java_version

Outputs the path to Java and the version installed on the system

logfile

Returns the name of the current logfile for Experian Pandora. If the server is not currently running it returns the expected logfile name should the server be started now, otherwise it returns the current logfile.

patch

Applies a patch to the installation. This expects a single parameter, which is the name of the patch tar file.

paths

Returns a list of paths in use by Experian Pandora. These are named the same as the directories in the Storage drilldown in the application, with the prefix PSDIR_ added at the front. These are useful for invoking backup scripts and knowing the location of various Experian Pandora directories to be backed up.

relationships

Starts the Experian Pandora server in relationship rebuild mode.

restart

Restarts the Experian Pandora server, shutting down a running instance if necessary.

start

Starts the Experian Pandora server if it is not currently running.

status

Returns the status of the Experian Pandora server with respect to whether it is running or not.

stop

Stops the Experian Pandora server if it is running.

taillog

Follows the current log file (tail –f) for the Experian Pandora server.

viewlog

Views the current log file using the viewer defined by the variable PS_VIEWER which defaults to more.

In addition to the parameters, the pserver script has the following variables:

VariableTypeDefaultDescription

PS_PRODUCT

Variable

automatic

The name of the product used in various announcing text in the script

PS_SCR_ENCR

Variable

false

Denotes if the script execution password is encrypted (true) or in the clear (false)

PS_SCR_HOST

Variable

localhost

The server host to connect to when executing a script

PS_SCR_PORT

Variable

7700

The port for the server host to connect to when executing a script

PS_SCR_PWD

Variable

administrator

The application username to use when executing a script

PS_SCR_USER

Variable

administrator

The application password to use when executing a script

PS_SYNC

Variable

 

If set to true then the pserver scripts operates synchronously and outputs to standard output. This is useful when the server refuses to start as you can see instantly the reasons why. Do not use this setting for normal operation.

PS_TAG

Variable

PSERVER

Used to identify a running java process that is the server. Change this if it conflicts with other running processes.

PS_TEMP

Variable

/tmp

Temporary files used by the scripts

PS_USER

Variable

automatic

The user executing the application, defaulted to the user who executed the pserver script (or any of its links)

PS_VERSION

Variable

automatic

The current product version

PS_VIEWER

Variable

more

The viewer to use when viewing the log

System Environment variables

The default user and install directory can be overridden with environment variables. By default, the pserver script takes the home directory of the current user that executes the script to work out the install directory and executing user. These can be overridden prior to execution. Other variables listed below can be set in the etc/env (or etc/environment) file.

VariableTypeDefaultDescription

PATH

Variable

/home/ [Category] /bin

/install_directory/bin needs to be added to the $PATH

e.g. PATH=$PATH:/home/ [Category] / [Category] [Status]/bin

PS_HOME

Variable

/home/ [Category]

The installation directory for the server, automatically determined as the home directory of the executing user

PS_GROUP

Variable

automatic

Defaults to the effective group id of the executing user

Server.properties file

The server.properties file on the server in the installation directory can contain a wide range of configuration parameters that can be set. There are some additional tuning parameters that are not documented and should not be set without advice from your support representative.

The following settings may be required if you wish to configure the directories used to store the Experian Pandora database before the server is first started. Changing these settings allows you to move, for example, the root path for the database, or to move the Temp directory to a different physical drive to the rest of the database.

Note: This file itself is blank by default, it only updates automatically when defaults are changed in the Experian Pandora client.

PropertyDefault valueDescription
DirName.ROOT /pandora The root database directory
DirName.DATA /pandora/data The root variable data file directory
DirName.INDEX /pandora/data/index Directory for semi-permanent indexes
DirName.TABLE /pandora/data/table Directory for tables (one sub-directory per table)
DirName.TEMP /pandora/data/temp Directory for temporary files
DirName.EXPORT /pandora/data/export Directory for exported tables
Changing the server port number

The default port number used by the Experian Pandora client is 7700. Should you wish to change this, the line to look at in the server.properties file is:  

                Server.port=7700

Note: Experian are not responsible for making port changes to your local network configuration, it is recommended to discuss any changes of this nature with your IT department.

Java virtual machine settings

When setting up the Experian Pandora server, as much RAM as possible should be made available on the system. It is not necessary to dedicate all available memory to the Experian Pandora application, as there is a benefit to leaving memory for the OS file cache. This is something that can be adjusted at a later time based on resource needs or performance requirements.

These settings can be modified on Windows by editing the corresponding .ini file in the Experian Pandora installation directory (e.g. Experian Pandora service 64bit.ini).or on Unix/Linux in the installation directory under …/etc/<PLATFORM_NAME> in the corresponding files located there (e.g. pserver).

-Xmx<value>

This is the maximum amount of memory to be used. This is a loose limit as some memory will be allocated directly from the operating system, and, in general, should be set to around 75% of available system memory.

Default value: -Xms70:1000:32000P (70% of System memory between 1GB and 32GB system memory)

Example: to specify a fixed 24GB for the application: -Xms24g

-Xms<nnnnM>

This is the initial amount of memory to use upon start up. For the best performance this should be the same as the Xmx setting to avoid fragmentation of memory.

Default value: -Xms70:1000:32000P

Note: Xmx and Xms can take a memory argument in either gigabytes (g) or megabytes(m) – so 1g or 1024m are the same.

-XX:ParallelGCThreads=n
-XX:ConcGCThreads=n

These are the number of threads used for garbage collection (background de-allocation of server memory) and should be set to half the number of available processor cores on the machine.

Default values:

-XX:ParallelGCThreads=2

-XX:ConcGCThreads=2

5. Connect client(s) to the server

If your Experian Pandora client(s) are already installed, follow these steps to connect them to the server, otherwise follow the instructions to install the client(s) on the target machine(s).

On the machine where the client is installed:

  1. From the Start menu, click Experian Pandora Client <version>.
  2. In the pop up dialog, enter the server address and port number, your credentials and click Login. The default credentials are:

    username: administrator
    password: administrator

    We recommend that you change the default credentials immediately after initial installation (in the Experian Pandora client, right-click Home > User Change password...). For other users, we recommend that the administrator logs in and either changes the passwords before handing out login details or deletes them and creates their own set of users. The other default users (other than admin) are mainly for getting started or demonstrations.

    Got an error message? Click here to troubleshoot. 

  3. If you already have a licence key, you will be able to connect to the server automatically. Otherwise, you will be presented with the License Key screen, and you will need to request a license key. Click the Email button to populate an email with the information. Send the email, and when you receive your license key, paste it here.

You're all set! To get started on Experian Pandora, view the Quick start guide for an overview of the Experian Pandora workflow.

 

Install Experian Pandora client only

To install the Experian Pandora client to connect to a remote server, follow these steps.

1. Run the installer

  1. Navigate to the folder in which you downloaded the installer.
  2. Double-click the .exe file and run through the installer.
  3. On the Installation Type dialog, select whether you want the product to be available for everyone on the machine, or just for your user profile. 
  4. On the Choose Setup Type dialog, select Custom.
  5. Select Client only. 
  6. Click Finish to complete installation wizard. You will now need to connect to the server.

2. Open the Experian Pandora client to connect the client to the server

  1. From the Start menu, click Experian Pandora Client <version>.
  2. In the pop up dialog, enter the server address and port number, your credentials and click Login. The default credentials are:

    username: administrator
    password: administrator

    We recommend that you change the default credentials immediately after initial installation (in the Experian Pandora client, right-click Home > User Change password...). For other users, we recommend that the administrator logs in and either changes the passwords before handing out login details or deletes them and creates their own set of users. The other default users (other than admin) are mainly for getting started or demonstrations.

    Got an error message? Click here to troubleshoot. 

  3. If you already have a licence key, you will be able to connect to the server automatically. Otherwise, you will be presented with the License Key screen, and you will need to request a license key. Click the Email button to populate an email with the information. Send the email, and when you receive your license key, paste it here.

Client SSL configuration

The server ships with a built-in self-signed SSL certificate that is used by the Web Server and server-client communications. An alternative SSL certificate can be installed by uploading the Key file and Certificate file through the client as described in the "Secure communications" section of the user manual.

In order to connect to the server after the certificate update, this certificate (and any parent certificates in the chain) must have been loaded into the default TrustStore for the client application. The following example illustrates how to import certificates into the TrustStore for the Experian Pandora client.

This example assumes that

  • The Experian Pandora client may be found in C:\Program Files\Experian\Pandora <version>\ and refers to this directory as %INSTALL_ROOT%
  • The client machine has a 64-bit architecture
  • There is a JDK installed on the client machine containing keytool.exe and the JDK/bin directory is defined in %PATH%
  • The server certificate file is a PEM encoded file in C:\Temp\MyServerCertificate.crt
  • The file %INSTALL_ROOT%\java64\jre\lib\security\cacerts uses a store password “changeit”
  1. In a command window running as Admin change directory to

    %INSTALL_ROOT%\java64\jre\lib\security
  2. Type:

    >keytool –keystore cacerts –importcert –alias MyServerSSLCertificate –file c:\Temp\MyServerCertificate.crt

If you are not running as Administrator, you will see an error message saying “access denied”.

Alternatively, you may load the certificate into a separate keystore and specify it on the Experian Pandora client command line as:

-Djavax.net.ssl.trustStore=c:\temp\keystore.jks --Djavax.net.ssl.trustStorePassword=xyz

Note that you should also load this certificate into your browser’s TrustStore if you use the secure REST API.

Experian Pandora Free data profiler

Experian Pandora Free Data Profiler comes with limited functionality and requires that the client and server are installed on a single computer.

To install Free Data Profiler, follow these steps:

1. Download the installer

Sign up to Experian Pandora Free Data Profiler to download the installer.

2. Run the installer

  1. Navigate to the folder in which you downloaded the installer.
  2. Double-click the .exe file and run through the installer.
  3. On the Installation Type dialog, select whether you want the product to be available for everyone on the machine, or just for your user profile. The product is automatically installed to 1 of 2 default locations:
    Only Me (Username)
    • application: C:\Users\Username\AppData\Local\Programs\Experian
    • repository: C:\pandora.
    Everybody (all users):
    • application: C:\Program Files\Experian
    • repository: C:\pandora.
  4. On the Choose Setup Type dialog, select Typical
  5. Click Finish to complete installation wizard. Before you can open Experian Pandora, you will need to start the service.

3. Start the service

  1. Navigate to Windows Services. From the Start menu, in the Search programs and files box, type Services and press Enter.
  2. Locate Experian Pandora Database Server <version><operating system>.
  3. Right-click, and select Start.

4. Open Experian Pandora

  1. From the Start menu, click Experian Pandora Client <version>.
  2. In the pop up dialog, enter your credentials and click Login. The default credentials are:

    username: administrator
    password: administrator

    We recommend that you change the default credentials immediately after initial installation (in the Experian Pandora client, right-click Home > User > Change password...). For other users, we recommend that the administrator logs in and either changes the passwords before handing out login details or deletes them and creates their own set of users. The other default users (other than admin) are mainly for getting started or demonstrations.

    Got an error message? Click here to troubleshoot. 

  3. If you don't already have a license key, you will need to request one when you first log into Experian Pandora. On the License Key screen, clicking the Email button will populate an email with the information. Send the email, and when you receive your license key, paste it here.

You're all set! To get started on Experian Pandora, view the Quick start guide for an overview of the Experian Pandora workflow.

 

Upgrading from a previous version

Depending on the type of release you are upgrading your existing version of Experian Pandora to, follow the instructions here:

Upgrading using an executable

1. Back up the Experian Pandora database

You should take a backup of your database before upgrading or patching to a newer version of Experian Pandora. Whilst there shouldn’t be issues with updating the database to a new version of Experian Pandora, backups should be taken.

Windows

To take a backup of your database on Windows, follow these steps:

  1. Before shutting down the service, make sure that no load or validation jobs are being carried out.
  2. Ensure that the Experian Pandora service is fully stopped. This can be done by setting the service startup type to ‘Disabled’ in services.msc. Alternatively, stop the Experian Pandora standalone .exe. [how to do this?]
  3. Locate and copy the Experian Pandora database directory and all sub-folders. By default, the database is in: C:\Pandora. If Experian Pandora is installed in a different location to the default, you can find where it is by either checking the Storage server settings within the Experian Pandora client, or opening the server.properties file.
  4. Copy the Experian Pandora database folder and all sub-folders to a different directory. Depending on the size of the repository, backing up the database could take several hours. Using backup utilities will speed up the backup process.

Note: VM snapshots can be unstable backups, especially if there are background jobs running, so it is recommended that the service is stopped and a physical backup is taken of the Experian Pandora database directory.

Unix/Linux

To take a backup of your database on Windows, follow these steps:

  1. Before shutting down the service, make sure that no load or validation jobs are being carried out.
  2. Ensure that the Experian Pandora service is fully stopped. You can confirm that Experian Pandora is not running using the command pserver status from the Experian Pandora user.
  3. Locate and copy the Experian Pandora database directory and all sub-folders. By default, the database is in the following location: /pandora. If Experian Pandora is installed in a different location to the default, you can find where it is by either checking the Storage server settings within the Experian Pandora client, or opening the server.properties file.
  4. Copy the Experian Pandora database folder and all sub-folders to a different directory. Depending on the size of the repository, backing up the database could take several hours. Using backup utilities will speed up the backup process.

Note: VM snapshots can be unstable backups, especially if there are background jobs running, so it is recommended that the service is stopped and a physical backup is taken of the Experian Pandora database folder.

2. Download the installer

You will have been sent a link to enable you to download Experian Pandora. Follow the link in the email and download the latest setup executable.

The site is password protected and you should have received authentication details from your local Technical support representative via email. Note that these details are different to the login credentials you have been given to login to the Experian Pandora client.

If you haven't received a download link or don't know your authentication details, contact your local Technical support team.

3. Install the new version

After downloading the installer, run it and follow the installation instructions for either a single machine or client-server installation.

Please note:

  • It's safe to leave the previous installation installed, you will however need to set the previous server service to Disabled to prevent it restarting after a server restart. (It should already be stopped.)
  • You will have to re-apply any previous changes to location directories that you made either during your original installation or prior to upgrade unless you have previously configured a system-wide location for server.properties file. This can be done in 1 of 2 ways:
    • take a copy of the settings in the server.properties file and apply them to the newly created copy after upgrade installation has completed, or
    • refer to Configuring server properties section.
  • You will also need to repeat any changes you made to the .ini files such as changes to the default jvm memory settings.

4. Start the server

Windows service
  1. Navigate to Windows Services. From the Start menu, in the Search programs and files box, type Services and press Enter.
  2. Locate Experian Pandora Database Server <version>.
  3. Right-click, and select Start.
Standalone server

The Experian Pandora Server runs as a normal executable. To run the server as a standalone, from the Start Menu locate the program group for the Experian Pandora Server. Click the Pandora Database Server icon to execute it.

5. Open Experian Pandora

  1. From the Start menu, click Experian Pandora Client <version>.
  2. In the pop up dialog, select the server to connect to (localhost if you've installed Experian Pandora on a single machine, or enter the server address and port number if you're connecting to a remote server), then enter your credentials and click Login. The default credentials are:

    username: administrator
    password: administrator

    We recommend that you change the default credentials immediately after initial installation (in the Experian Pandora client, right-click Home User Change password...). For other users, we recommend that the administrator logs in and either changes the passwords before handing out login details or deletes them and creates their own set of users. The other default users (other than admin) are mainly for getting started or demonstrations.

    Got an error message? Click here to troubleshoot. 

  3. If you don't already have a license key, you will need to request one when you first log into Experian Pandora. On the License Key screen, clicking the Email button will populate an email with the information. Send the email, and when you receive your license key, paste it here.

You're all set! To get started on Experian Pandora, view the Quick start guide for an overview of the Experian Pandora workflow.

 

Upgrading using a patch

1. Back up the Experian Pandora database

You should take a backup of your database before upgrading or patching to a newer version of Experian Pandora. Whilst there shouldn’t be issues with updating the database to a new version of Experian Pandora, backups should be taken.

Windows

To take a backup of your database on Windows, follow these steps:

  1. Before shutting down the service, make sure that no load or validation jobs are being carried out.
  2. Ensure that the Experian Pandora service is fully stopped. This can be done by setting the service startup type to ‘Disabled’ in services.msc. Alternatively, stop the Experian Pandora standalone .exe. [how to do this?]
  3. Locate and copy the Experian Pandora database directory and all sub-folders. By default, the database is in: C:\Pandora. If Experian Pandora is installed in a different location to the default, you can find where it is by either checking the Storage server settings within the Experian Pandora client, or opening the server.properties file.
  4. Copy the Experian Pandora database folder and all sub-folders to a different directory. Depending on the size of the repository, backing up the database could take several hours. Using backup utilities will speed up the backup process.

Note: VM snapshots can be unstable backups, especially if there are background jobs running, so it is recommended that the service is stopped and a physical backup is taken of the Experian Pandora database directory.

Unix/Linux

To take a backup of your database on Windows, follow these steps:

  1. Before shutting down the service, make sure that no load or validation jobs are being carried out.
  2. Ensure that the Experian Pandora service is fully stopped. You can confirm that Experian Pandora is not running using the command pserver status from the Experian Pandora user.
  3. Locate and copy the Experian Pandora database directory and all sub-folders. By default, the database is in the following location: /pandora. If Experian Pandora is installed in a different location to the default, you can find where it is by either checking the Storage server settings within the Experian Pandora client, or opening the server.properties file.
  4. Copy the Experian Pandora database folder and all sub-folders to a different directory. Depending on the size of the repository, backing up the database could take several hours. Using backup utilities will speed up the backup process.

Note: VM snapshots can be unstable backups, especially if there are background jobs running, so it is recommended that the service is stopped and a physical backup is taken of the Experian Pandora database folder.

2. Perform the patch by using new jar files

To perform a patch of an existing installation, you will need the following files that will have been supplied to you by your Technical support representative:

  • pserver.jar
  • pclient.jar.

Both files are needed, whether you are patching the server installation or a client installation. If you have not received these files, please contact your local Technical support team.

  1. Stop the server or service and client(s). 
  2. Place the pserver.jar and pclient.jar files directly into the installation directory folder. Once these files are in place you can start everything back up.

3. Start the server

Windows service
  1. Navigate to Windows Services. From the Start menu, in the Search programs and files box, type Services and press Enter.
  2. Locate Pandora Database Server <version><operating system>.
  3. Right-click, and select Start.
Standalone server

The Experian Pandora server runs as a normal executable. To run the server as a standalone, from the Start menu, locate the program group for the Experian Pandora. Click Pandora Database Server<version number><operating system> to execute it.

Unix server

To start the server with default settings, run the following command:

./pserver start

4. Open Experian Pandora

  1. From the Start menu, click Experian Pandora Client <version>.
  2. In the pop up dialog, select the server to connect to (localhost if you've installed Experian Pandora on a single machine, or enter the server address and port number if you're connecting to a remote server), then enter your credentials and click Login. The default credentials are:

    username: administrator
    password: administrator

    We recommend that you change the default credentials immediately after initial installation (in the Experian Pandora client, right-click Home User Change password...). For other users, we recommend that the administrator logs in and either changes the passwords before handing out login details or deletes them and creates their own set of users. The other default users (other than admin) are mainly for getting started or demonstrations.

    Got an error message? Click here to troubleshoot. 

  3. If you don't already have a license key, you will need to request one when you first log into Experian Pandora. On the License Key screen, clicking the Email button will populate an email with the information. Send the email, and when you receive your license key, paste it here.

Database upgrade

Once you have logged in, you may see some stages running as your database upgrades. These can include the Repository being updated, objects being re-written (this part is dependent on what has changed in the update/patch) and if required a defragmentation of the data folder (again dependent on how fragmented that data has become).

Please note, if you have a large repository or a significant number of tables, then the upgrade can take upwards of a few hours.

You're all set! To get started on Experian Pandora, view the Quick start guide for an overview of the Experian Pandora workflow.

 

Upgrade using a .tar.gz file

1. Back up the Experian Pandora database

You should take a backup of your database before upgrading or patching to a newer version of Experian Pandora. Whilst there shouldn’t be issues with updating the database to a new version of Experian Pandora, backups should be taken. To do this, follow these steps:

  1. Before shutting down the service, make sure that no load or validation jobs are being carried out.
  2. Ensure that the Experian Pandora service is fully stopped. You can confirm that Experian Pandora is not running using the command pserver status from the Experian Pandora user.
  3. Locate and copy the Experian Pandora database directory and all sub-folders. By default, the database is in the following location: /pandora. If Experian Pandora is installed in a different location to the default, you can find where it is by either checking the Storage server settings within the Experian Pandora client, or opening the server.properties file.
  4. Copy the Experian Pandora database folder and all sub-folders to a different directory. Depending on the size of the repository, backing up the database could take several hours. Using backup utilities will speed up the backup process.

Note: VM snapshots can be unstable backups, especially if there are background jobs running, so it is recommended that the service is stopped and a physical backup is taken of the Experian Pandora database folder.

2. Download the installer

Download the relevant .tar.gz for Experian Pandora you wish to upgrade to from the download page obtained from your support representative. If you have not received these files, please contact your local Technical support team.

3. Install the server

  1. Login in as the Experian Pandora user (default is pandora)
  2. Copy the Experian Pandora tar file to the home directory of the Experian Pandora user; un-tar the distribution as follows:
    tar –xvzf pandora_tar_file.tar.gz

    This will create a new directory of the form /home/pandora/pandora<version>

  3. Add the install_directory/bin to the $PATH environment variable:
    export PATH=$PATH:/home/pandora/pandora<version>/bin

    This sets the variable for the session. How to make this as a persistent change is dependent on your operating system.

Note: You will have to make sure to re-apply any previous changes to default settings that you made either during your original installation or prior to upgrade. This are most likely in server.properties and install_directory/etc/Linux/pserver

This can be done in one of two ways:

4. Start the server

To start the server with default settings, run the following command:

./pserver start

5. Connect Experian Pandora client(s) to the server

If your Experian Pandora client(s) are already installed, follow these steps to connect them to the server, otherwise follow the instructions to install the client(s) on the target machine(s).

On the machine where the client is installed:

  1. From the Start menu, click Experian Pandora Client <version>.
  2. In the pop up dialog, enter the server address and port number, your credentials and click Login. The default credentials are:

    username: administrator
    password: administrator

    We recommend that you change the default credentials immediately after initial installation (in the Experian Pandora client, right-click Home > User Change password...). For other users, we recommend that the administrator logs in and either changes the passwords before handing out login details or deletes them and creates their own set of users. The other default users (other than admin) are mainly for getting started or demonstrations.

    Got an error message? Click here to troubleshoot. 

  3. If you already have a licence key, you will be able to connect to the server automatically. Otherwise, you will be presented with the License Key screen, and you will need to request a license key. Click the Email button to populate an email with the information. Send the email, and when you receive your license key, paste it here.

You're all set! To get started on Experian Pandora, view the Quick start guide for an overview of the Experian Pandora workflow.

 

Troubleshooting

Logging into the Experian Pandora client

The following table lists the error messages that you may encounter, and how to fix it.

MessageDescription
Unrecognised server name This happens because the client does not recognise the host name as a location it can connect to. For example, the location is not reachable on your network.
Invalid username or password This happens when your username or password are incorrect.
Connection refused by server This happens when you can connect to the server location but your connection is being refused/blocked. This could be because the port is incorrect, or due to a firewall/permission blocking your connection. This can also happen if the Experian Pandora server has not been started.
Not logged in This happens when you have a server/client version mismatch, for example, connecting to an Experian Pandora V5.0.0 server with an Experian Pandora V4.3.0 client. (Version 5.1.0 and earlier)
Failed to connect to the server This happens when you have a Server/Client version mismatch, for example, connecting to an Experian Pandora V5.2.0 server with an Experian Pandora V5.3.0 client. (Version 5.2.0 and later)
Connection timed out This happens when your request to connect to the server times out. For example if you click connect, the client will send a request to connect, if it receives no response within a couple of minutes, your request will time out and you will be presented with this error. Example: Connect using an IP address that cannot be reached

Copyright ©, 2014-2017. All rights reserved.