How to identify JDBC System as Relational System ?

[Former Member]

Hi,

I work on NW2004s SP10 and NW Visual Composer 7.0 and I want to create a simple test iView with the Visual Composer.

I want to connect to a JDBC-System (Microsoft SQL Server 2000) and display the content of a table. But the Visual Composer identifies my JDBC-System as Non-SAP-System instead of a Relational System. At the moment I can select the Stored Procedures but not the Tables.

What should I do in order to be able to select the tables ?

Should I create a relational system instead of jdbc system ? if it's the case, how can I do that ?

thanks,

Loï

[Former Member]

Hi Loic,

Refer this links, will be helpful for you

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

http://help.sap.com/saphelp_nw2004s/helpdata/en/52/7888e85fe24dbeaed7b53bb430aa34/frameset.htm

Regards,

Shemim

[Former Member]

Hi Loic,

please check the great Visual Composer Wiki. Look into section => Connectivity => <a href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/cannotseetables&">JDBC - Cannot see tables</a>.

Best regards,

Martin