Proxy server
- Last Updated: March 29, 2023
- 2 minute read
- DataDirect Connectors
- JDBC
- Microsoft Sharepoint 6.0
- Documentation
This string includes the properties you may need to connect through a proxy server with OAuth 2.0 refresh token grant authentication.
jdbc:datadirect:sharepoint:ServiceURL=serviceurl;ProxyHost=proxy_host;
ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;
ClientID=client_id;ClientSecret=client_secret;TokenURI=token_uri;
RefreshToken=refresh_token;[property=value[;...]];
where:
- serviceurl
- specifies the URL of a SharePoint site (or "site collection"), for example, https://mycorp.sharepoint.com/sites/marketing/global. The URL must include the base URL (https://mycorp.sharepoint.com/), as well as the path to the site (marketing/global). The driver uses the base URL to infer an OData endpoint, and the site path is used to locate the site that will be accessed.
- proxy_host
- specifies the proxy server to use for the first connection.
- proxy_password
- specifies the password needed to connect to a proxy server for the first connection.
- proxy_port
- specifies the port number where the proxy server is listening for
requests for the first connection. The default is
0.
- proxy_user
- specifies the user name needed to connect to a proxy server for the first connection.
- client_id
- specifies the client ID key for your application.
- client_secret
- specifies the client secret for your application.
Important: The client secret is a confidential value used to authenticate the application to the server. To prevent unauthorized access, this value must be securely maintained.
- token_uri
- specifies the endpoint used to exchange authentication credentials for access tokens.
- refresh_token
- specifies the refresh token used to either request a new
access token or renew an expired access token.
Important: The refresh token is a confidential value used to authenticate to the server. To prevent unauthorized access, this value must be securely maintained.
- property=value
- specifies connection property settings. Multiple properties are separated by a semi-colon.
The following example connection string includes the properties required for using a proxy server with OAuth 2.0 refresh token grant authentication.
Connection conn = DriverManager.getConnection
("jdbc:datadirect:sharepoint:
ServiceURL=https://mycorp.sharepoint.com/sites/marketing/global;
ProxyHost=pserver;ProxyPassword=secret;ProxyPort=808;ProxyUser=jsmith;
ClientSecret=12a3=bCD/EfGh4Ijk+Lm5P67qR8s=//TuV+WXy1Zabcd;
TokenURI=https://login.microsoftonline.com/common/oauth2/v2.0/token;
RefreshToken=12a3=bCD/EfGh4Ijk+Lgd8g-44tk3c527831;");