Powerpoint ITIL Presentation

I have recently done some research into ITIL including the reading of Foundations of IT Service Management Based on ITIL V3 by Jan Van Bon, Arjen de Jong, and Axel Kolthof.

ITIL is a very broad level topic about IT services and how to approach them.

I did make a brief high level powerpoint presentation on an Introduction to ITIL.

This presentation may be downloaded from Here

It is a basic high level presentation, it is difficult to present the topic without getting lost in the depth and breadth. This presentation just presents a little background and a little overview of the lifecycle phases in Version 3.

Service Oriented Architecture with Java

I recently read “Service Oriented Architecture with Java” by Binildas CA, Malhar Barai, and Vicenzo Caselli. This book, available at http://www.packtpub.com, provides a look at some of the tools in the java world that can be applied to support a Service Oriented Architecture.

There are 6 Chapters in all:

Chapter 1: The Mantra of SOA
This chapter reviews basic tiered architecture, EA and the basic points of benefit of SOA including better integration, business agility, asset re-use, increase ROI

Chapter 2: Web Services and SOA
Practically all current SOA implementations now are built upon web services. XML over the Http protocol is covered. Representational State Transfer(REST) is covered. Main java implementations of web services are introduced including JAX-WS 2, Axis2, Spring-WS, and XFire/CXF 2.0.

Chapter 3 : Web Service Implementations
Code is presented for getting a web service up and running in JAX-WS2, Axis2, Spring-WS, and XFire/CXF 2.0 The coded examples are very easy to follow and can get a developer up and running quickly.

Chapter 4: Data and Services – All Roads Lead to Enterprise Service Bus
This chapter reviews JDO(Java Data Objects) as an alternative to JDBC along with sample code and examples. Service Data Objects(SDO) are covered as a way to abstract data within and SOA. Apache Tuscany DSO is covered with an example. Service Component Architecture(SCA) is described along with a Tuscany SCA java example
Benefits of MOM and ESB are also covered. OpenESB is covered as an open source option for implementing an ESB.

Chapter 5 – Traditional Integration Technology
2 Case Studies are presented showing the advantages of an SOA based architecture over that of EAI.

Chapter 6 – Goals We Can Achieve with SOA
Loose Coupling, Reusability, Seamless Integration, Return on Investment(ROI)

All in all this is a pretty good book. It’s focus is definitely to provide information on a SOA implementation in a java oriented environment. This book covers the basics of the open source options to getting java based web services and infrastructure. I would strongly recommend this book to those trying to do open source SOA implementations in java.

Run .NET Code from a shared drive/directory

Security is an issue whenever running code from an untrusted source like a shared or network drive. It would be nice to be able to put an application on a share drive to run whether it be in C# or VB .NET.

Normally, when you try to run .NET code on a shared network drive you will get an exception like System.Security.Permissions.SecurityPermission .


There is a way to relax the security via the caspol.exe command(For .Net Framework 2.0 "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CasPol.exe -s off").

An application may be launched with one simple batch file as follows:

AllInOne.BAT:
@ECHO OFF

REM Relax security constraints for .NET
START C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CasPol.exe -s off

REM Pause until first command has executed
Set Count=1
:LOOP
Set /A Count=%Count%+1
If %Count% lss 100 GoTo :LOOP

REM Launch .NET application
"""SomeExecutable.exe"""

REM Remove relaxation of security constraints
TASKKILL /im CasPol.exe

@ECHO ON
*****************************

A pause is required to allow caspol to start up before launching the .NET application.

But of course this implementation does meet the requirements of launching the .NET application from the shared location but there are those DOS windows which are open and probably not that desirable.

These can be avoided with 2 BAT files and 2 VBS files as follows. This is just one way of doing it but there are probably better ways out there.

launch.bat (Main file)
****************
@ECHO OFF
REM Main Launch for .NET application on share drive
REM VBS script used so there is not a DOS console opened up

START launchtasks.vbs

@ECHO ON
****************

launchtasks.vbs
****************
On Error Resume Next

CmdLine = """tasks.bat"""
Params = ""
CmdLine = CmdLine & " " & Params

'Launch without window
wscript.echo fShellRun(CmdLine)

