Campaign Enterprise Using Oracle 11g For Email Marketing
Campaign Enterprise Using Oracle 11g
One of powerful aspects of Campaign Enterprise is the ability for it to connect to databases in reat-time. Information can be read from the database for sending of campaigns, and information can be written back to Oracle when certain events occur like an unsubscribe or click tracking event. The connection to the Oracle database is accomplished using the Oracle provided ODAC provider (Oracle Database Access Components) which is an OLEDB compliant database connector.
You can read about and download the Oracle ODAC provider from their website by Clicking Here
The connection string you would use to connect Oracle can be in several different forms. You can use a TNS-Less connection string where connection information is part of the connection string.
Or you can use a TNS reference if you cannot have this type of information exposed.
Security for Oracle connections can be tightly controlled by use of creating an Email List so connection information is not exposed to outside sources.
You can read about and download the Oracle ODAC provider from their website by Clicking Here
The connection string you would use to connect Oracle can be in several different forms. You can use a TNS-Less connection string where connection information is part of the connection string.
Or you can use a TNS reference if you cannot have this type of information exposed.
Security for Oracle connections can be tightly controlled by use of creating an Email List so connection information is not exposed to outside sources.