- August 8, 2024
- Posted by: Sahana Ishwarya
- Category: Informatica
Introduction
In today’s data-driven world, the ability to seamlessly retrieve and manage data is paramount. Informatica Intelligent Data Management Cloud (IDMC) is a robust platform offering powerful data integration and management tools. One such tool is Cloud Application Integration (CAI), which facilitates efficient data processes. This blog provides a step-by-step guide on retrieving Cloud Data Governance and Catalog (CDGC) asset details using CAI.
Steps to follow
1. Setting Up the Source Connection
To begin, we need to establish a source connection in CAI, which involves creating multiple actions to interact with the API endpoints and retrieve necessary tokens and data.
Creating Actions:
Action 1: GET Session ID
The initial step is to obtain a session ID, which is the gateway to further data access.
Inputs: Supply the username and password required for authentication.
Binding: Use the public API URL for the login request, employing a POST request.
Output: Extract the session ID from the XML response.
To determine which POD an Informatica Cloud Org is connected to, log in to Informatica Cloud and check the URL on the landing page.
Note: Point of Deployment (POD) refers to the deployment environment or data center where your Informatica Cloud Org is hosted. Each pod represents a specific geographical location and infrastructure setup used to host and run your Informatica services.
This session ID is crucial as it authenticates subsequent API requests.
Action 2: GET JWT Token
The next step is to retrieve a JWT token, which is essential for secure API interactions.
Inputs: Utilize the session ID obtained from the first action.
Binding: Provide the API URL to request the JWT token using a POST request.
Headers: Include cookies and IDS session with the session ID, and set `ACCEPT` and `CONTENT-TYPE` to `application/json`.
Output: Extract the JWT token from the XML response.
The JWT token is a security measure, ensuring that the API requests are authorized.
Action 3: GET Core Asset Details
Finally, we retrieve the core asset details, which include metadata and hierarchy information.
Inputs: Input the JWT token and the asset ID.
Binding: Use the Search API – Asset Details API to request core asset details through a GET request.
- /data360/search/v1/assets/{id}
Headers: Pass the bearer token (JWT token), setting `ACCEPT` and `CONTENT-TYPE` to `application/json`.
Output: Extract the metadata details from the XML response.
This action provides comprehensive details about the specified asset, crucial for data governance and analysis.
2. Creating an App Connection
Next, we establish an app connection to ensure a smooth data retrieval process. This involves configuring the type as a source connection that we created in the earlier step.
By setting up the app connection correctly, we ensure that our process can retrieve the data efficiently.
3. Building the Process
With the source and app connections in place, we now build the process to orchestrate the data retrieval tasks.
Start Step:
Inputs and Outputs: Define the necessary input and output fields for the process. This step ensures that all required data is available and properly formatted for subsequent steps.
Service Steps:
Service 1: GET Session ID
Utilize the first action to obtain the session ID.
Service 2: GET JWT Token
Use the session ID to retrieve the JWT token.
Service 3: GET Asset Details
Provide the JWT token and asset ID to obtain core asset details.
Running the Process
After configuring the process, the final step is execution. When the process runs, it performs the following tasks sequentially:
1. Authenticate the user by obtaining a session ID.
2. Secures API interactions by retrieving a JWT token.
3. Retrieves detailed asset information using the JWT token and asset ID.
This structured approach ensures that the data retrieval process is both efficient and reliable, providing comprehensive asset details necessary for effective data management and governance.
Conclusion
By following this detailed guide, you can leverage the power of CAI in IDMC to seamlessly retrieve and manage CDGC asset details. This process not only enhances data governance but also streamlines data integration tasks, making your data workflows more efficient and robust.