Function fShellRun(sCommandStringToExecute)
' This function will accept a string as a DOS command to execute.
' It will then execute the command in a shell, and capture the output into a file.
' That file is then read in and its contents are returned as the value the function returns.
Dim oShellObject, oFileSystemObject, sShellRndTmpFile
Dim oShellOutputFileToRead, iErr
Set oShellObject = CreateObject("Wscript.Shell")
Set oFileSystemObject = CreateObject("Scripting.FileSystemObject")
sShellRndTmpFile = oShellObject.ExpandEnvironmentStrings("%temp%") & oFileSystemObject.GetTempName
On Error Resume Next
oShellObject.Run sCommandStringToExecute & " > " & sShellRndTmpFile, 0, True
iErr = Err.Number
On Error GoTo 0
If iErr <> 0 Then
fShellRun = ""
Exit Function
End If
fShellRun = oFileSystemObject.OpenTextFile(sShellRndTmpFile,1).ReadAll
oFileSystemObject.DeleteFile sShellRndTmpFile, True
End Function
****************

tasks.bat
****************
@ECHO OFF

REM Relax security constraints for .NET
REM Run this in VBS to avoid a DOS WINDOW
START caspol.vbs

REM Pause until first command has executed
Set Count=1
:LOOP
Set /A Count=%Count%+1
If %Count% lss 70 GoTo :LOOP

REM Launch .NET application
"""SomeExecutable.exe"""

REM Remove relaxation of security constraints (The >NUL is to avoid showing the info on the processes terminated)
TASKKILL /im CasPol.exe >NUL

@ECHO OFF
****************


caspol.vbs
****************
On Error Resume Next

'The command below will also depend on the .NET version of the application you are running

CmdLine = """C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CasPol.exe"""
Params = "-s off"
CmdLine = CmdLine & " " & Params

'New way without window
wscript.echo fShellRun(CmdLine)

Function fShellRun(sCommandStringToExecute)
' This function will accept a string as a DOS command to execute.
' It will then execute the command in a shell, and capture the output into a file.
' That file is then read in and its contents are returned as the value the function returns.
Dim oShellObject, oFileSystemObject, sShellRndTmpFile
Dim oShellOutputFileToRead, iErr
Set oShellObject = CreateObject("Wscript.Shell")
Set oFileSystemObject = CreateObject("Scripting.FileSystemObject")
sShellRndTmpFile = oShellObject.ExpandEnvironmentStrings("%temp%") & oFileSystemObject.GetTempName
On Error Resume Next
oShellObject.Run sCommandStringToExecute & " > " & sShellRndTmpFile, 0, True
iErr = Err.Number
On Error GoTo 0
If iErr <> 0 Then
fShellRun = ""
Exit Function
End If
fShellRun = oFileSystemObject.OpenTextFile(sShellRndTmpFile,1).ReadAll
oFileSystemObject.DeleteFile sShellRndTmpFile, True
End Function
****************

ITIL Introduction videos

It has been a while since I have blogged here. My goal is to research a little into ITIL (Information Technology Infrastructure Libary)

I read "Foundations of IT Service Management Based on ITIL V3" a few months back and am trying to group some materials on an introduction to ITIL.

Let me say that up front the ITIL processes and lifecycle is very high level and hard to grasp at an implementation detail. I guess the key is to focus on a small portion of it and grow it out from there.

I found a couple youtube links that I think are easy to listen to.

Synopsis of the ITIL(r) V3 Foundations class:



EMC on ITIL:

EA and Integration Summit

I got back from the first day of the Enterprise Architecture and Integration Summit in Calgary May 12-14th. There were lots of interesting topics, considering of course if Enterprise Architecture, Service Oriented Architecture, ITIL, TOGAF and other methodologies interest you!

I recently finished my Master's Thesis which involved SOA, Zachman and TOGAF and how they can work together. The conference was much more entertaining. The first keynote was John Zachman and he revealed the new Zachman Framework 2 and handed out the new 6 x 6 matrix diagram. Check out http://zachmaninternational.com/2/standards.asp for info on the new framework. It is very similar but they went to work with some linguists to make sure there are "no adjectives" in the matrix. They wanted it to be more rigorous and easier to understand(clearer and "brushed up").

After John Zachman spoke, I had a chat with him and thanked him for his work on the framework. I was able to pose in a picture with him. He seems to be very friendly and no nonsense. Most of his talk was the view of "Architecture is Architecture is Architecture", the instance of the system is not architecture itself.

The funniest moment was when he displayed the IT problems they faced in 1965 and compared them to 2008. They were identical! Also, he showed a slide that showed all of the technologies that did not solve the problems: COBOL, Fortran, mainframe, client server,......, agile programming, web services, .NET, SOA. Technology does not solve these issues. Architecture is important.

