Access data from SqlServer through Visual Composer.....?

[Former Member]

Hi Gurus,

I could able to connect SqlServer database from Visual Composer. After that, how can I access table data from sqlserver database?

Thanks in advance....

Ravindra.

[Former Member]

Hi Lior,

I got the Stored procedures from the database, but I want to retrieve the tables, and also I want to apply joins on two tables and create an iview in visual composer.

Please let me know the procedure for this....

Thanks in advance,

Ravindra.

[Former Member]

Ravindra,

Here is the work around to do this. You will need to create a New System. In the Portal go to System Administration -> System Configuration -> System Landscape. Create a New System from PAR. Select com.sap.portal.systems.BIUDI, click Next. Select SAP_BI_JDBC and enter all the information that you would normally use to connect to a SQL DB using JDBC. You can then in the VC run SQL against the tables. Open VC, and Navigate to the iView level and go to the toolbar and Select BI -> SQL Editor. It is pretty self-explanatory from there.

Regards,

Peter

[Former Member]

If you are able to see the server in visual composer, you should be able to see stored procedures.

Currently stored procedures are stored for JDBC connections.

Lior