Recent Informatica Posts from Tech Monger

Amazon Redshift ODBC Connection Linux

2021-04-30T17:06:00.744922Z

In this tutorial, we will download & Install ODBC driver for the Amazon Redshift Database in Redhat Linux. We will make ODBC entry which will help us connect to the AWS Redshift.

Postgres ODBC with Mutual SSL in Informatica

2020-11-02T17:50:04.895595Z

Encryption has become security norm and communicating with databases on insecure network should not be an exception to this norm. In this tutorial we will learn how to connect to postgres database using ODBC connection which is configured to use 2 way SSL connection.

Denodo VDP ODBC Driver Installation for Informatica

2020-11-02T17:50:30.830075Z

In this article we will learn to install ODBC Driver for Denodo VDP database. We will use installed ODBC driver to establish connectivity between Informatica Powercenter Clients and Denodo Server. You can also use postgres odbc drivers to connect to the regular denodo database.

Informatica Postgres Connection Issues and Solution

2020-11-02T17:50:48.726545Z

If you are trying to connect postgres database from informatica using ODBC entry then you might face issues with odbc connection details. Below we will discuss common pitfalls and fixes.

Start and Stop Informatica Services From Command Line

2018-12-07T20:58:11.704294Z

Often as an Informatica Administrator you require to restart specific service in the informatica domain. You can do it from user interface by using an Admin Console; However if you want to write script or you prefer command line over GUI then you can use informatica infacmd command line tool. Below we will learn how to use infacmd's EnableService and DisableService command to start and stop the services in informatica domain with the help of Example.

INFACMD Ping Command in Informatica with Examples

2018-10-20T08:00:18.627690Z

Monitoring services uptime is essential for all applications and informatica is not an exception to it. Informatica has many individual components such as Domain, Services, Node etc which requires monitoring. Informatica provides infacmd command line API which has command ping to check the response of individual components. We will leverage this capability and perform monitoring checks with help of example. Before proceeding with ping command we recommend you to get basic overview of infacmd utility.

PMCMD PingService Examples - Informatica Integration Service

2018-10-24T17:36:10.751604Z

If you have informatica domain running then it is important to have an uptime monitoring mechanism for the services running under that domain. Integration service is one of the most utilized service for ETL. So it is important to configure an alert if integration service goes down. In this tutorial we will make use of PMCMD pingservice command to check status of an integration service with example.

Extract Informatica Session Log From Command Line

2018-12-07T20:55:18.797299Z

If you want access session log of recent workflow run from machine which is not part of informatica domain then you should use infacmd GetSessionLog command to extract logs. This command can be executed as standalone program or can be embedded in script to automate work. We will learn about this command with the help of examples.

Export Informatica Workflow Log From Command Line using INFACMD

2018-12-07T20:54:50.267543Z

If you want to access log file of recent workflow run from repository using command line or script then you can make use of informatica's command line utility called infacmd just like pmrep and pmcmd. Infacmd supports command GetWorkflowLog which allows you to export workflow logs from repository. This is useful especially when you want to download logs from outside machine which is not part of information domain. In this article we will demonstrate this command with help of example.

Infacmd Connection Command in Informatica with Example

2018-09-04T17:58:18.882523Z

Informatica provides infacmd command line utility to perform various tasks from command line. Using infacmd you can write scripts to automate your regular tasks. To use any of the infacmd command you need to provide user credentials for the domain and repository.

Run Parallel Scripts with PMREP in Informatica

2018-07-18T19:00:43.565132Z

If you want to run simultaneous scripts which make use of pmrep connect then you would find that default connect command would fail or will not behave correctly. Learn how to avoid pmrep connection collision using environment variable INFA_REPCNX_INFO.