Connecting to Informatica Cloud in Domo

Installing the Informatica Cloud Secure Agent

1. Log into Informatica Cloud using the username required and password required.

2. Select Configure > Runtime Environments.
   
   

3. Click Download Secure Agent.

4. Select the platform for the Secure Agent then click Download.

5. 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.

1. Log into Informatica Cloud using the username required and password required.

2. Select Configure > Connections.

3. Click New.
   This opens the New Connection dialog.

4. Fill in the required fields, making sure to select Domo(Domo) for the Type.
   
   

5. Click Test to ensure the credentials are valid.

6. Click OK to save.

7. Select Task Wizards > Data Synchronization.

8. Click New.
   
   

9. 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.)
   
   

10. Click Next.

11. In the Source tab of the Data Synchronization Task Wizard, enter information as follows:

12. 1. For Connection, select the connection you created in step 4.

    2. For Source Type, select Single.

    3. For Source Object, select the datasets from the available datasets.
       
       After you select a dataset, a preview of the dataset appears.
       
       

13. Click Next.

14. Navigate to the Target tab of the Data Synchronization Task Wizard.
    
    

15. In the Target tab, enter information as follows:

    1. For Connection, select the previously created connection from step 4 or create a new connection.

    2. For Target Object, do one of the following:

       1. 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.
          
          

       2. Select an existing target object.

16. Click Next.

17. In the Data Filters tab of the Data Synchronization Task Wizard, select the row limit you want to process.

18. Click Next.

19. In the Field Mapping tab of the Data Synchronization Task Wizard, map the primary fields of the source object to the target object.
    
    

20. Click Next.

21. Click Save and Run.
    
    

22. Click OK at the prompt.

23. Navigate to Monitor > Activity Log to check the "Status" and "Success Rows" of the Data Synchronization Task.