Configuration Issue with BI system for VC

[Former Member]

Hi Experts,

I am going to configura BI System but I am getting some problem..when I want to use BI wizard in Visual Composer...

I am using EP 7.0

Error2305cannot retrieve catalogs and schemas...etc..

when I already pass JDBC connection...

Connection URL: jdbc:sap:sqlserver://epsans1.xxxxxxxx.com50000;DatabaseName=EP7

Driver Class Name: com.sap.portals.jdbc.sqlserver.ojdbc14.jar

Is I am missing some parameter or what should i do ?

Please help me out.

Regards,

Iqbal

[Former Member · Accepted solution]

Are you getting a successfull connection test of your bi_jdbc system in portal?

It seems like you are configuring your system a bit wrong. If you are trying to connect to an SQLserver why are you trying to use an Oracle DB driver? OJDBC14.jar is an Oracle driver.

See [https://wiki.sdn.sap.com/wiki/display/VC/Connectivity|https://wiki.sdn.sap.com/wiki/display/VC/Connectivity] for docs on how to set up a bi_jdbc connection.

Henning

[Former Member]

Hi Experts,

I am doing BI configuration with VC. I am facing some issue..

As I am working VC 7.0 and , I have Oracle 10g database, and created BI_JDBC Alisas

I have pass these parameter in Connection

URL == jdbc:oracle:thin:@epsand1:5560:orcl

Driver Name -= oracle.jdbc.driver.ojdbc14.jar

and In Visual Administration, I have done some configuration and pass two JARs file name

Driver ojdbc14.jar , ojdbc14_g.jar

But My test connection it is showing failed.....

Is there any parameter, i have to change... or it is incomplete URL like this

please send me some document in this regard.

Any help will be appreciated .

Best regards,

Iqbal

[Former Member]

Hi Henning ,

Please help me in this regard.

As I mentioned every thing over there.

Best Regards,

Iqbal

[Former Member]

Hi Experts,

I am getting this error...

Test Connection with Connector

Test Details:

The test consists of the following steps:

1. Retrieve the default alias of the system

2. Check the connection to the backend application using the connector defined in this system object

Results

Retrieval of default alias successful

Connection failed. Make sure user mapping is set correctly and all connection properties are correct.

"" Where I should be the next step"" any help will be appreciated.

Best Regards,

Iqbal

[Former Member]

See document [How to configure a BI JDBC System for VC|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6209b52e-0401-0010-6a9f-d40ec3a09424]. This helped me a lot.

Within your deployed ojdbc14.jar file is a thin driver. This is what I'm using. Then you should configure like this:

com.sap.portal.reserved.system.ConnectionFactoryClass = put the name of your connector where you deployed your jar file. (see document)

connection url = jdbc:oracle:thin:@host:port:sid

Driver class name = oracle.jdbc.driver.OracleDriver

good luck

Henning

[Former Member]

The document link in last reply did not work when I tried it a few minutes ago. The message I got was that the document was broken. When i found the same document while Googling for it I suddenly got the link to work.

If you have trouble opening the document, don't give up.

Henning

Edited by: Henning Strand on Dec 19, 2007 2:22 PM

[Former Member]

Hi Henning,

I have given the parameter in portal like

1-com.sap.portal.reserved.system.ConnectionFactoryClass = SDK_JDBC (it is as i check in Visual Administrator)

2-Connection URL = jdbc:oracle:thin:@xxxxxx1.xxxxxxxthq.com:5560:epsand1

3-Driver Class name = oracle.jdbc.driver.OracleDriver

All parameter is OK or I havre to change some thing....

I have given the same name as User Id and Password in user mapping as I have BI system

Is I have to use my frontend database user ID , Pwd or it is ok as I am using BI system user id, pwd.?

Thanks,

Iqbal

[Former Member]

I have no experience with BI. I have worked with BI_JDBC connections directly to database schemas where the only login required is a schema name and password passed by user mapping.

Works for me.

Thanks for all points given if I have been of any help.

Henning

[Former Member]

Hi Henning,

I am Also using BI_JDBC connection, but it is not working for me.

Can you plaes check the parameter which i have passed in Portal..... I think I am missing some syntex or something....

Best Regrads,

Iqbal

[Former Member]

You put this as URL earlier in the thread: jdbc:oracle:thin:@epsand1:5560:orcl

Isn't epsand1:5560:orcl your host:port:sid? Why then have you put jdbc:oracle:thin:@xxxxxx1.xxxxxxxthq.com:5560:epsand1

in you later post?

Are you sure of your port? It's quite common to use 1521or something alike.

Have you checked your user mapping scenario? I usually set user mapping type to user,admin. Then (for everyone to access the same db schema) I add group Everyone to Permissions (still under system config), set read and check end user check box. Then go to user admin, find group everyone and do user mapping with the user name and password to the db schema.

Henning

Edited by: Henning Strand on Dec 21, 2007 10:40 AM