Direct links to SPM items Here is a list of hyperlink patterns and bolded text parts to create direct link to SPM (BMC Remedy IT SERVICE MANAGEMENT) items. Sorry, I don’t know which version of the software. Change Request https://[your domain]/arsys/forms/spm-app-prd/SHR%3ALandingConsole/Default+Administrator+View/?mode=search&F304255500=CHG%3AInfrastructure+Change&F1000000076=FormOpen&F303647600=SearchTicketWithQual&F304255610=’1000000182’%3D%22CRQ000000243650%22 Incident https://[your domain]/arsys/forms/spm-app-prd/SHR%3ALandingConsole/Default+Administrator+View/?mode=search&F304255500=HPD%3AHelp+Desk&F1000000076=FormOpenNoAppList&F303647600=SearchTicketWithQual&F304255610=%271000000161%27%3D%22INC000001964939%22 Work Order https://[your domain]/arsys/forms/spm-app-prd/SHR%3ALandingConsole/Default+Administrator+View/?mode=search&F304255500=WOI%3AWorkOrder&F1000000076=FormOpenNoAppList&F303647600=SearchTicketWithQual&F304255610=%271000000182%27%3D%22WO0000001757117%22 Problem https://[your domain]/arsys/forms/spm-app-prd/SHR%3ALandingConsole/Default+Administrator+View/?mode=search&F304255500=PBM%3AProblem+Investigation&F1000000076=FormOpenNoAppList&F303647600=SearchTicketWithQual&F304255610=%271000000232%27%3D%22PBI000000050210%22 Direct links to the consoles Incident Management […]
Continue ReadingBlog
Software Development Tools on Windows for ETL Developer
I’m sharing my list of favorite tools for efficient developer work. This page is under constant change and reformatting. Utilities Text Editors Notepad++ – I’m using for quick read/edit tasks, as it starts very fast. Visual Studio Code – for more serious development of code, scripts. Recommended extensions: GitLens, Git History, PowerShell CSV Editor – CSVed XML […]
Continue Reading
Informatica Workflow is not Getting Scheduled
I just learned small detail, that even if you define a schedule in the Informatica Power Center Designer, it is not scheduled. You can check scheduling status in the Informatica Power Center Workflow Monitor. See – the status is empty. And the worfklow schedule is defined as well. The solution is that the workflow does […]
Continue ReadingERwin How to Set Owner (Schema Prefix in Oracle Database)
Three options to get schema prefix in DDL SQL scripts generated in ERwin. 1. Global Setting Erwin main menu Model -> Model Properties -> Set Default Owners… 2. Local Override in the Model Open Physical view in the model Right click on the table “Table Properties…” to open Oracle Table Editor. There is a column […]
Continue ReadingInstallation of Power Exchange Client Tools
Client Exchange Navigator and plugins for Power Center Designer to import DB2 sources. Prerequisites You must and user account on the mainframe. Close all Informatica Power Center client tools: Designer, Workflow Manager and etc. Installation Download setup from defined location and extract to your location. Run as Administrator install.bat Click Next Enter licence. Get it from […]
Continue ReadingInstallation of Data Integration Hub Client Plug-in for Power Center 10.1
This post describes how to install Data Integration Hub client plug-in for Power Center Designer version 10.1. After installation you will be able to create custom mappings and manipulate Data Integration Hub processes by using Data Integration Hub API. Version of Power Center Client Tools and Data IntegrationHub (DIH) must match. In my case both Data […]
Continue ReadingPower Exchange Documentation from Informatica
Apparently Power Exchange help topics in the Power Center library and in the Power Exchange Navigator library are different. Below images prove that and you need to read both sources to learn Power Exchange better.
Continue ReadingImport from Power Exchange source error
You have successfully installed Power Center Client tools and Power Exchange Navigator, but still receive below error. You get it when you choose Import from Power Exchange source in the Mapping Designer. Try to fully restart your computer. It helped me. Designer Error occurred loading library [dtIscIi32.dII]. System error encountered is 126. Error text is […]
Continue ReadingInformatica Power Center Server Licence Does Not Allow Self-Training Installs
Question: I was looking for answer to this scenario: Can I install Informatica Server (power center server) on my machine in the virtual box for my personal training or prototyping purposes? If it’s allowed, can I use existing XXX Company license key? Answer from Informatica: Hello, unfortunately, this is not possible.
Continue ReadingFree Ebook DevOps For Dummies
IBM is giving a free ebook “DevOps For Dummies” written by Sanjeev Sharma. Download the eBook: http://ibm.co/devopsfordummies The youtube channel playlist of the author is IBM DevOps IBM home page for DevOps
Continue Reading