Excel Analytics Version 2 Connect to DB

Excel Analytics Version 2

The latest version of this product has been install on the server. If you had a customized version of the product prior you’d need to redo the customization in this new version. If not then you may use this version out of the box.

Excel is not installed on the server so an initial configuration for the files for GDS and GDM will need to be done.

1) Open the workbook

2) Type CTRL-SHIFT-L

3) Fill in the SQL Instance / MAX DB and Credential and Log in to the MAX Database you are connecting to

4) Click Update

5) Exit the form and Save the Workbook

6) Type CTRL-SHIFT-L

7) Click LoadData

8) Observe the bottom right of the workbook loading data – wait till complete

9) Click on the Contents tab

10) Click on any Hyperlink and Use the Product

Leave a Reply

Your email address will not be published. Required fields are marked *