Using LocalMaxDB in VC

[Former Member]

Hi,

I'm using the preview version of Netweaver 2004s (Java) and trying to start learning VC. There is a LocalMaxDB already defined. I've set up the user mapping, but having trouble connecting to the database. Does anyone know how to make LocalMaxDB system work? Do I have to create my own system? Any helps and guidance would be appreciated.

Regards,

Iwan

[Former Member · Accepted solution]

Hi Iwan,

You can connect to LocalMaxDB Database through JDBC System or BI JDBC System. But the first thing is you must have the JDBC Driver for MaxDB <b>sapdbc.jar</b> installed in your system.

To do so, you go to Visual Administrator,

- In the Cluster tab, select <b>Server ->Service -> JDBC Connector.</b>

- In the right pane, click on <b>Driver</b>, and <b>Create new driver</b>

- Enter the name of your driver (ex: MAXDB_DRIVER) and navigate to your sapdbc.jar driver.

- Click <b>No</b> when prompt "Choose other files".

- Save

- Restart Visual Administrator.

<u><b>JDBC System:</b> </u>

You must add & deploy your library you have added. Follow these steps:

- Click <b>Start-> Run-> cmd</b>

- Enter this command: <b>telnet <your server name> <your port + 8></b>

Ex: telnet sapnw 50008

- Enter your username administrator & password

- Enter command: <b>lsc</b>

- You see the list of server node, you can choose the node that you want to deploy your driver and enter the command: <b>jump <ID node></b>

- Enter command: <b>add deploy</b> and click Enter

- Enter the command:

<b>change_ref –m com.sapportals.connectors.database library:MAXDB_DRIVER</b>

- Enter command <b>Exit</b>

Now, you can create a JDBC System in your portal.

- Verify:

Driver Class: com.sap.dbtech.jdbc.DriverSapDB

URL: jdbc:sapdb://<host>:<port>/<database>

Ex: jdbc:sapdb://sapnw:7210/J2E (port for MaxDB is 7210)

Connection Factory Class: JDBCFactory

- User Mapping Type: Admin, User

- Create a system alias for your JDBC System

- Mapping user with the user in your database

<b><u>BI JDBC System: </u></b>

You must add & deploy your driver library you have added to BI Connector.

- In the cluster tab, choose Server->Service -> Connector Container

- Under the node sap.com/com.sap.ip.bi.sdk.dac.connector.jdbc, choose SDK_JDBC, and click Clone to create new BI JDBC Connector

- Enter the name, example: SDK_MAXDB

- Choose your new BI JDBC Connector (or u can use SDK_JDBC).

- Choose the Resource Adapter tab

- In the Loader Reference box, choose Add to add a reference to your JDBC driver

- Enter: <b>library:<jdbc driver name> </b>(ex: library:MAXDB_DRIVER) & Choose OK.

- Save your settings.

- Choose Server -> Service -> Deploy

- Select the option Application

- Choose com.sapportals.connectors.database

- Click Stop Application & Start Application

- Now, you can test your connector by the link:

<b>http://<host>:<port>/TestJDBC_Web/TestJDBCPage.jsp</b>

If the connection is sucessful, a list of table is displayed.

Go to the portal & create your new system. Verify that your connection factory class is: SDK_JBDC (if you add your driver to SDK_JDBC BI JDBC Connector) or SDK_MAXDB …

Now you can test the connection.

Hope this will help you.

Tweety.

[Former Member · Accepted solution]

Tweety,

Thanks a lot. That does it.

Regards,

Iwan

[Former Member]

Please see the Visual Composer WIKI under JDBC:

https://wiki.sdn.sap.com/wiki/display/VC/Connectivity

[Former Member]

Hi Thomas,

Thanks for the reply. I saw that blog, but that to connecting to SAP system. I would like to connect to the J2E table (Java DB schema).

Hi Mario,

Thanks for the link. I'm in the proces of looking at related information on the link you gave me.

I looked in the forum that OSS 773401 is reffered many times, but I could not find it in the service marketplace. Is there another OSS notes that replaces this one?

Regards,

Iwan

[Former Member]

It's a note:

https://service.sap.com/sap/support/notes/773401

But actually the link that I sent you before together with the keyword "JDBC" shall solve all your problems.

[Former Member]

And anyways, the note is only for EP6.0, NW04

[Former Member]

Hi Mario,

Thanks for a quick response. BTW, the note is not available. I got message "An SAP note with the number requested could not be found."

Since you told me the WIKI link should solve my problems, I'll take some time to go through that link and hopefully I can make it works.

regards,

Iwan

[Former Member]

Hallo Iwan,

had you seen this blog? /people/marcel.salein/blog/2007/03/14/how-to-create-a-portal-system-for-using-it-in-visual-composer

Regards,

Thomas