I have a unique setup that I need to develop a universe for.
I work in a school system that uses PowerSchool as our Student Information System (SIS).
This SIS is housed by a vendor which allows us to access our data through a VPN and odbc connection to their oracle database.
Our schools reporting system is BOBJ EDGE and we use WEBI.
My issue is creating the universe connection to my PowerSchool ODBC. The ODBC connection is functional and I can use excel or crystal to pull data but I really need to use WEBI.
What do I fill in while creating a new connection for Oracle What do I fill in for Net Service?
Are you creating a new universe connection using an Oracle JDBC driver?
If you have a functional ODBC driver then use it in the universe connection. When you define a new universe connection, select Generic → Generic ODBC datasource → ODBC Drivers and then select the ODBC driver that you have and that’s working.
I tried the Generic ODBC and got another error - DSN contains an archtecture mismatch between Driver and Application.
The remote database that we are accessing through an open VPN requires that we use an Oracle or Crystal Reports Oracle driver. There was another Generic JDBC connection available but when I went to use that it asked for the JDBC URL and the JDBC Class. What would i inpur for JDBC Class??
Still having this issue but I have an additional question.
when I create the oracle odbc connection local in my machine I can then pull tables and get data when using that connection in crystal reports fat client - XIR2 version.
when i try and build a universe I can see the tables now connecting using the generic JDBC but I can not pull any data from those tables??
And I still have no idea how to use the oracle JDBC connection when defining a new connection in the universe.
It ask for the following fields
User Name - got it
password - got it
Server/host port - got that
Net Service - ???
Does your ODBC connection have a SERVICE (TNS Service Name) listed in it? I would assume so - otherwise I am not sure how you have created an ODBC connection to an Oracle DB…mind you I have never created an ODBC connection to an Oracle DB because I have always had Oracle Client installed on my machine which means I have TSNAMES.ora…which holds the SERVICES…and I have always created Oracle Connections within the Universe…
Use that if so - and that will work for you when creating an Oracle Universe Connection…
There should be no need to faff about with Java/JDBC or Generic ODBC…
(BOB member since 2006-03-15)
(BOB member since 2003-11-27)
(BOB member since 2004-06-06)