Setting up the export of data to Salesforce Marketing
To export Oracle Unity segments to Salesforce Marketing, you will need to create the destination and campaign job that will export the data.
Before you begin
Make sure you have the following parameters before setting up the data connection.
SFTP server name: The hostname for the SFTP server, formatted as username@sftpserverhostname.com.
Authentication key: Prepare a text file that has the authentication key to access the SFTP server.
Oracle Unity only supports private authentication keys in RSA format. You can't upload a public authentication keys.
To create an RSA authentication key, learn how to Generate SSH Keys in PEM Format to Connect to a Public or On-Premises sFTP Server from the Using the FTP Adapter with Oracle Integration Help Center.
Folder name: The path name to the folder on the SFTP server that has the files to export.
Encryption key: If the exported file has a PGP compression format, prepare a file with the key to encrypt the file.
Step 1: Create the Secure FTP destination
After collecting the information above, follow the steps for creating an Secure FTP destination. The destination provides all the details for exporting the data.
Step 2: Create the campaign job
Once the destination is created and published, follow the steps for creating the campaign job that will export the segment data.
Step 3: Run the campaign job
Run the campaign job from the Campaigns page and monitor the status of the job from the Jobs dashboard.
Step 4: Import segment data into Salesforce Marketing
After the segment data is successfully exported, you can then import the segment data into Salesforce Marketing. Learn more about Imports from the Salesforce Marketing documentation.