Connecting to Informatica Cloud in Domo
Installing the Informatica Cloud Secure Agent
-
Log into Informatica Cloud using the username required and password required.
-
Select Configure > Runtime Environments.
-
Click Download Secure Agent.
-
Select the platform for the Secure Agent then click Download.
-
Install the Secure Agent after the download has completed.
Connecting to Informatica Cloud
Follow the steps in this article to connect to Informatica Cloud data in Domo.
-
Log into Informatica Cloud using the username required and password required.
-
Select Configure > Connections.
-
Click New.
This opens the New Connection dialog. -
Fill in the required fields, making sure to select Domo(Domo) for the Type.
-
Click Test to ensure the credentials are valid.
-
Click OK to save.
-
Select Task Wizards > Data Synchronization.
-
Click New.
-
In the Definition tab of the Data Synchronization Task Wizard, fill in the Task Name, Description, and Task Operation. (Domo only support the Insert operation for the task operation.)
-
Click Next.
-
In the Source tab of the Data Synchronization Task Wizard, enter information as follows:
-
-
For Connection, select the connection you created in step 4.
-
For Source Type, select Single.
-
For Source Object, select the datasets from the available datasets.
After you select a dataset, a preview of the dataset appears.
-
-
Click Next.
-
Navigate to the Target tab of the Data Synchronization Task Wizard.
-
In the Target tab, enter information as follows:
-
For Connection, select the previously created connection from step 4 or create a new connection.
-
For Target Object, do one of the following:
-
Create a new target object in the Domo environment by providing the target object name and selecting the target fields, then click OK.
This creates a new DataSet in Domo.
-
Select an existing target object.
-
-
-
Click Next.
-
In the Data Filters tab of the Data Synchronization Task Wizard, select the row limit you want to process.
-
Click Next.
-
In the Field Mapping tab of the Data Synchronization Task Wizard, map the primary fields of the source object to the target object.
-
Click Next.
-
Click Save and Run.
-
Click OK at the prompt.
-
Navigate to Monitor > Activity Log to check the "Status" and "Success Rows" of the Data Synchronization Task.