Can we connect from Portal to MaxDB with the trial version of SAPNetWeaver?

[Former Member]

I’ve installed SAP NetWeaver Developer Workplace SR2 (trial version) with the following components:

• SAP Web Application Server Java 7.00 (J2EE Engine)

• MaxDB 7.6.00.34 database + Database Manager and SQL Studio

• SAP Enterprise Portal

• SAP Content Management and Collaboration

• Adobe Document Services

• BI SDK

• Visual Composer

• Composite Application Framework (CAF)

Now, I created new TEST database in MaxDB (user: DBADMIN, pass: abcd).

I want to connect from the Portal to the TEST Database, so I follow the steps described in the documents (How To Configured BI JDBC Connector, ….)

- I log on Visual Administrator, create BI JDBC Connector, create new DataSource.

Now, I can get the Data from TEST Database.

- I log on Portal and create new BI JDBC System,

+ Driver: com.sap.dbtech.jdbc.DriverSapDB,

+ Connection URL: jdbc:sapdb://sapep/test

- Then, I create system alias, map user with the user in Test Database (User: DBADMIN. Pass: ABCD)

But when testing the connection, I’ve an error:

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

When I test the connection by the link:

http://sapep:50000/TestJDBC_Web/TestJDBCPage.jsp

I’ve an error:

<b>com.sap.ip.bi.sdk.exception.BIConnectionFailedException: Cannot open the connection

Exception id: [0008C72B8B0C00C60000006F0000114000042C18596CD779]</b>

Could you please show me how to resolved this problem ?

I don’t know if it is caused by the trial version ?

Thank you very much.

[Former Member · Accepted solution]

Hi Tweety,

I assume that you have create the driver with the required .jar files.

supose its name is MAX_DB

After that go to "Connector Container" in visual admin. To create a new connector,

select the connector SDK_JDBC and click the clone button to create a new BI JDBC connector and enter a name for the connector eg., SDK_MAXDB

Selct the recently created connector and choose the resource Adapter tab. click the add button to assiciate addtional resources the Connector

To add resource, enter the name as "library:MAX_DB".save the changes and restart the server.

Now in the portal there is a property "ConnectionFactory" set this to "SDK_MAXDB".

Now u have said that u have set the values for Driver and Url as

+ Driver: com.sap.dbtech.jdbc.DriverSapDB,

+ Connection URL: jdbc:sapdb://sapep/test

the value for driver is correct but the value for connection URL is wrong.

Connection URL: jdbc:sapdb://<Machine_name>:<Port>/<Databse_name>

Now i dont what is the port no for MaxDB. as for SQL its 1433, for oracle it is 1521, for netezza it is 5480. U can get it from ur system adm or from net.

As u have not mentioned the port thats u r facing the problem.

Regards

Paresh

[Former Member]

Hi Paresh Panda,

The value I set for Driver Name & Connection URL:

+ Driver: com.sap.dbtech.jdbc.DriverSapDB,

+ Connection URL: jdbc:sapdb://sapep:7210/test

(sapep is my server name & test is database name)

I have error because I hasn't added JDBC Driver for MaxDB yet & use SYSTEM_DRIVER :).

Kindly regards,

Tweety.

[Former Member]

Thank you very much for your replys, I can connect to my database now

[Former Member]

Hi,

Can u Mention the value for Driver and the connection Url, which u gave to connect to the back end.

Regards

Paresh

[Former Member]

Hi Paresh Panda,

Could you please tell me more details the driver required for MaxDB ? Because, MaxDB is included with SAP Net Weaver, so that I think its driver required is included in SYSTEM_DRIVER. I don't create new driver, but when I create statement for getting data from database, no error is raised & I still get data.

So, I don't know where is wrong ?

Thank you very much for your reply , With it, I hope I'll solve my problem

[Former Member]

Hi,

For my server the DB was SQL. I have never worked in MaxDB.

but i think, from this link download the jdbc driver and see if it works.

http://dev.mysql.com/downloads/maxdb/7.6.00.html#JDBC_Driver

Regards

Paresh