GraphQL connection settings
▪ Server URL: URL[:Port]
▪ Username and Password
▪ HTTP Header: Define HTTP headers, for example, to specify an authentication key.
▪ Timeout: For very large, complex results, a timeout can be specified.
▪ Queries Root Name: Default name of the query object: Query
▪ Mutations Root Name: Default object name of the mutations: Mutation
OData connection settings
▪ Server URL: URL[:Port]
▪ Username and Password
▪ HTTP Header: Define HTTP headers, for example, to specify an authentication key.
▪ Timeout: For very large, complex results, a timeout can be specified.
▪ Retrieve real values for the Designer: Using this option you can display live data in the Designer.
ODBC connection settings
▪ Example of a connection string: Driver={SQL Server};Server=myServerAddress ;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
OLE DB connection settings
▪ Example of a connection string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\myServer\myFile.mdb
REST connection settings
▪ Server URL: URL[:Port]. Data source parameters can be inserted into the URL using the syntax {{ParameterName=StandardValue}}. For more information, see the Data source parameters section.
▪ Username and Password
▪ HTTP Header: Define HTTP headers, for example, to specify an authentication key.
▪ Timeout: For very large, complex results, a timeout can be specified.
▪ JSON configuration: Name of the root table. If no value is defined, the default value of the data source is used.
▪ In-Memory mode: With this option all data will be loaded into memory at first. This leads to a longer loading phase of the data source, however results in faster queries afterwards. Using this option leads to an increased load on the server and can require adjusting report templates as the data type of columns with unusual data types might change.
REST connection settings with OAuth 2.0
▪ In the configuration dialogue, select “OAuth 2.0” as the authentication type and start setting up the connection.
▪ Enter the “Authorization endpoint”, „Access token endpoint”, “Grant Type”, “Client ID”, “Client Secret”, “Refresh Token” and, if required, the “Access areas (scope)”. This information is app-specific. Please refer to the manufacturer’s documentation.
▪ Complete the authentication via „Request Refresh Token”