Siebel Consultant Diary of a Siebel Consultant

Dataload successful

Today I successfully completed my first dataload ever. In a previous project I also did the dataload, but there the SQL files to fill the EIM tables and .ifb files where already written. This load I had to do from scratch.

The project started last week, and I had one week to complete the load since we only got 4 weeks to deliver a working application. With complete and accurate data that is.

I have to admit that it was not the most difficult load ever, but every first time is hard. The data that need to be loaded where accounts with addresses and positions linked to it and segments and industries, contacts – linked to the accounts and also with addresses and entities in the S_CONTACT_XM table.

The first task was to get the data from .csv files in temporary tables. This worked like a charm with the use of SQLLoader. Next step was filling the EIM tables. This was a process of trial and error to find out what columns where needed.

I ran into some difficulties when trying to link the positions and the accounts but found the solution in the end. Last night I started the first big batch (170.000 accounts) and this morning I loaded the rest of the data. This week, the data will be checked.

The rest of the week I will configure the application together with my two colleagues. It will be some several busy weeks to come but the reward will be big I guess.