Is it possible to make connection for the VC application the SQL Server

[former_member192283]

hi

I have requirement like, We have some data available in SQL server as central repositoty. My client want to make the Anylatics application like showing graphs in VC based on the data available in SQL server.

My question. Is there any possiblity to make the connection the sql server by creating some system object using some JDBC connection Like that.

What is the possibility.

can u any body tell what is the work around need to be for this requirement. Whether it is possible or not.

Regards

vijay

[former_member4251 · Accepted solution]

Hi Vijay..

Yes, you can create a JDBC system object and use it as data source element as well as any RFC /BIQuery...

There are some tricks and please note that the usage is limited to stored procedures.

Just play a bit and if you have more specific questions we will be glad to help you here in the forum.

Kind Regards,

Luis

[former_member192283 · Accepted solution]

Hi Luis ,

thanks for the quick reply.

I have already developed one application , showing the anlaytics report by connecting to R/3 server.

Now i want to make the connection to the SQL server from the VC application to fetch the data and show. in vc application. Can u please tell me what is the procedure. if it is possible ?

Like when i am talking to the R/3 we have developed one BAPI , which is going to give the data based on my inputs in VC.

In the same way , if it is possilble to make the connection to SQL server. What is the work around need to be done in SQL server to serve VC application. Like do we need to create any stored procedure or, by executing the query itself will get the data based on my inputs.

what is the procedure? please tell me elabrately.

Regards

vijay

[Former Member · Accepted solution]

Hi Vijay,

as Luis mentioned you need a JDBC Connection.

Therefore is our WIKI helfpful. With the JDBC you can use stored procedure as well as SQL statements. Here are some helpful WIKI entries:

<a href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/cannotseetables&">https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/cannotseetables&</a>

<a href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/writingDataBack&">https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/writingDataBack&</a>

Setting up your JDBC connection:

<a href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/jdbcConnectionSetup&focusedCommentId=14341">https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/jdbcConnectionSetup&focusedCommentId=14341</a>

Best Regards,

Marcel

[ankur_garg5]

Hi Vijay,

In your other thread, I have given the link to the following doc which will help you to in configuring the JDBC Connector.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/uuid/b00917dc-ead4...

That was the first step.

In the second step, you need to create a JDBC System in the portal. Go through the following doc which explains how to create BI JDBC system for VC. All you need to change is that on Page 10, choose JDBC system instead of BI JDBC system, and do the necessary configurations.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6209b52e-0401-0010-6a9f-d40ec3a0...

As rightly said by Marcel, you can use stored procedures as well as SQL statements. As far as stored procedures are concerned, all you need to do is go to Enterprise Manager, and create procedures in your database in the same way by which you create new tables and users (Refer my article). Then you can use these procedures in your Visual Composer provided you have properly created the JDBC system in portal properly.

Also have a look at the following doc:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6339e7d4-0a01-0010-1c98-db00e52e...

Bye

Ankur

Do reward points for helpful as well as solved answers!!

[former_member192283]

Hi Macel,

Thanks for the reply , i was able to create the connection for the sql server. able to see the objects using the system object.

1) But i am able to see only Tables and views. I am not able to see the Stored procedure object. Can u tell will be the reason behind this.

2) When i right click on the Data source view to choose the SQL Editor. It is giving the following warning .

you are not authorized to use the functionality. See the SAP Netweaver Visual Composer security guide for more information

Can u tell me what is the reason for these two problems.

Regards

Vijay

[Former Member]

Hi Vijay,

1) You must use a Portal JDBC connector as it is mentioned here:

<a href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/cannotseetables&">https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/cannotseetables&</a>

2) You must enable the SQL Editor in the Visual Administrator. By default it is not enabled.

(Settings under the VC Service in Visual Administrator, at the moment there is no Wiki entry how to do this, but it is quite simple.)

Best Regards,

Marcel