Building the Connection URL

Use the connection URL to supply connection information to the data store that you are accessing. The following is the format of the connection URL for the Simba Marketo JDBC Connector:

jdbc:marketo://;Host=[Endpoint];Auth_Type=OAuth 2.0;[Property1]=[Value];[Property2]=[Value];...

[Endpoint] is the endpoint of the Marketo server that you are connecting to. For information about how to find your endpoint value, see Finding Your Marketo Host Information.
[Property] is any one of the other connection properties supported by the connector. At minimum, you must set the properties that provide your access token or Marketo service information for authentication.

For information about configuring authentication, see Configuring Authentication. For a list of the properties available in the connector, see Connector Configuration Options.

For example, to connect to Marketo and authenticate the connection using an access token, you would use the following connection URL:

jdbc:marketo://;Host=123-ABC-321.mktorest.com;Auth_Type=OAuth 2.0;Auth_AccessToken=kP9PcyQ7prK2LwUMZMpFQ4R+5VE

Important:

Do not duplicate properties in the connection URL.