Hi there,
Using Informatica 9 on Redhat Linux it was found to be beneficial to restart the Informatica Integration Services on a weekly basis. I wrote this bash script to neatly perform some first pass checks, then restart the services whilst sending notifications out along its merry way.
The script is activated each Sunday primarily via the Linux Crontab scheduler using the following job but an Informatica workflow was also created to allow manual runs for those less inclined towards the command-line.
Hope someone finds it of use out there, and if you do drop me a line to say hi!
Kind Regards,
Richard Walton.
Report Publishing differs from creating a straight out InfoView report in that you create the item as a Publication, much like a magazine, allowing the users the ability to then right click on that report and ‘Subscribe’ or ‘Unsubscribe’ depending on how useful they find it. The next time that report is Scheduled for a run, each subscriber then receives their own copy of the report.
A great concept, and well implemented by BO, the Subscription / Publication feature offers an advanced method of report selection, always ensuring your up to date on whats important without the worry of knowing the underlying data refresh schedule.
New house settling down so the Linux box finally makes it outta the basement:)
Ubuntu 12.04 Precise Pangolin successfully upgraded to, resolving a a good few niggles i ran into with vnc and Unity.
Lets get crackalacking!
Batch – Archive and zip script (.bat)
With the following requirements for a backup script received, the following script was created.
And with a much welcomed move to CentOS now in progress, it will soon be time to rewrite and convert to a Bash script!
Purpose was to periodically archive daily sales/dimension feeds received from the business units as they took up too much space.
Might prove useful to someone looking for something similar in the future, so here it is in all its awkward .bat glory.
Requirements provided:
Oracle 10.2g XE 32bit Ubuntun .deb Installation Notes:
1. As i’m running with a 32bit version of Ubuntu unfortuantley I’ll need to use Oracle 10.2 XE rather than 11 as i’d hoped but ok i can run with that for now.
I’ve already downloaded the lastest files directly from Oracle and uploaded them to my Downloads dir on the server:
http://www.oracle.com/technetwork/database/express-edition/downloads/102xelinsoft-102048.html
File transfer to a remote server gets a bit tricky when hidden behind a few layers of network security. Access to port 20 and 21 is required for FTP and a typical ISP bocks most ports under 1024. A neat trick is to use whats called command line file transfer through the GNU package Lrxsz:
http://ohse.de/uwe/software/lrzsz.html
This means you are able to upload and download files from remote servers via the SSH session, on whatever port you connected on. Also bypassing many of the awkward issues associated with a typical corporate network security system.
Heres how I set this up….
Howto: Reconnect to a lost SSH session
Howto: Reconnect to a lost SSH session
Not having used NIX systems since my World Telecom Labs days back in 2004, this little gem needing bringing back to life
so i wrote a few of the commandes down to help me get started again…
Troubleshooting Perl CPAN Module Spreadsheet on CentOS
Having recently installed a new Linux ETL server for Informatica Powercenter, one of the tasks in my list is to port some Perl scripts from the old Windows box.
Having not had the opportunity to work with Perl in the past, always favouring PHP, or some other method, its been an extremly rewarding experience and boy do i regret not having done it sooner!
DIT7000 DIFRNCE Review
I’ve had this device now for a few months and it has kept me entertained. The kids loved playing Angry Birds on the touch screen, and it was great to read the beeb whilst out and about. Battery life was actually alright too lasting long enough to watch a movie on the go.
However i was unable to get Skype working and quite a few other applications also….
Row level security within Business objects allows you to filter the returned data based on a users login from within the Universe.
This can be particulary useful for limiting the returned data to a user or set of country users rather than creating views or storing in seperate tables etc.
In this example i’ll apply a Business Unit key restriction to the SQL WHERE clause for the given table.