Creating and maintaining administrations for third party Business Intelligence tools
Menu path
System à HR & Security à Workstations
Introduction
Exact Report Data Provider service provides the support which enables third party Business Intelligence tools, such as Microsoft PowerPivot and Qlik Sense, to retrieve data from Exact Globe Next for your business analytics needs.
The external Business Intelligence tools feed on the data source, and then analyze and transform the data into charts, figures, and statistics, which will allow you to make better business decisions at the right time. For more information on Microsoft PowerPivot and Qlik Sense, see http://www.microsoft.com/en-us/bi/powerpivot.aspx and http://www.qlik.com.
You can create and maintain the administrations on a hosting server. However, the same administration must be created on the other hosting server from where you are accessing.
Only users with the function right Allow retrieving data for report function are able to view all the business information for the respective administration. By default, users with the Administrator role have this function right.
Note:
-
Exact Globe Next only serves as the data source and allows its users to maintain accesses for the Business Intelligence tools in the Reporting screen.
-
Exact Report Data Provider service only supports Business Intelligence tools that use Open Data Protocol.
What version are you using?
The information in this document is based on product update 407.
How do I enable access for third party Business Intelligence tools via Exact Report Data Provider?
-
In the Server screen, click Reporting. The Reporting screen will be displayed.
-
Define the fields in the columns.
-
Click Save, and then Close to exit.
Keep in mind: Each administration is unique. The system will not save duplicated administrations. An error message will be displayed if duplication of administrations is found.
Columns
You can disable or remove an existing administration by clicking 
. Likewise, click 
to add a line (or an administration).
Server
Type the name for the database server. This information is mandatory.
Note: When a valid database server name is defined, the system will automatically retrieve and list all available databases in the option list under the Database column.
Database
Select the required database from the option list. Only users with the right to access the database will be able to retrieve the databases after defining a valid database server name at Server. This information is mandatory.
Note:
-
If the database server name defined at Server is invalid, no database will be listed.
-
By default, the first line shows the first retrieved database.
-
The message “No duplicate administration is allowed” will be displayed if such duplication is found and you will not be able to save the administration information.
URL
This field automatically displays the end point URL of the database server.
Note: This field cannot be edited, and is only available once the Server and Database fields in the respective columns have been defined.
Buttons
Save
Click this to save the information on the administrations.
Close
Click this to exit.
Related documents
| Main Category: |
Attachments & notes |
Document Type: |
Online help main |
| Category: |
|
Security level: |
All - 0 |
| Sub category: |
|
Document ID: |
30.052.044 |
| Assortment: |
Exact Globe
|
Date: |
01-04-2021 |
| Release: |
407 |
Attachment: |
|
| Disclaimer |