MicroStrategy ONE

Connect to Eloqua Using ODBC

Starting in MicroStrategy ONE Update 12, you can create data sources using a customized connection string for gateways without pre-defined entry. Therefore, users can crate data sources for Eloqua using generic entry.

  1. Add an environment connection and log in to Workstation.
  2. Click next to Data Sources under Administration.

  3. Search "Eloqua" and choose Other Relational Sources.

  4. In Database Version, choose Eloqua.
  5. Expand Default Database Connector and choose Add New Database Connection.

  6. In Connection String, enter one of the following strings based on your connection:
    • Using basic authentication:

      • Copy 
      Driver={MicroStrategy Eloqua ODBC Driver};Host=secure.server01.eloqua.com;Auth_Type=Basic; 

    • Using access token:

      • Copy 
      Driver={MicroStrategy Eloqua ODBC Driver};Host=secure.server01.eloqua.com;Auth_Type=Access Token;Auth_AccessToken=a2c4e6g8i9k

  7. In Authentication Mode, choose one of the following based on your connection:
    1. For basic authentication, choose Standard.

    2.   For access token, choose Preconfigured.
  8. In Default Database Login, choose Add New Database Login.
  9. Enter your Username and Password.
  10. Click Save.
  11. In the Add Data Source dialog, choose a Project to assign and access the data source.
  12. Click Save.