Home Services Partners Company
SAP BOBJ Universe to Eloqua, Marketo, Hubspot marketing data

SAP BOBJ Universe to Eloqua, Marketo, Hubspot marketing data

January 08, 2014 0 Comments

Following my widely popular tutorial for Business Objects Universe to Salesforce produced with SAP, I'm hearing several requests for real-time ODBC3 access to complementary data such as marketing automation in Eloqua, Marketo or Hubspot.  In response to the feedback from numerous BOBJ shops and from BOBJ User Groups/Conferences - we are rapidly delivering these SaaS data sources for Business Objects shops via DataDirect Cloud.

Why love the Business Objects Universe to Marketing Automation

  • Marketing data is now sexy and multi source universe (MSU) support with BO 4.0 enables real-time data federation across sales data in Salesforce or Microsoft Dynamics with marketing data in Marketo, Eloqua and Hubspot.
  • This solution leverages existing skills and your investment in SAP.   And Business Objects professionals are awesome, so try and network with them around the water cooler whenever possible.
  • Hit the ground running with DataDirect ODBC3 connectivity to Marketo, Eloqua and Hubspot built from the same client codebase as the trusted relational connectivity available from Business Objects.
  • Everyone is asking for it including the Eloqua topliners community, and ODBC3 access from DataDirect has been the unanimous choice for real-time Universe access to SaaS APIs. 
  • DataDirect connectivity has the most secure architecture for accessing SaaS data from Business Objects.  Most recently, we passed an IT security review consisting of 80 questions in flying colors.

Getting started with BOBJ Universe to Eloqua

1. Sign up and log-in to your DataDirect Cloud account.

(In the spirit of Universe technology, I want to emphasize that DataDirect Cloud is a real-time data service)

2. Select your marketing automation data source such as Eloqua, Marketo or Hubspot.  In this case, I am selecting Eloqua since I have a production account.

eloqua1

3. Configure your connection information to Eloqua.  My Eloqua admin setup an account and I received an e-mail from support@eloqua.com with the connection information.

eloqua-welcome

I set user name, password and company using the custom properties as follows: "Company=Progress;FailOnIncompleteData=1".

Note that the screen may change since this was taken during beta.

eloqua2

4. Download and install the "Progress DataDirect Cloud Driver for ODBC" from DataDirect Cloud.  For Universe Design Tool (UDT) or Information Design Tool (IDT), you will need a 32-bit ODBC client.  For the Business Objects Application Server, you will need a 64-bit ODBC client.

5. Launch the ODBC Administrator from the "Progress DataDirect Cloud Driver for ODBC" program group and create a new data source.  The Database Name corresponds to the name configured in step 3.  You will login using your DataDirect Cloud ID from the ODBC administrator.

eloqua3

6- Launch your design tool (IDT or UDT), and configure the Generic ODBC 3 data source as type, “ODBC3?.

7- Enter User name, Password and Data source name as "Eloqua" in this example.

Enter Salesforce Credentials

8- Click Next and continue to design your Universe to Eloqua similar to any other database.

Information Design Tool

Enjoy the all access data pass from your Universe

If you want to add MSU connectivity to SaaS data sources such as Salesforce, Microsoft Dynamics, Marketo or Hubspot: simply login to your DataDirect Cloud account and create a new connection.  Then create a new local ODBC data source using the same Progress DataDirect Cloud Driver for ODBC  that points to the new connection.

Since these are standard ODBC compliant connections, you can also use them from Data Services running on either Windows or Unix/Linux.

Call 1-800-876-3101 to speak with a systems engineer and learn how other organizations are making progress after creating a BOBJ Universe to marketing automation data.

Sumit Sakar

Sumit Sarkar

Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others. 

Comments
Comments are disabled in preview mode.