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
Comments are disabled in preview mode.
Topics
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
progress-next-logo
ProgressNEXT: Premier Event for Modern Application Development
Read More
 
kinvey-console-thumbnail
Getting Started with Kinvey
Read More
 
whatdevsthink
Low-Code Platforms: What Developers Think and Why
Read More