How to use a JDBC connection directly from Visual Composer 7.1.1?

[Former Member]

Is there a posibility to use a JDBC connection directly from Visual Composer 7.1 Ehp 1 Sp 3. Directly means without using the BI Services or Portal Content.

I've setup succesfully the jdbc datasource in the CE Server. But how can I use it in my VC?

The article in the wiki is a little bit superficial. http://wiki.sdn.sap.com/wiki/display/VC71/SettingupJDBC+connections

Thanks a lot in advance.

Sebastian

[former_member203343 · Accepted solution]

Hi Sebastian,

Visual composer can connect to JDBC data sources in 2 ways:

1. Running predefined stored procedures on a DB:

[http://help.sap.com/saphelp_nwce711/helpdata/en/48/a80b77516b35b6e10000000a42189d/content.htm|http://help.sap.com/saphelp_nwce711/helpdata/en/48/a80b77516b35b6e10000000a42189d/content.htm]

2. Through BI JDBC connector. This means you drag the entire table onto the model and the whole logic needs to be done in the model itself.

[http://help.sap.com/saphelp_nwce711/helpdata/en/3f/0f883fed254875883290c98c0c20c1/content.htm|http://help.sap.com/saphelp_nwce711/helpdata/en/3f/0f883fed254875883290c98c0c20c1/content.htm]

In both cases, you create and configure a portal system.

I hope this helps. If you have further questions - let us know;)

Regards,

Netanel