on 02-13-2007 5:50 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Cant really make out whats going wrong, but you can have a look at the following links:
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!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.)
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.