posts - 88 , comments - 3 , trackbacks - 0

Connect to and Query Eloqua Data in QlikView over ODBC

Create data visualizations with Eloqua data in QlikView.

The CData ODBC drivers expand your ability to work with data from a wide variety of data sources. This article outlines simple steps to connect to Eloqua data and create data visualizations in QlikView.

Populate a Chart with Eloqua Data

The steps below supply the results of an SQL query to a visualization in QlikView. In this article, you will create a bar chart with the query below:

SELECT Name, ActualCost FROM Campaign
  1. If you have not already, specify connection properties in a DSN (data source name). You can use the Microsoft OBC Data Source Administrator to create and configure ODBC DSNs. Typical connection properties are the following:

    • User
    • Password
    • Company

    See the "Getting Started" chapter in the help documentation for a guide to setting the required properties in the Microsoft ODBC Data Source Administrator.

  2. Click Edit Scripts and add the connection. You can select the DSN on the Data tab in the Edit Scripts wizard.
  3. After selecting the DSN, click Select to build the query in the SELECT statement wizard. Or, you can enter the query directly into the script.
    A script that connects and executes an SQL query. (Salesforce is shown.)
  4. Create a new bar chart with Name and ActualCost as the x- and y-axes using the Create Chart wizard.
  5. Finish the wizard to generate the chart.

    A chart populated with the results of a query. (Salesforce is shown.)

Print | posted on Tuesday, June 16, 2015 3:52 AM | Filed Under [ cdata ODBC Eloqua QlikView ]

Powered by: