5.1 Create and configure your Informatica account

5.1.1 Create your Informatica trial account

Go to https://www.informatica.com/trials/cloud-data-integration.html. You’ll then see this.

ETL

Fill out the form using your own information. Scroll down and click Start Your Free Trial.

ETL

You’ll then see this.

ETL

You’ll also get a similar confirmation email.
Click Confirm Account in the email you just received.

ETL

You’ll then see this.

ETL

Fill out the form and click Log In.

ETL

You’ll see several information messages. Click Continue.

ETL

Click Continue.

ETL

Click Don’t show again.

ETL

You’ll then see this screen, which is the starting point after logging in to Informatica.

ETL

5.1.2 Enable the connector to Adobe Experience Platform

Click Administrator.

ETL

Go to Add-On Connectors.

ETL

Scroll down until you see the connector for Adobe Experience Platform and click Start Free Trial.

ETL

Click OK.

ETL

The connector for Adobe Experience Platform is now installed in your Informatica instance.

5.1.3 Create your Runtime Environment

Go to Runtime Environments.

ETL

You’ll already see the Informatica Cloud Hosted Agent which is already running for your Informatica property.

ETL

Click Download Secure Agent.

ETL

You’ll then see this. Select the Platform (macOS isn’t supported) and make sure to copy the Install Token. Click Download.

ETL

NOTE

As macOS isn’t supported to install the Informatica Cloud Secure Agent, we’re using a Windows machine to install the Cloud Secure Agent. If you have a MacBook, you can use BootCamp, or you can use a solution like VMWare Fusion to run a Windows image from your MacBook.

The next steps are taking place on a Windows machine.

On your Windows machine, download the Informatica Cloud Hosted Agent installation file.

ETL

Open the installation file by double-clicking it.

ETL

Use the default folder (don’t change anything) and click Next.

ETL

Click Install.

ETL

After the installation, you need to fill out the following values:

  • User Name: this is your Informatica user name, which should be your email.
  • Install Token: this is the token you got when you clicked the Download Secure Agent button in the Informatica UI.

ETL

You’ll then have this. Click Register.

ETL

Finally, the Informatica Cloud Secure Agent screen will be shown. Wait a couple of minutes until you see that the Secure Agent and all its services are up and running.

ETL

After installation of the Cloud Secure Agent, you’ll see your runtime environment pop up in the list of available environments. Click your newly created Runtime Environment.

ETL

You’ll then see this. Click Edit.

ETL

You’ll then see this. Open the Service dropdown.

ETL

Select Data Integration Server.

ETL

Scroll down until you see INFA_MEMORY and click the edit icon.

ETL

Replace/paste this value in the inout field:

'-Xms32m -Xmx2048m'

Scroll down until you see DTM JVMOption1 and click the edit icon.

ETL

Paste this value in the input field:

-Dhadoop.home.dir="C:\\\Program Files\\\Informatica Cloud Secure Agent\\\jdk"

ETL

Update the values for the fields DTM JVMOption2 and DTM JVMOption3 with these values:

'-XX:-UseGCOverheadLimit'

'-Xmx2048m'

ETL

Click Save to save your changes. Click the black/white cross icon to close the edit mode.

ETL

You’ll then be back here, with the Runtime Environment Up and Running.

ETL

If you click the Runtime Environment again, you’ll see this detail. Make sure to check whether the Data Integration Server is Enabled and Up and Running.

ETL

NOTE

If the Informatica Cloud Secure Agent is not running as expected, you can try the following steps:

  • Restart the Cloud Secure Agent
  • Reinstall the Cloud Secure Agent
  • Delete the new Runtime Environment and reinstall the Cloud Secure Agent

5.1.4 Setup the Adobe Experience Platform Connector

5.1.4.1 Create your Adobe I/O Certificate

Setting up the Adobe Experience Platform connector in Informatica will require you to have access to the following certificate files, which you get during the setup of your Adobe I/O integration:

  • certificate_pub.crt
  • private.key

If you don’t have those files anymore, you can create them by following these steps.

Go to https://console.adobe.io/projects. Select your IMS Org, in this example Experience Platform International. Search for the Adobe I/O project you created as part of exercise 3.3.2 - Setup your Adobe I/O Project, which should be named Platform API - ldap and click to open your project.

ETL

Click to open Service Account (JWT).

ETL

You’ll then see this.

ETL

Scroll down a bit until you see this:

ETL

You’ll now need to upload a file into your Adobe I/O project. In the following steps, you’ll create the file you need.

NOTE

If you’re using Microsoft Windows, make sure to have OpenSSL installed on your computer before continuing. You can find instructions to install OpenSSL here

Create a new folder on your desktop with the name Certificate.

ETL

Open a terminal window and navigate to the folder that contains the above certificate files: cd desktop/Certificate

ETL

Execute the following command: openssl req -x509 -sha256 -nodes -days 365 -newkey rsa:2048 -keyout private.pem -out certificate_pub.crt

Fill out the prompts as indicated in the screenshot.

ETL

If you now have a look at your Certificate folder, you’ll see these 2 files:

  • private.pem
  • certificate_pub.crt

ETL

Next, execute the following command: openssl pkcs8 -topk8 -inform PEM -outform DER -in private.pem -nocrypt > private.der

ETL

If you now have a look at your Certificate folder, you’ll see these 3 files:

  • private.pem
  • certificate_pub.crt
  • private.der

ETL

As an output of the above command, you got a new file, with the name private.der. You’ll need this file in the next step.

Before you can continue, you still need to upload the file certificate_pub.crt into your Adobe I/O project. Go back to your Adobe I/O project, and click the Add a public key button.

ETL

In the popup that opens, navigate to your Certificate folder and select the file certificate_pub.crt. Click Open.

ETL

You’ll then see this.

ETL

Finally, you’ll be back here.

ETL

You now have everything to continue with the next step.

5.1.4.2 Upload the file private.der onto your Runtime Environment

The file private.der needs to be copied onto the Runtime Environment server you created in the previous step. Copy that file from your local desktop folder Certificate to your Runtime Environment into the folder C:\Program Files\Informatica Cloud Secure Agent

ETL

Once your certificate file private.der is uploaded in the above mentioned directory, you can continue with the next exercise.

5.1.4.3 Configure your Adobe Experience Platform Connector

Go back to your Informatica instance and go to Connections.

ETL

Click New Connection.

ETL

Fill out or select the following values:

  • Connection Name: ldap - AEP (replace ldap by your own ldap)
  • Type: Adobe Experience Platform (Informatica Cloud Services)
  • Runtime Environment: You have to select the local Runtime Environment which you created in a previous step) (DON’T select Informatica Cloud Hosted Agent)
  • Authentication: Connection

ETL

In the next fields, you need to fill out the following values:

  • Environment: prod
  • Private Key Path: file:///Program Files/Informatica Cloud Secure Agent/private.der
  • Client Id:
  • Client Secret:
  • Account Id:
  • IMS Org:
  • Sandbox Name:

You can retrieve the values for Client Id, Client Secret, Account Id, IMS Org from your Adobe I/O project. Sandbox Name should be --aepSandboxId--.

ETL

You should now have this:

ETL

Finally, click Test Connection to verify if all your details are correct. You should receive a notification that says The test for this connection was successful.

ETL

Click Save to save your connection setup.

You can now use the integration between Informatica and Adobe Experience Platform.

Next Step: 5.2 Setup an AWS S3 bucket

Go Back to Module 5

Go Back to All Modules

On this page