Other talks I found interesting were Stan Locke talking about the new Zachman Framework, Bill Dupley spoke of HP's harnessing of ITIL for better management. It was pretty interesting and looking forward to tomorrow's session as well.

Enterprise Architecture Framework Applications towards SOA

I am in the final stages of completing my Thesis requirement for my MSc. in Information Systems at Athabasca University.

I am working through the final signoff but the latest version may be downloaded Enterprise Architecture Framework Applications Towards Service Oriented Architecture

ABSTRACT
A large challenge facing today’s enterprises is the integration of their own disparate systems to be more competitive and react more strategically to market opportunities. Service Oriented Architecture(SOA) is a style of architecture where the use of reusable and discoverable services are used as components to meet business requirements. The promise of SOA is that the use of these services will allow the organization to increase business agility and reuse of software components. There are some challenges to implementing a SOA. One of the challenges is to present view from the enterprise perspective. Typically, projects take only a view of individual business unit without concerns for the entire organization. Enterprise Architecture(EA) describes the current business and IT processes and how they map together. The two most popular EA Frameworks, Zachman Framework and The Open Group Architecture Framework(TOGAF), are designed to help the organization clarify the current IT Architecture and help provide a roadmap to the goal or future IT architecture. It is with the enterprise view that these frameworks provide that SOA can be supported towards a more successful implementation. There is work underway to determine the relationship between SOA and EA. Whether by clarification from industry experts or direct modifications of the EA Frameworks, EA Frameworks are being used to help implement SOA. It is through the enterprise view and architectural tools provided by the EA Frameworks that SOA can be supported.

Getting 2 .NET applications to use different Oracle Clients

It is not necessarily evident how to get 2 .NET applications to use 2 different Oracle clients on the same server. The following are some rough notes, but you should get the idea and hopefully save you some time as well.

Information can be found at
http://www.oracle.com/technology/tech/windows/odpnet/faq.html

But I will document what I found.

1. Getting the .NET applications to use the appropriate clients on my development machine

I had to follow some steps to get the different .NET applications to use the appropriate Oracle client.

http://www.oracle.com/technology/tech/windows/odpnet/faq.html

Building a website with Oracle 92:
1. Close Visual Studio
2. Uninstall all Oracle Dlls to remove any 102 references
3. Install only the 9.2 Oracle dlls to the GAC:
4. Set Path with "C:\oracle\ora92\bin;" at the start of the Path environment variable
5. Start Visual Studio and Add Reference the first OracleDataAccess dll (despite what the version # says) to the project
6. Set the dll Copy Local to true for some reason then it compiles
7. Run the app and verify that the right dll is being used
Building a website with Oracle 102:
1. Close Visual Studio
2. Ensure that the 102 Oracle Dlls are in the GAC:
3. Set Path with "C:\oraclexe\app\oracle\product\10.2.0\server\BIN\;" at the start of the Path environment variable
4. Start Visual Studio and Add Reference the first OracleDataAccess dll (despite what the version # says) to the project
5. Run the app and verify that the right dll is being used



uninstall All Oracle GAC dlls
"C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\gacutil.exe" /u Oracle.DataAccess
"C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\gacutil.exe" /u Policy.9.2.Oracle.DataAccess
"C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\gacutil.exe" /u Policy.10.1.Oracle.DataAccess



10.2.0.1 GAC install
"C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\gacutil.exe" /i C:\oraclexe\app\oracle\product\10.2.0\server\BIN\Oracle.DataAccess.dll
"C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\gacutil.exe" /i C:\oraclexe\app\oracle\product\10.2.0\server\ODP.NET\PublisherPolicy\Policy.10.1.Oracle.DataAccess.dll


9.2 GAC install only
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\gacutil.exe /i C:\oracle\ora92\bin\Oracle.DataAccess.dll

Your application can do a simple ""select count(*) on table" to verify functionality. To find out which dll you are exactly using, you can use
Type ttt = typeof(OracleConnection);
mes += "\n ttt.Assembly.FullName";



2. Note that setting the path variables for Windows Server does not help out the same as on XP

The path can be set in the application via setting the DLL path in the application itself as follows:

Inside Global.asax.cs:

[DllImport("kernel32.dll",SetLastError=true)]
static extern bool SetDllDirectory(string lpPathName);
protected void Application_Start(Object sender, EventArgs e)
{
string dllPath = ConfigurationSettings.AppSettings["DllPath"];
bool result = SetDllDirectory(dllPath);
}


Inside Web.config

<appsettings>
<add key="DllPath" value="D:\oracle\Client_10g_1010\BIN">
</add>
</appsettings>