Connecting to datawarehouse from Java app

Hi,
I have one questions related to java app connecting to datawarehouse. Could somebody tellme how to do that and is there any JDBC driver available for that? Also if somebody could provide a sample code, it will be of great help.

Thanks,
Pampa
pampa34Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RuadRauFlessaCommented:
It all depends on the datawarehouse that you are using. Would you care to elaborate a tad more?

The only "sample code" you will get here is incomplete so as to merely give an idea of what to do.
0
pampa34Author Commented:
Hi RuadRauFlessa,
Should be enough for me, because we dont have fair idea of what is coming. Just a step forward should be enough for us.

Pampa
0
RuadRauFlessaCommented:
Well what are you using for your datawarehouse?
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Venci75Commented:
The dataearehouse is a normal databse, which is used as a datawarehouse. To connect to it you will need the driver provided by the database vendor. A sample code is:

Class.forName("driver class name");
Connection conn = DriverManager.getConnection(url, user, password);

for more information refer to the java.sql and javax.sql packages.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pampa34Author Commented:
Consider any datawarehouse like Peoplesoft, VSAM, etc and let me know how to connect to these datawarehouse from Java application. I know how to connect to a database using JDBC, what I want to know is are there any JDBC drivers from which I connect.
0
RuadRauFlessaCommented:
Well it is like Venci75 said. A datawarehouse is in a normal database the diffirence is only the design of the database itself. That would thus conclude that you would be able to connect to it via a jdbc driver if you have one for the specific dbms that you are using such as peoplesoft........
0
pampa34Author Commented:
Well I understand the same. First of all I have no idea of which datawarehouse to be used. If at all we use peoplesoft, then how is that we connect. Normal Type-IV drivers are enough to connect to that datawarehouse. If not then what all drivers are available.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.