How to set up a JDBC Connector with Visual composer

[Former Member]

Hi all,

i'm trying to retrive all tables and views as data source in visual composer but i can't see Database as valid source from drop down like others backend systems

do you have some ideas or documentation about this topic?

all that i found is about connect to backend systems

also i would like to know if it's posible to use stored procedures and what about security at database level

we are using SQL Server 2005 Yukon

i will reward usefull answers

Regards

Ruben

[Former Member · Accepted solution]

There are a lot of threads about bi_jdbc and jdbc connections. First of all you should read the wiki [https://wiki.sdn.sap.com/wiki/display/VC/Connectivity|https://wiki.sdn.sap.com/wiki/display/VC/Connectivity]. Then try searching the forum for "JDBC" and "Stored procedures". You will get a lot of useful answers. If you run into problems post your questions and we will be happy to help.

Yes, it's possible to use stored procedures. You first have to know that you need a jdbc system set up for tables and views, and a bi_jdbc for stored procedures.

Check out great description from page 13 [in this document|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/92d80512-0a01-0010-32a3-cd3735bd9275] on setting up a bi jdbc connection to SQL server. Try a couple of times if doc is difficult to load.

Good luck

Henning Strand