I am already puzzling a few days....
I defined a JDBC Connector in the Visual Administrator.
The definition there are ok, because I can connect perfectly using the test servlet at http://sapserver:50100/TestJDBC_Web/TestJDBCPage.jsp.
The next step was defining a system in my landscape. I followed the instructions in the document "How To... Configure a BI JDBC System for Visual Composer"
I am using these properties:
CodeLink = com.sap.portal.systems.bi.SAP_BI_JDBC
ConnectionFactoryClass = SDK_TESTDB
ConnectionUrl = jdbc:jtds:sqlserver://sapserver:1433;databaseName=TestDb
(this url is the same as in Vis. Administrator)
Driver Class Name = net.sourceforge.jtds.jdbc.Driver
Fixed Catalog = TestDb
Fixed Schema = dbo
System Type = SAP_BI_JDBC
User Mapping = admin, user
I am logged in as Administrator, so I added the login credentials at the User Mapping page of the Administrator user.
When I use Connection Test function from the portal I get the following messages:
Retrieval of default alias successful
Connection failed. Make sure user mapping is set correctly and all connection properties are correct.
What can I do to solve this problem?
I have already tried so many changes in the properties...
It is driving me on the wall !!
Where can find a logfile to see what is going wrong?