Config parameter

Specify the Config parameter in the JDBC URL of a REST API connection. Unlike the Sample method, the Config method creates a connection that references a local configuration file. You can customize this .json configuration file so that the schema translation is preconfigured. This allows you to achieve high performance when you retrieve large amounts of data.

The JDBC URL field appears when you create a data server connection and select Progress Data Direct Autonomous REST connection as the connection type.

For more details: Read the topic Using the input REST file method

Syntax

jdbc:ibmcognos:autorest:Config="path_to_local_configuration_file";ServerName=Endpoint_URL

where:

  • path_to_local_configuration_file is the path, enclosed in double quotes, to a central location to which you uploaded the configuration file.

    For more information, see Store .json files in a central location.

  • Endpoint_URL is a REST API location that returns data that you can use in Cognos Analytics. It can contain many optional connection properties to accommodate various types of API responses and authentication. For example, its properties support many OAuth 2.0 authentication flows which vary based on the security needs of each web service.
For more details: See the topic Input REST file syntax in the Progress® DataDirect® Autonomous REST Connector for JDBC™ User's Guide for Partners.