Problem in integrating xMII with Visual Composer

[Former Member]

hi Experts,

I followed this document:

<b>https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40b92770-db81-2a10-8e91-f747188d8033</b> for integrating xMII with VC.

My xMII server Version is <b>11.5</b>, but in that document they used version 12, so I changed the connection URL to 11.5.

Connection URL: http://<myXMIIServerName>/Lighthammer/ALL_TEMPLATES?version=<i><b>11.5</b></i>&trace=true

Driver Class Name: <b>com.sap.xmii.custom.integration.jdbc.SAPxMIIJDBCDriver</b>

System Alias: XMII_JDBC

Connection test is <b>successful</b>, after configured System.

I am getting error while <b>FindData Seach</b> in VC,

Inputs given are,

System: XMII_JDBC (this is my system)

Look for: Look for a table

the error is, <b>Error-2305 Cannot retrive catalogs and schemas; check the connection to the selected systems Cannot access JDBC metadata</b>

Please guide me, where i made mistake.

Points will be Awarded.

Thanks & Regards,

Chinnadurai R

[Former Member · Accepted solution]

Hi there,

Check your userid and password. Also, check whether you have sufficient permission for the system (XMII_JDBC) system created on portal. Also, check if the VCRole has been added to the permissions list of this system. Hope it helps.

Cheers

Nidhi Malik

[Former Member · Accepted solution]

Hi Nidhi,

Thanks for ur reply..

I did all the points what u have mentioned above.. still i cant get the xMII Query in VC..

I think, i made mistake in<b> connection URL</b>. but i am getting <b>success</b> when doing connection test.

please help me..

Regards,

Chinnadurai R