I’ve had difficult time to find “vanilla” list of directories, so storing here as a reference. Informatica PowerCenter 10.0.
Informatica PowerCenter 10 default list of directories in infa_shared
Kadangi esu turėjęs daug ir dažnai komandiruočių, susigalvojau sistemą kaip jas sekti. Kelis kartus labai pasiteisino, kai net po 2 metų, teko pateikti duomenis auditui ar mokesčiams.
Yra dvi dalys: Excel failas ir katalogai. Pradėsiu nuo katalogų – reikia susikurti dviejų lygių katalogus. Pirmas pagal metus, antras su pirmos komandiruotės dienos data.
Excelyje suvesdavau visą informaciją, kuri padėtų pilnai atsekti, kur kada važiavau, kokia kaina ir t.t. Yra šiek tiek automatizacijos (geltonai nudažyti stulpeliai), kuri padeda greičiau suregistruoti įvairius prašymus darbovietės sistemose. Dažniausiai tenka registruoti du kartus – prieš kelionę ir grįžus.
Below the code example how to get date format as ISO8601. First example is current time zone. Second example is valid if your database is actually in UTC time zone.
SELECT to_char(SYSTIMESTAMP, 'YYYY-MM-DD"T"HH24:MI:SS.FF6TZH:TZM') AS ISO8601 FROM dual;
SELECT to_char(SYSTIMESTAMP, 'YYYY-MM-DD"T"HH24:MI:SS.FF6"Z"') AS ISO8601_UTC_format FROM dual;
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
Incident Management Console
https://[domain]/arsys/forms/spm-app-prd/HPD:Incident+Management+Console
Change Management Console
https://[domain]/arsys/forms/spm5-prd/CHG:Change%20Management%20Console
Work Order Console
http://[domain]/arsys/forms/spm-app-prd/WOI:WorkOrderConsole
Approval Console
https://[domain]/arsys/forms/spm-app-prd/Approval+Central/Default+Administrator+View/?cacheid=8ba20aad
I will share my list of tools and how to setup on Windows 7. This page is under constant change and reformatting.
Table of Contents
Windows environment variable editor Rapid Environment Editor portable
Windows uninstaller Revo Uninstaller Portable
Archiver 7-Zip
Total Commander – windows file manager, FTP client and etc. Trial version, not allowed to use in commercial environment.
Free Download Manager
KeePass – Password manager
IrfanView – Image viewer and editor. Not allowed to use in commercial environment. Free alternative to use at work is JPEGView.
Agent Ransack/File Locator Lite – my favorite tool to search for files and file contents, especially for network drivers on Windows machines in corporate environments. Lite version allowed for commercial use.
I used this blog to download fonts.
Text Editor – Notepad++, Atom, Sublime
CSV Editor – CSVed
XML Editor – XMLSpy (paid)
It enables Linux command line (shell or bash) on Windows. Very convenient if whole ETL platform, such as Informatica, Oracle DB is deployed on Linux, but developer machines are running Windows.
Packages I have installed:
Command line call to install predefined packages from the list above:
setup-x86.exe --no-desktop --download --local-package-dir="C:\cygwin" --packages="lynx,wget,curl,rsync,python3,python3-setuptools,bzip2,tar,gzip,bash-completion,vim,vim-common,tmux,git,diffutils,openssh,ca-certificates,dos2unix,chere,libxml2"
Other useful links about Cygwin:
Copying and sharing paths to files in local folders and network drives – Path Copy Copy
Allows copying Unix path format in Windows.
Set and Unset as Read-only to File and Folder Context Menu
Categories list I changed font:
WinMerge is an Open Source differencing and merging tool for Windows. WinMerge can compare both folders and files, presenting differences in a visual text format that is easy to understand and handle.
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.
Workflow scheduling status empty in the Workflow Monitor
And the worfklow schedule is defined as well.
Workflow schedule defined in Workflow Designer
The solution is that the workflow does not have Integration Service assigned. Once the service is assigned, it becomes Scheduled.
Assign Integration Service to the workflow
Now the status is correct – Scheduled
Workflow scheduling status “Scheduled” in the Workflow Monitor
Three options to get schema prefix in DDL SQL scripts generated in ERwin.
Erwin main menu Model -> Model Properties -> Set Default Owners…
Open Physical view in the model
Right click on the table “Table Properties…” to open Oracle Table Editor. There is a column “Owner”. Press F2 and type in the name.
In physical view open Forward Engineering dialog box.
At the bottom there is “Owner Override…” button.
Client Exchange Navigator and plugins for Power Center Designer to import DB2 sources.
Download setup from defined location and extract to your location. Run as Administrator install.bat
Click Next
Enter licence. Get it from your colleague.
Accept default path. Click Next.
Review installation summary. Click Install.
Wait for installation complete. Click Done.
Restart Windows.
After restart, configure file dbmover.cfg file in these locations:
Verify if you can import Power Exchange source in the Designer.
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 Integration Hub Power Center Client 10.1.0
All Power Center client tools must be closed. Even better restart PC before installation.
In general these steps need to be completed:
Installation screens are at the bottom of the post. Main screen is this one to enable only one option for plug-in.
After installation Power Center Designer might crash as described here PowerCenter Designer Client crashes while opening mapping having DIH/DX transformation in PowerCenter 10.1
Download the patch and unzip the patch to DIH installtion directory. In my case to “C:\Informatica\DIH\DataIntegrationHub\powercenter”. Now it looks like this
Open the folder plugin101 and edit the file “DXPluginWow6432Node.reg” with text editor. As I’m using Informatica and DIH version 10.1, I have to edit last line in the file by adding the path to folder “plugin101”. Don’t forget double slash in the path
Before change [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Informatica\PowerMart Client Tools\10.1.0\Plugins\Informatica]
“DX”=”$DX_HOME$\\powercenter\\plugin100\\DXPlugin.dll”
After change [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Informatica\PowerMart Client Tools\10.1.0\Plugins\Informatica]
“DX”=”C:\\Informatica\\DIH\\DataIntegrationHub\\powercenter\\plugin100\\DXPlugin.dll”
I think even the patch has a bug left, so you need to update the version number in the path to point to correct folder holding DLL file. Instead of pointing to version 10.0, we change it to 10.1
Before
change [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Informatica\PowerMart Client Tools\10.1.0\Plugins\Informatica]
“DX”=”C:\\Informatica\\DIH\\DataIntegrationHub\\powercenter\\plugin100\\DXPlugin.dll”
After
change [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Informatica\PowerMart Client Tools\10.1.0\Plugins\Informatica]
“DX”=”C:\\Informatica\\DIH\\DataIntegrationHub\\powercenter\\plugin101\\DXPlugin.dll”
After finished editing the Windows registry file, double click on it to add entries to Windows registry and register DIH extensions with Power Center Mapping Designer. Click Yes and OK. More relevant information at How To: Register DataExchange/Data Integration Hub plugin in powercenter?
Start Power Center Designer and you will see Advanced Transformation Toolbar with new DIH transformations. However they will be disabled.
Open repository used by Data Integration Hub and open mapping designer. The transformations become active. Otherwise transformations will be disabled in “regular” Power Center Repository.
Transformations added to the mapping designer canvas.
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.
Power Center library contents for Power Exchange
Power Exchange Navigator library