Automate Siebel EIM Mapping using SQL

Hey Everybody,

Hope you all are doing Great!

It's been a long time since my last post, apologies for that! Anyway, I have decided to make up for that time and give you some great stuff!

Recently, I had a LOT of people asking for a way to Automatically generate EIM Mappings. I have written a post previously called Generate EIM mapping using SQL Script. However I made some new changes that will give you more information than before.

So here are the updated versions for Oracle and MS SQL

Output Preview

Document Links : Do what the document tells you are you're good!

Automate Siebel EIM Mapping using SQL_MSSQL
Automate Siebel EIM Mapping using SQL_Oracle

Watch out for more interesting Stuff!


Cheers!
Ryan

Repository Script Extractor for Siebel versions > 7.7

Hey folks,

Want to have a backup of all those cool and interesting scripts you wrote, but find it too taxing to manually copy each and every script in to a good readable format?

Here is a new tool the we have been working on. What it basically does is, it extracts the scripts based on a user given date or a prefix. Any scripts that were created or updated beyond the date will be exported into the excel sheet as well as in an HTML format just like the utility Oracle had introduced to extract scripts for versions 7.7 and earlier.

The tool connects to Siebel via the object layer and pulls out the information...

Here is a peak at what this tool looks like

Main UI

HTML Output

Click the below icon to download this cool tool..!

Cheers!

Repository Data Retriever© v1.0

Hey Folks,

Here is an excel spreadsheet I had been working for the past couple weeks. It has been designed to export all the newly created and modified objects beyond a particular user given date.

Special features include -

- Works on Sample/ Local and Server.

- Cool UI features to minimize user effort (Object Explorer, date Chooser, Select File Dialogbox)

- Process Status section. This is so the user is not prompted everytime unless a critical error has occured or user intervention is really required.

- Data is exported in an easily readable format

- Can be very well used for Upgrades to analyze the amount of Repository Customization

Interface Detail:

Screen prints of the tool -

Main Page -

Exported Objects View -

Click on the below icon to download the Repository Data Retriever (limited downloads).

Cheers!