Getting data from a data warehouse

[Mark Herreras]

First of all, i'm a newbie so please bear with me.

Anyway, I need help with getting data from a data warehouse (i.e. Informatica, Focus..) from a java program.

Apparently, any app should not get data directly from the database but instead go through the data warehouse app. (i.e. Informatica, Focus..)

I really have no idea how to go about this, so any tips/help would be greatly appreciated.

Thanks.

[Paul Clapham]

If you want to "go through" the data warehouse application, that means you will have to use its programming interfaces, if it has any. So the first step would be to check out its documentation for such things. Calling the support people for the application might be of some help, but that won't be a common question for them to be asked so you might have to be patient.

[Mark Herreras]

Hmm, i did find an SDK though i'm not yet sure what it's for and how to get it.

Anywayz, thanks and wish me luck!