The Simba Marketo JDBC Driver enables Business Intelligence (BI), analytics, and reporting on data that is stored in Marketo. In this blog we show you how to connect to analyze your Marketo data using SQL Workbench and run custom SQL queries.

Marketo JDBC Driver Installation Steps:

  1. Each machine where you use the Simba Marketo driver must have Java Runtime Environment (JRE) 8.0 or later installed.To check the JRE version that is installed on your machine, open a command prompt and type:

    To download and install JRE on your machine, go to the “Java SE Downloads” page on the Oracle Technology Network: http://www.oracle.com/technetwork/java/javase/downloads/index.html
  2. Download an evaluation of Simba’s Marketo JDBC Driver.Be sure to select Java (JDBC) for the platform. Depending on your use case, select either Desktop or Server from the drop-down list.
  3. Extract the Simba_Marketo_JDBC.zip archive that you just downloaded. The extracted folder contains a “docs” subfolder, and another ZIP archive.
  4. Extract the SimbaMarketoJDBC42-{current-version}.zip archive. The extracted folder contains a libs folder with .jar files for the Marketo JDBC driver.
  5. A license file was emailed to you when you downloaded the driver. Locate this file and save it to the same directory where you extracted the .jar files.

Configuring the Marketo JDBC Driver:

To access Marketo data store using the Simba Marketo JDBC Driver, you must authenticate the connection using the OAuth 2.0 protocol. You can do this by providing a valid access token, or by providing information about your custom Marketo service so that the driver initiates an OAuth 2.0 authentication flow to retrieve and use the corresponding access token.

In this example we will demonstrate connecting through initiation of OAuth 2.0. Access token expires within 1 hour, therefore we will demonstrate connecting using Client ID and Client Secret.

Before constructioning a connection string, you will need to retrieve Client_id, Client Secret and HOST of your Marketo account.

Client ID and Client Secret:

  1. Navigate to https://login.marketo.com/ page and log-in.
  2. Click Admin in the top right hand corner of the page.
    Marketo Admin
  3. Click LunchPoint in the navigation bar.
    marketo admin launch point
  4. Click View Details.
    marketo admin launch point details
  5. Client ID and Client Secret will be displayed.
    Get Tokenb

If you want to connect using the access token, you will be able to retrieve it here by clicking Get Token. The access token will expire in 1 hour and you will need to obtain another token.

Host:

  1. To obtain the “HOST” content required for the connection, Click Web Services in the navigation bar.
  2. The Host is displayed in the REST API section, underlined in red.In this example, the host is: 442-cfp-713.mktorest.com

  3. Using the information from the previous point, the following connection string is generated:

  4. Before completing your connection to Marketo using Simba’s Marketo JDBC driver, you need to know the name of the class to use with your application. since we support JRE 8.0 or later use the following class name:

Running the Marketo JDBC Driver with your SQL Workbench/J:

  1. SQL Workbench/J does not come with the Marketo JDBC Driver, so you must add the driver to the application. Start by clicking File > Manage Drivers.
  2. Click the Create a New Entry icon.
  3. Name the driver “Simba Marketo”. Load the .jar files by clicking the folder icon.
  4. Navigate to the folder containing your extracted Marketo driver files (the same folder with the license file), Select all the .jar files in the folder and click OK.
  5. The Classname field is now populated with the driver’s class name.
  6. In the example URL field, type the connection URL mentioned in the “Configuring the Marketo JDBC Driver” section above, and then click OK.
  7. click File > Connect Window.
  8. Select the Simba Marketo driver from the driver list, fill in the Username and Password (if it is required), (check the “Autocommit” box) and then click OK.
  9. You are now able to run SQL-92 queries on your Marketo datasource. Type your query into the window and then click the Run icon.

  10. Congratulations! The results of the of your query from SQL Workbench/J to Marketo using simba’s Marketo JDBC driver will be displayed.


Now it's your turn !