[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 518
  • Last Modified:

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
0
pampa34
Asked:
pampa34
  • 3
  • 3
2 Solutions
 
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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
 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now