In this stage, you install Pegasus XRL, connect to the Pegasus XRL database and configure the Opera 3 SQL SE DataLink. A DataLink is a collection of files forming the business logic layer, allowing XRL to present a product database in layout or format that can be easily recognised.
This section includes detailed steps to install XRL. If you are upgrading from an earlier version, you must first remove the existing version after taking a backup of the XRL database file.
Pegasus XRL must be installed on each computer where it is used.
All actions up to stage 3 must be completed.
Follow these instructions to install Pegasus XRL.
# |
To install Pegasus XRL |
✔ |
|---|---|---|
1. |
Run the Pegasus XRL setup program to open the installation screen. |
|
2. |
On the Pegasus XRL installation screen, open the Readme to see the details of the release. Then select Install XRL to start the wizard. |
|
3. |
On the Welcome screen, select Next. |
|
4. |
On the Destination Folder screen, choose an installation folder or accept the default folder (‘C:\Program Files\Infor\Query and Analysis’)(32-bit Windows) or ‘C:\Program Files(x86)\Infor\Query and Analysis’ (64-bit Windows). Select Next. |
|
5. |
On the Q&A Services screen, leave the box empty and select Next. |
|
6. |
On the Setup Type screen, leave the setup type as ‘Complete’. Select Next. |
|
7. |
On the Ready to Install the Program screen, select Install. |
Follow these steps to set up Pegasus XRL and the DataLink for Opera 3 SQL SE using the Connection Wizard.
The XRL database contains user information, serialisation details, and dictionary settings.
# |
To connect to the Pegasus XRL database |
✔ |
|---|---|---|
1. |
Select ‘Query & Analysis’ from the Product list, and click Next. |
|
2. |
In the Database field, select ‘Microsoft Access’, and click Next. |
|
3. |
In the File Name field, select the ‘LsDatabase.mdb’ file from either of:
|
|
4. |
Click Next twice (ignore the System Database, Time Out, User ID and Password boxes). |
|
5. |
Click Test Connection to check access to the database. If the test fails, click Back to where you can select the ‘LsDatabase.mdb’ database. Make sure that you have chosen the correct location. Then click Next until you can test the connection. |
|
6. |
Click Finish. The next step is to connect to the Opera 3 SQL SE DataLink. |
|
Sharing the ‘LsDatabase.mdb'
database
The ‘LsDatabase.mdb’ Microsoft Access database is installed locally in
the 'Settings' folder (see step 3 above).
If multiple users will be using Pegasus XRL
the 'LsDatabase.mdb’ Microsoft Access database file should be moved from
the local program data or program files folder to a shared network drive.
All Pegasus XRL clients should
then point to this database in a central location.
See Appendix
A - Additional client Installations.
# |
To connect to the Opera 3 SQL SE DataLink |
✔ |
|---|---|---|
1. |
Select ‘Opera 3 SQL SE’ from the product list, and click Next. Leave the Enable box selected and leave the Database as ‘Microsoft SQL’. Click Next (ignore the Alias box). |
|
2. |
In the Data Source Name field, enter an asterisk (*) followed by the name of the server. For example, if the name of the server is 'PegasusServer', enter '*PegasusServer'(without the quotes). |
|
3. |
In the Database field, enter 'Opera3SESystem' (without the quotes). |
|
4. |
Click Next (ignore the Time Out and OEM to ANSI boxes). |
|
5. |
Click Next (ignore the User ID and Password boxes). Leave the Authentication as 'Windows'. |
|
6. |
Select Test Connection to check whether Pegasus XRL can access the data source. If the test fails, click Back to where you entered the data source name to make sure that you have entered it correctly. Then click Next until you can test the connection again. |
After completing this stage, follow stage 5 to create Pegasus XRL users and profiles.