Month: May 2009

PeopleSoft Templates

digitaleagle Uncategorized, VMWare 3 Comments

A while back, I posted my idea that Oracle should deliver templates or appliances with PeopleSoft pre-installed.  I feel bad that I did not get it posted as soon as I noticed that Oracle did finally publish such an image.

But, they appear to have removed the images.  I can’t find them.  I found on a cached page that shows where they have the image available.  I am terribly behind on reading the blogs — maybe  there will be some clues there.

I also did some looking around to see about using such an image.  My problem is that I already have VMWare installed.  Can I install Oracle VM along side?  Even if it is possible, it is advisable?

I looked into converting an Oracle VM image into a VMWare image.  I found a post asking about doing just that, but it had no answer.  VMWare has a Converter and vCenter that will convert machines into VMWare images, but they don’t talk about working with Oracle VM images.  Here is another page of tools, but none of them stood out as options.  Oracle has some tools too, but I don’t think they will do the trick either.

Any Interest in Program?

digitaleagle Meta-SQL, SQL, Uncategorized 2 Comments

I have been tinkering around with a little Java application I started for running queries against a PeopleSoft database.  I was just curious if there was any interest in such an application.  Here is a screenshot of what I have so far:screenshot

So far the program connects to SQL Server databases and Apache Databases.  It runs queries and loads the data into the JTable at the bottom.

I have a SQL “preprocessor” that evaluates the SQL right before it passes it to the database.  Currently, the only thing it does is to pull the semi-colon off of the end.  But, I plan to have it resolve meta-sql such as %Table() and %CurrentDateIn, etc.

Also, I would like to build SQL tools in that understand the SQL syntax.  I would like tools that automatically generate effective date criteria.  Another feature would be nice to have where it would join a table into a SQL statement.