...
Create a Database Connection, e.g. PARENT_CONNECTION which acts as a Parent Connection for the customized client specific connections. For detailed information on creating a Database connection, refer Creating a DB Connection.
Create a Corporarte Customer or client in the eMACH-Sigma Studio by providing the necessary details of your client on the client creation screen. For detailed information on creating corporate customer or clients, refer Creating Corporate Customers.
...
Select the database used for your application, e.g. MySQL.
Enter a unique connection name in the Connection Name field, e.g. Connection_1.
Enter the server name that hosts the database in the Host Name field.
Enter the server port number in the Port field.
Enter the necessary details for the connection and enter the schema name in the Schema field, e.g. multi_13122023 for the Client HIGHSCORE. Refer Create a Database Connection to know more about configuring connections.
Enter the schema name in which the data is stored.
...
Select the required column from the Column IDs field for the datasource. Refer Create a DB Data Source to know more about creating a datasource from the DB connection.
Click Save.
...
Configure a report with the datasource created by the Parent Connection by proceeding with the following steps;
On the home page of eMACH-Sigma Studio, Click Manage>Report.
The information report screen is displayed with the Report Maintenance tab, by default.
Enter the necessary details for the report, as shown below. For detailed information on configuring a report refer Configuring Reports.
...
To generate a report with client-specific data perform the following steps:
Log on to the eMACH-Sigma Application using the delegation user credentials.
Click the client lookup field on the top right side of the eMACH-Sigma home page to choose the client of your choice, e.g. HIGHSCORE.
...