Home Services Partners Company
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

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.