cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Mario Herger,

I'll describe more details:

1. I created new database named TestDB in MaxDB with user name "DBADMIN" and password "1234" and insert some data

2. I logged on to Visual Administrator, create new datasource & the connection to TestDB is OK.

3. I logged on to SAP EP, and when mapping user, I selected the system that I have just created & filled user name is "DBADMIN" and pass is "1234", is that right ?

Thank you very much

Tweety

ankur_garg5
Active Contributor
0 Kudos

Cant really make out whats going wrong, but you can have a look at the following links:

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

This link tells how to configure a BI JDBC system...

This thread has some points about hot to create a data source, you can cross verify, maybe something is going wrong there...

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/jdbcConnectionSetup&

This link tells what the driver class name and connection url string should be for different back end connections....

Hope it helps!

Former Member
0 Kudos

Hi Mario Herger,

Thanks for your reply. I've done follow those steps, but I still have this error.

The connection from Visual Administrator to back-end is OK, but from SAP EP is failed.

Have you ever met this error ?

Thank you very much.

Tweety.

Former Member
0 Kudos

Did you go through this document especially?

https://wiki.sdn.sap.com/wiki/display/VC/Troubleshooting+Connections

You probabkly have not properly mapped the user or use a user with the right user authorizations on your database (to read metadata, etc.)