Forum | Synoptix

Learn, Create, Report
It is currently Thu Jul 18, 2019 9:35 pm

All times are UTC - 7 hours [ DST ]




Post new topic Reply to topic  [ 1 post ] 
Author Message
PostPosted: Tue May 28, 2019 12:40 pm 
Site Admin
User avatar

Joined: Tue Dec 10, 2013 3:27 pm
Posts: 403
Position: Forum Administrator
A brief guide on adding drivers, updating views, & amending the client host package.
Download as a 2 page PDF here:
Attachment:
Encompix Configuration Guide.pdf [194.17 KiB]
Downloaded 11 times


INITIAL SETUP | ADDING JDBC DRIVERS


• The Advanced Reporting (AR) client requires JDBC drivers in order to be compatible with Encompix.
AR does not distribute these drivers, as they are third party files, so they must be sourced elsewhere.
• You can install the JDBC files missing from the AR client by copying them from an installation that already contains the drivers, and place them inside the AR install directory.
The default location for this directory is C:\ Program Files \ Advanced Reporting.
• Aptean customers can typically locate these 8 .jar files wherever you have Progress locally installed.
• The .jar files to be copied over are:

◦ Base.jar
◦ Messages.jar
◦ Openedge.jar
◦ Pool.jar
◦ Progress.jar
◦ Schema.jar
◦ Spy.jar
◦ Util.jar

• You can paste these .jar files into the main Advanced Reporting install directory folder.

Image

VIEW CHANGES | CHANGING ISOLATION LEVEL

• In order to allow the creation & updating of SQL views, the Isolation Level must be changed to READ COMMITTED.
This can be done via the ODBC OpenEdge Driver configuration using the steps below.
It will require all users to be logged off of the Progress database.
• From your Start Menu, select Control Panel > Administrative Tools > Data Sources (ODBC) > System DSN.

Image

• Within the System DSN tab, select your data source.
This is your live database.
• Select “Configure” and in the new window, click the Advanced tab.
• The Default Isolation Level has a dropdown menu.
From this menu, select READ COMMITTED and apply the change.
• Ensure that all users are logged off of the Progress database, including the master (admin) user.
Image

• You may now relaunch the Advanced Reporting client.
• You will be prompted for the database administrative password. Enter the credentials for your SYSADM Progress user.
Note that if you have multiple companies, you will receive a db login prompt for each of them and you will need to enter the credentials each time.
• Following these steps, we recommend that the Isolation Level be changed back to UNCOMMITTED
Image

• Check your AR install directory to ensure that the sc17.syn file has been deleted.
As the views are updated within the client, sc17.syn should automatically delete itself at the conclusion of this process. If this file still appears after you have completed the steps above, it indicates that the views may not have updated properly.

CONFIGURING HOST PACKAGE AFTER UPDATING CLIENT

• After your Advanced Reporting client has been updated to version 8.1.02, you will need to modify your company connection(s). Perform the following steps:

◦ Launch AR client and navigate to Admin Setup
◦ Select the Connection Setup tab
◦ Highlight your company name and click “Modify”
◦ Proceed through the screens until you reach Host Specifics Setup. Note that the ERP Version window is blank. Use the dropdown to select the proper version for your ERP. Click “Finish.”
◦ Relaunch the AR client for this change to go into effect.
◦ Note that you must complete this step for each of your company connections.
Read more on the connection setup.

Image

If you are still prompted to create views after you have completed the initial setup and steps above:
•Check the Isolation Levels and confirm it is on READ COMMITTED and then launch the AR client.
• If the issue persists, contact CompuSoft Support.


Attachments:
update ERP version Encompix.png [27.57 KiB]
Not downloaded yet
db admin login popup.png [61.83 KiB]
Not downloaded yet
READ COMMITTED select and apply.png [62.68 KiB]
Not downloaded yet
Encompix access isolaiton levels ODBS.png [62.55 KiB]
Not downloaded yet
copy .jar files to AR directory.png [26.03 KiB]
Not downloaded yet
Top
   
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC - 7 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
cron
Powered by phpBB® Forum Software © phpBB Group
Powered by Reputation System © Pico88