Building the Connection URL
Use the connection URL to supply connection information to the data store that you are accessing. The examples below show the format of the connection URL for the Simba Shopify JDBC Connector:
jdbc:shopify://localhost;Host=[Endpoint];Auth_Type=OAuth 2.0;[Property1]=[Value];[Property2]=[Value];...
Where:
- [Endpoint] is the endpoint of the Shopify server that you are connecting to.
- [Property] and [Value] are any one of the other connection properties supported by the connector and the value for that property. At minimum, you must set the properties that provide your credentials for authentication.
For information about configuring authentication, see "Configuring Authentication" on page 1. For a list of the properties available in the connector, see "Connector Configuration Options" on page 1.
For example, to connect to Shopify and authenticate the connection using an access token, you would use the following connection URL:
jdbc:shopify://localhost;Host=simbastore.myshopify.com;Auth_Type=OAuth 2.0;Auth_AccessToken=kP9PcyQ7prK2LwUMZMpFQ4R+5VE;
Important:
- Do not duplicate properties in the connection URL.
- To make sure that the connection URL is compatible with all
JDBC applications, it is recommended that you escape the backslashes (
\
) in your file paths by typing another backslash.