profile image
Omkar Pathak
Technical Lead at Unica
About
Omkar is the Technical lead for Unica L2 Support. He is also a Client Advocate for many customers and managing customer escalations. He has more than 16 years of industry experience and associated with Unica for last 9 years.
Posts by Omkar Pathak
article-img
Marketing & Commerce | October 1, 2020
Configuring HCL Unica Campaign with Amazon Redshift Database
Marketers these days are more involved and skilled with using data than ever. The customer information is gathered, stored, and retrieved from a central database, and it is increasing exponentially. It helps facilitates the marketers to make more specific and targeted marketing communications and create more personalized experiences for the users. But database management and handling is no easy job, and Cloud databases and Database as a Service (DaaS) platforms are becoming more popular in enterprises. Amazon Redshift is a known name among them. What is Amazon Redshift? Amazon Redshift is a fully managed petabyte-scale cloud-based data warehouse product designed for large scale data set storage and analysis. The current trend in the market is to use cloud-based database service, and the HCL Unica Campaign is well-versed to have integration with such services. In this article, we are going to find how easy it is to configure the HCL Unica Campaign to make use of Amazon Redshift as a user database using Amazon ODBC Driver. What do you need as a Pre-requisite? You would need below pre-requisites to start configuring Unica with the Amazon Redshift database: HCL Unica Campaign application, which needs to be integrated with Amazon Redshift Database. Amazon Redshift Details: Cluster Name, Database Name, User Id, Password (You will get all these details when you purchase a contract for Amazon Redshift.) In Unica UI, under Settings->Configuration, under node "Affinium|Campaign|partitions|partition1|dataSources", make sure that a datasource template for "(PostgreSQLTemplate)" is already added and you should be able to create a datasource using this template. If HCL Unica suite is installed on Unix based OS, install unixODBC 2.3.x on the server on which Unica Campaign listener is installed. Supported ODBC Drivers To integrate Unica Campaign with Amazon Redshift Database, you can either use PostGreSQL ODBC Driver or Amazon ODBC Driver. To...
a/icon/common/search Created with Sketch.