Unica Campaign Influence integration with Salesforce via DataDirect Connect XE for ODBC

Unica Campaign Influence integration with Salesforce via DataDirect Connect XE for ODBC

November 08, 2011 0 Comments

IBM Unica Campaign Influence shops have been running Progress DataDirect Connect for ODBC drivers for years to achieve superior performance and data connectivity to Informix, Sybase IQ, and SQL Server from AIX, Solaris, and Linux.  I recently shared our ground breaking "on-premise to cloud" data access story with Architects and DBAs at these shops, and they are really excited about extending support to cloud data sources without having to change their Unica deployment!

Speaking of the cloud, what about my Salesforce data?

User tables accessed by UCI typically contain data about your company's customers, prospects, or products; and you may want to use this data for a campaign to target these dimensions against other facts such as account types or balances.  Well, more and more organizations are storing this kind of data in Salesforce.

What are my options?

Option 1:

  • Engage your favorite DBA to create an intermediate on-premise database to store the Salesforce data.
  • Contact your data integration team to setup additional data integration (ETL) workflows against Salesforce.
  • Develop a new ETL job to get the data you need at the frequency you want it refreshed.
  • Ask the Unica Server Admin to install and configure an intermediate database client to access the historic snapshot of your Salesforce.com data.

Option 2:

Let's try Option 2, how did you guys do that?

Progress DataDirect has developed an enterprise data connectivity solution for Salesforce that makes Salesforce.com look like a relational database.  Unica Campaign Influence already supports the DataDirect Connect64 for ODBC  drivers to relational data sources via our Unix/Linux driver manager per the UCI admin guide, "...64-bit Unica Campaign provides two ODBC access libraries: one appropriate for ODBC data sources ... compatible with the DataDirect implementation (libodb4dDD.so — used by Unica Campaign to access,for example, Teradata)."

Refer to Unica Campaign 8.2 Administrator's Guide for additional details.

What about access to marketing information with Unica eMessage?

We have Connect XE for Salesforce JDBC drivers too!

Get started today!

1. Download free 15 day trial of the DataDirect Connect XE for ODBC or JDBC Salesforce drivers to integrate an unlimited number of applications with Salesforce.

2. Or call 1-800-876-3101 to speak with a live Solutions Consultant to learn how other organizations are making progress with DataDirect Connect products and Unica Campaign Influence.

Sumit Sakar

Sumit Sarkar

Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.

Comments are disabled in preview mode.
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

More From Progress
Then, Now and Beyond: The Future of Back Office Software
Read More
2020 Progress Data Connectivity Report
2020 Progress Data Connectivity Report
Read More
Getting Ahead of the Hybrid Data Curve
Read More