Learning BI

This python script lists out users , email and status from Informatica. You need to replace your username, password and informatica url. import requests import json import sys import datetime import smtplib, ssl from email.mime.base import MIMEBase from email.mime.text import MIMEText from email.mime.multipart import MIMEMultipart filename="userslist.txt" username = "" password = "" current_timestamp = datetime.datetime.utcnow().strftime('%Y-%m-%d %H:%M:%S') with open(filename, 'w') as f:   f.write(current_timestamp+'\n') username = username password = password url = "https://dm-us.informaticacloud.com/saas/public/core/v3/login" payload = json.dumps({   "username": username,   "password": password }) headers = {   'Content-Type': 'application/json',   'Accept': 'application/json' } response = requests.request("POST", url, headers=headers, data=payload) login=jso...

 I have written a  python script to pull list of groups and associated users in ICCS using API.  In script you need to replace url and Id and password that has admin access in your environment.  Here is the script import requests import json sid= '' url = "https:Infaurl/api/v2/user/login" payload = json.dumps({ "username" : "Adminuser" , "password" : "Adminpassword" }) headers = { 'Content-Type' : 'application/json' , 'Accept' : 'application/json' } response = requests.request( "POST" , url, headers =headers, data =payload) print (response.text) login=json.loads(response.text) for i in login: if i== "icSessionId" : sid=login[i] #print(sid) groupurl = "https://infaurl/public/core/v3/userGroups?limit=50" payload = {} grpheaders = { 'INFA-SESSION-ID' : sid } groupresponse = requests.request( "GET" , groupurl, headers =grphe...

 Script to get Disabled users in IICS   This script user Informatica Cloud APIs to get user details and pulls disabled and locked users even if SAML is integrated. You need to replace username, password, send email, receiver email and SMPT server so that it generated disabled users list for that org in the same path from where you are running the script.  import requests import json import sys import datetime import smtplib, ssl from email.mime.base import MIMEBase from email.mime.text import MIMEText from email.mime.multipart import MIMEMultipart filename= "userslist.txt" username = "username" password = "Password" current_timestamp = datetime.datetime.utcnow().strftime( '%Y-%m-%d %H:%M:%S' ) with open (filename, 'w' ) as f: f.write(current_timestamp+ ' \n ' ) username = username password = password url = "https://dm-us.informaticacloud.com/saas/public/core/v3/login" payload = json.dumps({ "username" : user...

When Domain database password is changed from the database side, it needs to be updated in the nodemeta.xml file to start the Informatica services successfully. To update the domain database password, do the following: Backup nodemata.xml from INFA_HOME/isp/config. Go to the INFA_HOME/isp/bin directory and run following command: infasetup.sh updategatewaynode -dp new password     (for UNIX)infasetup.bat updategatewaynode -dp new password    (for WINDOWS)        3. Start the Informatica services. After Informatica Services are started and Informatica Administrator is up, the password for the PowerCenter Repository Service can be updated by editing the database properties of the repository in Admin console.

How to take Informatica Repository Backup  and restore it. Informatica Repository backup can be taken in 2 ways Admin Console pmrep command Using Admin Console Login to admin console. Select Repository service Select Backup contents under Actions menu to take backup of repository contents. Provide repository service username, password. provide a name for the backup that will create a backup file with .rep extension. the backup will be generally stored to infa_shared backup folder. Using pmrep command pmrep connect -r <repository_name> -d <domain_name> -n <user_name> -x <password> pmrep backup -o <output_file_name> [-d <description>] [-f (overwrite existing output file)] [-b (skip workflow and session logs)]  [-j (skip deploy group history)] [-q (skip MX data)] [-v (skip task statistics)] Restore Backup: Using pmrep command To restore a repository backup, it is to be ensured that the repository database ...