Informatica Cloud Naming Conventions and Standards

The most basic and fundamental component for the successful execution of an IT Project are Naming Conventions and Standards. It is often overlooked because everyone follows their own way of naming logic irrespective of whether it makes sense to others or not.


The application enforcement of naming standards establishes consistency, improves readability, facilitates smooth migrations, and provides friendly development environment.


Thus, it is important to choose a good naming standard and convention and adhere to it to ensure that the code can be easily understood.


Please find below some suggested naming conventions for Informatica Cloud objects.           

Informatica Cloud   Object	Suggested Naming   Conventions	Example
Secure Agent	<Secure Agent Type>_<Host Name>_<Project Name>	For Windows Secure Agent: “WIN_Machine01_Marketing_Integration” For Linux/Unix Secure Agent: “UNIX_Machine01_Marketing_Automation”
Connection
Salesforce	SFDC_<Instance Name>	For Full Sandbox: “SFDC_FullSandbox“ For Production: “SFDC_Prod”
Oracle	Oracle_<Schema Name>	Oracle_Stage
SqlServer	SqlServer_<Database Name>	SqlServer_Prestage
MYSQL	MYSQL_<Database Name>	MYSQL_Datamart
Flat File	FF_<Folder Name>	FF_Migration
ODBC	ODBC_<DSN Name>	ODBC_Zuora
MS Access	MS_Access_<Database Name>	MS_Access_Tutorial
FTP/SFTP	FTP_<Application Name>_<Folder Name>	FTP_Eloqua_Incoming
Web Service	WS_<Application Name>_<Web Service Name>	WS_Jigsaw_GetData
Task	<Source Connection Type>_<Target Connection Type>_<Object Name>_<Operation Type>	SFDC_SqlServer_Contact_INS SFDC_SqlServer_Contact_UPD SFDC_SqlServer_Contact_DEL SFDC_SqlServer_Contact_UPSERT
Task Flow	<Source Type>_<Target Type>_<Operation Type>	SFDC_SqlServer _INS SFDC_SqlServer _UPD SFDC_SqlServer _DEL SFDC_SqlServer _UPSERT
Scheduler	Schedule_<Frequency>	Schedule_Five_Minutes Schedule_Hourly Schedule_Daily
Custom Views
Activity Log	View_<Criteria1_Criteria_2_...Criteria_n>	View_DSS_SFDC_Success (This view will display the activity log of all successful DSS tasks which contain SFDC keyword).
Connection	View_<Criteria1_Criteria_2_...Criteria_n>	View_SFDC_User01 (This view will display all the SFDC type Connections created by User01.)
Task	View_<Criteria1_Criteria_2_...Criteria_n>	View_SFDC_ACCOUNT_User01 (This view will display all the tasks containing the keyword SFDC_ACCOUNT created by User01.)
Task Flow	View_<Criteria1_Criteria_2_...Criteria_n>	View_SFDC_ACCOUNT (This view will display all the task flows containing the keyword SFDC_ACCOUNT.)