Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 13, 2007 at 05:54 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 13, 2007 at 06:02 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 13, 2007 at 06:18 PM

    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

    Add comment
    10|10000 characters needed characters exceeded