Hi,
I create a system for my JDBC system according to this procedure:
***************************************
The steps to create the JDBC Query iView are as follows.
Login as System Administrator,
Navigate to System Administration>System Configuration>System Landscape
Create a new system,
Choose JDBC System>Assign name etc>Open Object for Editing
Under property category choose: Connection & assign,
Connection Timeout = 60
Connection URL = jdbc:sap:sqlserver://sqlservername:sqlTCPport;DatabaseName=SQLDBName
Driver Class Name = com.sap.portals.jdbc.sqlserver.SQLServerDriver
SAVE
Change the Property Category to: Distributed Query Engine
Enter the admin user\password to the oracle database.
SAVE
Change the Property Category to: User Management
Choose admin,user
SAVE
Now change the Display category to System Aliases
Enter a system alias for the system.
Go to user management and assign your login details to the system alias you just created.
Go back to the system in the system landscape and right click and choose connection tests
***************************************
When I choose the connection test I receive a error message. This message said to check user management and properties, but its ok. What's happen?
EP6 SP9 in WebAs 640 SR1
SQL Server 2000 SP3
Andre
Hi Andre,
are you talking about an oracle db or a sqlserver? (since you mentioned both...)
Ok, I assume "oracle" was a mistake.
Here are my connection properties for connecting to my local portal database:
-Admin User & password(dqe) are filled with the correct credentials
-connection timeout: 1000
-connection factory class: JDBCFactory
-connection URL: jdbc:sap:sqlserver://127.0.0.1:1433
-Driver Class Name: com.sap.portals.jdbc.sqlserver.SQLServerDriver
-SystemName: localSQLServer
-User Mapping Type: admin, user
-Validate Connection: No
That's all and it's working.
Hope that helps, Karsten
Add a comment