CDP July2024 GettingStarted en
CDP July2024 GettingStarted en
July 2024
Getting Started
Informatica Cloud Data Profiling Getting Started
July 2024
July 2024
© Copyright Informatica LLC 2016, 2024
This software and documentation are provided only under a separate license agreement containing restrictions on use and disclosure. No part of this document may be
reproduced or transmitted in any form, by any means (electronic, photocopying, recording or otherwise) without prior consent of Informatica LLC.
Informatica and the Informatica logo are trademarks or registered trademarks of Informatica LLC in the United States and many jurisdictions throughout the world. A
current list of Informatica trademarks is available on the web at https://www.informatica.com/trademarks.html. Other company and product names may be trade
names or trademarks of their respective owners.
Subject to your opt-out rights, the software will automatically transmit to Informatica in the USA information about the computing and network environment in which the
Software is deployed and the data usage and system statistics of the deployment. This transmission is deemed part of the Services under the Informatica privacy policy
and Informatica will use and otherwise process this information in accordance with the Informatica privacy policy available at
https://www.informatica.com/in/privacy-policy.html. You may disable usage collection in Administrator tool.
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial
computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such,
the use, duplication, disclosure, modification, and adaptation is subject to the restrictions and license terms set forth in the applicable Government contract, and, to the
extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License.
Portions of this software and/or documentation are subject to copyright held by third parties. Required third party notices are included with the product.
The information in this documentation is subject to change without notice. If you find any problems in this documentation, report them to us at
infa_documentation@informatica.com.
Informatica products are warranted according to the terms and conditions of the agreements under which they are provided. INFORMATICA PROVIDES THE
INFORMATION IN THIS DOCUMENT "AS IS" WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING WITHOUT ANY WARRANTIES OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND ANY WARRANTY OR CONDITION OF NON-INFRINGEMENT.
Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
Table of Contents 3
Preface
Refer to Getting Started for information about how to begin using Data Profiling. Getting Started explains how
to configure a runtime environment, create connections to data sources, and begin a project.
Informatica Resources
Informatica provides you with a range of product resources through the Informatica Network and other online
portals. Use the resources to get the most from your Informatica products and solutions and to learn from
other Informatica users and subject matter experts.
Informatica Network
The Informatica Network is the gateway to many resources, including the Informatica Knowledge Base and
Informatica Global Customer Support. To enter the Informatica Network, visit
https://network.informatica.com.
To search the Knowledge Base, visit https://search.informatica.com. If you have questions, comments, or
ideas about the Knowledge Base, contact the Informatica Knowledge Base team at
KB_Feedback@informatica.com.
Informatica Documentation
Use the Informatica Documentation Portal to explore an extensive library of documentation for current and
recent product releases. To explore the Documentation Portal, visit https://docs.informatica.com.
If you have questions, comments, or ideas about the product documentation, contact the Informatica
Documentation team at infa_documentation@informatica.com.
4
Informatica Product Availability Matrices
Product Availability Matrices (PAMs) indicate the versions of the operating systems, databases, and types of
data sources and targets that a product release supports. You can browse the Informatica PAMs at
https://network.informatica.com/community/informatica-network/product-availability-matrices.
Informatica Velocity
Informatica Velocity is a collection of tips and best practices developed by Informatica Professional Services
and based on real-world experiences from hundreds of data management projects. Informatica Velocity
represents the collective knowledge of Informatica consultants who work with organizations around the
world to plan, develop, deploy, and maintain successful data management solutions.
You can find Informatica Velocity resources at http://velocity.informatica.com. If you have questions,
comments, or ideas about Informatica Velocity, contact Informatica Professional Services at
ips@informatica.com.
Informatica Marketplace
The Informatica Marketplace is a forum where you can find solutions that extend and enhance your
Informatica implementations. Leverage any of the hundreds of solutions from Informatica developers and
partners on the Marketplace to improve your productivity and speed up time to implementation on your
projects. You can find the Informatica Marketplace at https://marketplace.informatica.com.
To find online support resources on the Informatica Network, click Contact Support in the Informatica
Intelligent Cloud Services Help menu to go to the Cloud Support page. The Cloud Support page includes
system status information and community discussions. Log in to Informatica Network and click Need Help to
find additional resources and to contact Informatica Global Customer Support through email.
The telephone numbers for Informatica Global Customer Support are available from the Informatica web site
at https://www.informatica.com/services-and-training/support-services/contact-us.html.
Preface 5
Chapter 1
Use a Secure Agent group to access data on-premises. A Secure Agent group contains one or more Secure
Agents. The agents in a group run within your network or in a cloud computing services environment such as
Amazon Web Services or Microsoft Azure.
To create a Secure Agent group, download and install the Secure Agent. You can install one Secure Agent on
each physical or virtual machine. Each agent that you install is added to its own group by default. Based on
your license, you can add multiple agents to a group to balance workloads and improve scalability.
6
Chapter 2
System Requirements
Use one of the following browsers when you work with Data Profiling:
For more information about system requirements, see the Product Availability Matrix (PAM) for Data
Profiling. The PAM indicates the versions of operating systems, databases, and other types of data sources
and targets that a product release supports. You can access the PAM on Informatica Network at
https://network.informatica.com/community/informatica-network/product-availability-matrices/.
Note: Some company security policies restrict the ability of users to enable CORS in a web browser. Before
you update these settings, verify that your company or IT department allows you to change the CORS
settings.
7
3. On the Security tab, click Trusted sites, and then click Sites as shown in the following image:
4. In the Trusted Sites dialog box, add the Informatica Intelligent Cloud Services domain to the zone, and
click Add.
5. Click Close.
8. Click OK.
9. If prompted, confirm that you want to change the settings for the zone.
10. Click OK.
11. Restart Internet Explorer and re-open Informatica Intelligent Cloud Services.
By default, the Secure Agent starts when you start Windows. You can stop and restart the Secure Agent using
the Secure Agent Manager or Windows Services. If you install the Secure Agent on a different volume than
you use to run the installation program, you must start and stop the Secure Agent from Windows Services.
You can also use the Secure Agent Manager to check the Secure Agent status and configure proxy
information. The Secure Agent works with BASIC, DIGEST, and NTLMv2 proxy authentication.
You can launch the Secure Agent Manager from the Start menu or desktop icon. When you close the Secure
Agent Manager, it minimizes to the Windows taskbar notification area for quick access.
When you install a Secure Agent, you perform the following tasks:
Verify the following requirements before you install the Secure Agent on Windows:
• The Secure Agent machine uses a supported operating system. For the list of supported operating
systems for the Secure Agent, see the
Product Availability Matrix (PAM) for Informatica Intelligent Cloud Services on the Knowledge Base.
• The Secure Agent machine has the Microsoft Visual C++ 2015 Redistributable.
• The Secure Agent machine has at least 4 CPU cores, 16 GB RAM, and at least 5 GB of free disk space.
• The Secure Agent machine is on a volume with at least 250GB disk space, with at least 5 GB free space or
three times the size of the Secure Agent installation, whichever is greater.
• The account you use to install the Secure Agent has access to all remote directories that contain flat
source or target files.
12
• No other Secure Agent is installed on the machine. If another Secure Agent is installed on the machine,
uninstall it first.
For more information about Secure Agent requirements, see this article:
https://knowledge.informatica.com/s/article/526096
The Secure Agent uses port 443 (HTTPS) to connect to the internet. Configure your firewall to allow traffic to
pass over port 443.
The allowlists of domains and IP addresses can vary according to your data center, which is also called a
POD (Point of Deployment). You can identify your POD through the URL that appears when you open any
service in Informatica Intelligent Cloud Services. The first few characters of the URL string identify the POD.
For example, if the URL starts with usw3.dm-us.informaticacloud.com, your POD is USW3.
For the allowlists of Informatica Intelligent Cloud Services domains and IP addresses for different PODs, see
Pod Availability and Networking in the documentation portal or click the link at the top of the Runtime
Environments page in Administrator.
For information on the IP address ranges that you need to add to your list of approved IP addresses for AWS,
see this Knowledge Base article on Informatica Network. You can follow this Knowledge Base article for
receiving notifications on updates made to the article.
For information on the IP address ranges that you need to add to your list of approved IP addresses for
Azure, see this Knowledge Base article on Informatica Network. You can follow this Knowledge Base article
for receiving notifications on updates made to the article.
For information on the IP address ranges that you need to add to your list of approved IP addresses for GCP,
see this Knowledge Base article on Informatica Network. You can follow this Knowledge Base article for
receiving notifications on updates made to the article.
When you install a Secure Agent on Windows, the Secure Agent must be part of the local Administrators
group.
You can configure proxy settings in Secure Agent Manager. Configure a login for the Windows Secure Agent
service on Windows.
Note: If you use the Secure Agent for Informatica Cloud Data Wizard, you do not need to configure proxy
settings or a Windows service login for the Secure Agent.
Secure Agent registration requires an install token. To get the install token, copy the token when you
download the agent or use the Generate Install Token option in Administrator. The token expires after 24
hours.
Before you download and install the Secure Agent, verify that no other Secure Agent is installed on the
machine. If any other Secure Agent exists, you must uninstall it.
Tip: To verify the checksum of the Secure Agent installation program, use the agent REST API version 2
resource. For more information about the agent resource, see REST API Reference.
5. If you did not copy the install token when you downloaded the agent, click Generate Install Token on the
Runtime Environments page in Administrator, and copy the token.
Option Description
User Name User name that you use to access Informatica Intelligent Cloud Services.
The Secure Agent Manager displays the status of the Secure Agent. It takes a minute for all of the
services to start.
7. If your organization uses an outgoing proxy server to connect to the internet, enter the proxy server
information.
8. Close the Secure Agent Manager.
The Secure Agent Manager minimizes to the taskbar and continues to run as a service until stopped.
Field Description
Proxy Host Required. Host name of the outgoing proxy server that the Secure Agent uses.
4. Click OK.
The Secure Agent Manager restarts the Secure Agent to apply the settings.
Configure a login for the Secure Agent machine to allow the Secure Agent to access directories to configure
and run tasks. When you configure connections, configure tasks, and run tasks that use flat file or FTP/SFTP
connection types, the Secure Agent might require read and write permissions on the related directories.
You can also use the shell command line to check the Secure Agent status.
When you install a Secure Agent, you perform the following tasks:
• Create a specific user profile to install the Secure Agent with full access to all folders from the Secure
Agent installation directory. Don't install the Secure Agent as the root user.
• You can't install more than one Secure Agent on the same machine under the same user account. Multiple
agents may exist under different user accounts.
• Don't install the Secure Agent on any node within the Informatica domain.
For more information about Secure Agent requirements, see this KB article:
IICS Minimum requirements and best practices when installing Informatica Cloud Secure Agent.
Verify the following requirements before you install the Secure Agent on Linux:
• Verify that the machine uses a supported operating system. For the list of supported operating systems
for the Secure Agent, see the Product Availability Matrix (PAM) for Informatica Intelligent Cloud Services
on the Knowledge Base.
• Verify that the machine has at least 11 GB free disk space.
• The account that you use to install the Secure Agent must have access to all remote directories that
contain flat source or target files.
• If you use PowerCenter, install the Secure Agent using a different user account than the account you used
to install PowerCenter.
Informatica Intelligent Cloud Services and PowerCenter use some common environment variables. If the
environment variables are not set correctly for Informatica Intelligent Cloud Services, your jobs might fail
at run time.
For more information about Secure Agent requirements, see this article:
https://knowledge.informatica.com/s/article/526096
The Secure Agent uses port 443 (HTTPS) to connect to the internet. Configure your firewall to allow traffic to
pass over port 443.
The allowlists of domains and IP addresses can vary according to your data center, which is also called a
POD (Point of Deployment). You can identify your POD through the URL that appears when you open any
service in Informatica Intelligent Cloud Services. The first few characters of the URL string identify the POD.
For example, if the URL starts with usw3.dm-us.informaticacloud.com, your POD is USW3.
For the allowlists of Informatica Intelligent Cloud Services domains and IP addresses for different PODs, see
Pod Availability and Networking in the documentation portal or click the link at the top of the Runtime
Environments page in Administrator.
For information on the IP address ranges that you need to add to your list of approved IP addresses for AWS,
see this Knowledge Base article on Informatica Network. You can follow this Knowledge Base article for
receiving notifications on updates made to the article.
For information on the IP address ranges that you need to add to your list of approved IP addresses for
Azure, see this Knowledge Base article on Informatica Network. You can follow this Knowledge Base article
for receiving notifications on updates made to the article.
For information on the IP address ranges that you need to add to your list of approved IP addresses for GCP,
see this Knowledge Base article on Informatica Network. You can follow this Knowledge Base article for
receiving notifications on updates made to the article.
When you install a Secure Agent on Linux, the Secure Agent must have read/write/execute permissions for
the installation directory.
Secure Agent registration requires an install token. To get the install token, copy the token when you
download the agent or use the Generate Install Token option in Administrator. The token expires after 24
hours.
When you register the agent, it is added to its own Secure Agent group by default. You can add the agent to a
different Secure Agent group.
Before you download and install the Secure Agent, verify that no other Secure Agent is installed on the
machine using the same Linux user account. If there is, you must uninstall it.
Tip: To verify the checksum of the Secure Agent installation program, use the agent REST API version 2
resource. For more information about the agent resource, see REST API Reference.
Option Description
User Name Required. Informatica Intelligent Cloud Services user name of the user installing the Secure
Agent.
Secure Agent Optional. Include when you want to add the agent to an existing Secure Agent group
group name instead. If this option isn’t included in the command, the agent will be in its own Secure
Agent group.
You can check the registration status of a Secure Agent using the following command:
./consoleAgentManager.sh isConfigured
Parameter Description
-Dhttp.proxyUser= Authenticated user name for the HTTP proxy server. This is required if the proxy
server requires authentication.
-Dhttp.proxyPassword= Password for the authenticated user. This is required if the proxy server requires
authentication.
-Dhttps.proxyUser= Authenticated user name for the HTTPS proxy server. This is required if the proxy
server requires authentication.
-Dhttps.proxyPassword= Password for the authenticated user. This is required if the proxy server requires
authentication.
9. Click Save.
The Secure Agent restarts to apply the settings.
Connection Configuration
When you create a data profiling task, you need a connection to the source object. You can create a
connection in Administrator service.
For most connection types, when you configure a connection, you specify the runtime environment for the
connection. The runtime environment must contain an agent that is running when you configure the
connection. For other connection types, you specify the runtime environment when you configure the task.
This section includes general information about setting up a connection. For more information about
connections and for specific information about configuring Flat File and FTP connections, see Connections.
For specific information about other connection types, see the Data Integration Connector topics in the
Connectors section of the Data Integration help.
Configuring a connection
You can configure a connection on the Connections page in Administrator service.
2. Configure the connection-specific properties. For example, if this is a Flat File connection type, enter the
runtime environment to be used with the connection, the directory where the flat file is stored, the date
21
format for date fields in the flat file, and the code page of the system that hosts the flat file. The
following image shows the property fields for a flat file connection:
3. To test the connection, click Test. The results of the test display on the page, as shown in the following
image:
When you search for an object, the Select Object dialog box displays the first 200 objects available for the
connection. You can select one of the objects or you can enter a search string. To begin a search, click
Search or press Enter.
A search returns a maximum of 200 objects. If your search returns 200 objects without displaying the object
that you want to use, enter a more specific search string.
Databases Name
Project Setup
Create projects and project folders on the Explore page to organize your assets. After you have set up the
runtime environment and connections that are required for a project, you can create the assets for the
project.
To create a project, go to the Explore page and select to explore by projects and folders, and then click New
Project.
To create a project folder, go to the Explore page and open the project, and then click New Folder.
24
You can create one level of folders in a project. You cannot create folders within folders.
For more information about working with projects, see Asset Management.
Creating assets
You can create data profiling tasks in Data Profiling. You can create and run a data profiling task on a data
source to determine the quality of data and understand the completeness, conformity, and consistency of
data.
To create a data profiling task, click New and then select Data Profiling Task.
For more information about creating a data profiling task, see Data Profiling.
Creating assets 25
Chapter 6
Note: If you use SAML to sign on to Informatica Intelligent Cloud Services and your organization
administrator has enabled SAML group and role mapping on the SAML Setup page in Administrator, you can
only update the time zone. The other attributes are updated directly from your enterprise directory each time
you log into Informatica Intelligent Cloud Services.
1. Click the User icon in the top right corner of the Informatica Intelligent Cloud Services window and then
select Profile.
2. On the Profile page, add or edit personal information such as your name, job title, phone number, and
time zone.
3. To update your email address, click Update Email.
Informatica Intelligent Cloud Services sends a verification email to your new email address. The email
contains a link that is valid for 24 hours. When you click the link in the email, the new address is verified,
and it appears in your profile. If the link expires, you can resend the verification email.
4. Optionally, change your password or security question.
5. Click Save.
26
Chapter 7
Switching to a different
organization
If you are an administrator in a parent organization or a user in a parent organization that has privileges to
view sub-organizations, you can switch among organizations. You do not have to log out and log back in to
Informatica Intelligent Cloud Services.
Note: If you switch from a parent organization to a sub-organization, you can't perform the following
operations in the sub-organization:
u From the Organization menu in the upper right corner, select the organization that you want to view.
27
Index
A I
allowlist Informatica Global Customer Support
Secure Agent domains 13, 17 contact information 5
Secure Agent IP addresses 13, 17 Internet Explorer 11
assets requirements 7
creating 25
L
B Linux
browser configuring proxy settings 19
requirements 7 lookups
searching in a task wizard 22
C
connections
O
configuring properties 21 object search
creating 21 in a task wizard 22
testing 21 organizations
creating switching to another organization 27
assets 25
folders 24
projects 24
P
passwords
D POD
changing 26
E projects
creating 24
email addresses creating folders 24
for notification 26 proxy settings
configuring on Linux 19
configuring on Windows 15
F
firewall
configuration 13, 17
R
folders requirements
creating 24 browser 7
Internet Explorer 11 7
Product Availability Matrix 7
S
search
for objects for a task wizard 22
28
Secure Agent groups system requirements 7
definition 6
Secure Agent Manager
launching 12
Secure Agents
T
communication port 13, 17 targets
configuring a Windows service login 15 searching in a task wizard 22
definition 6 time zones
domains allowlist 13, 17 changing user profile 26
installing on Linux 18
installing on Windows 14
IP address allowlist 13, 17
permissions on Linux 18
U
permissions on Windows 13 user profiles
registering on Linux 18 editing 26
registering on Windows 14
requirements on Linux 16
requirements on Windows 12
starting on Windows 12
W
security questions Windows
editing 26 configuring proxy settings 15
sources Windows service
searching in a task wizard 22 configuring Secure Agent login 15
sub-organizations
switching to another organization 27
Index 29