How to connect to back-end system (MS SQL, MaxDB, ...)

[Former Member]

Hi gurus,

I'm beginner in Visual Composer. I've a trouble in connecting to back-end system. I've tried to connect SAP EP to many system (MySQL, MaxDB, MS SQL) follow these steps:

1. Create data source in Visual Administrator

2. Create new system in SAP Portal

- Define new system

- Config Driver class & connection URL

- Assign Permission "Admin, USer"

- System Alias

- User mapping

In step 1, I have connected successfully to back-end system & got the data from it. But in step 2, when I test the connection, I have always error in mapping data and connection properties:

Connection failed. Be sure that the mapping data & connection properties are correct.

Could you please show me how to resolve this problem ?

Thank you very much.

Tweety.

PS: I'm using SAP NewWeaver with trial version.

Message was edited by:

Tweety Baby

Message was edited by:

Tweety Baby

[Former Member · Accepted solution]

See the Visual Composer WIKI FAQ:

https://wiki.sdn.sap.com/wiki/display/VC/Connectivity

Don't forget to use the BI JDBC Connectivity to see tables and views.