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.
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.
3. Configure your connection information to Eloqua. My Eloqua admin setup an account and I received an e-mail from email@example.com with the connection information.
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.
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.
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.
8- Click Next and continue to design your Universe to Eloqua similar to any other database.
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 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.
Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.