November 11, 2005 at 6:45 am
I am now going to embarrase myself as I am a lowely business analyst with a little SQL server knowledge....I know we're all the same us BA's, a little bit of knowledge is bad for us, but I have a question which is proving difficult to answer...
If I have a legacy system written in Fortram, and data warehouse in Oracle and a reporting tool in SQL what can I do about creating the data for interrogation at source, ie we currently have to run reports against the warehouse and then against the legacy system and then analyse out side of the systems....!
Any ideas, or should I just pack my bags and leave this forum to proper technical people?
Thanks
November 14, 2005 at 8:00 am
This was removed by the editor as SPAM
November 14, 2005 at 3:56 pm
Don't put yourself down. You may become a DBA yet for lack of anyone else doing the job. What you are up against is pretty common. There is no quick and easy way to answer you. An analyst would get the big bucks to tell you exactly how to do it. I presume your legacy system written in FORTRAN has some sort of data storage behind the code (either a database or flat files). Your data warehouse, definitely, is a data store. Are there drawings of the data? typically, these would be entity/relationship diagrams (ERDs). Is there someone who can tell you what the data represents? Do you know what you need to report on? The new facility called SQL Server Integration Service (SSIS) is the current tool of choice for migrating data from one location to another... but it wouldn't be fair to tell you that was the place to start either. Let me assure you, what you are contemplating is not an easy job... if it were, we, data analysts, would be DEMANDING MINIMUM WAGE! It all has to be mapped out, and probably moved, and very probably "transformed" along the way. You can make a living at it though.
November 15, 2005 at 4:15 am
David thanks for the reply. The data is all product in Fortran environment, (on sale date, ref ID, price, bar code etc) and then EPoS on the data warehouse (retails EPoS), interrogated through Microstrategy 7.2 and SQL scripts. I know it's not an easy one but hey at least you didn't so it can't be done. That's the great think about IT if it can be done then make money proferring ideas!
Thanks again
Mike
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply