connecton to non sap server from ep 7

[Former Member]

Hi Friends,

can any tell how to connect to backend database (sql server 2000) from ep 7. how to create system object.

[Former Member · Accepted solution]

i need navigation steps, not the coding part. i am thinking to do it through system administration->system configuration->right click>new-> system (for template

[former_member188632 · Accepted solution]

Hi,

Exactly, this is the path to follow,

Go to system admin --> system config --> right clikc ans select new system from template, select the type of system you want to create, let it be JDBC system or system for dedicated aplication server.

Fillin all the properties here, do the use mapping now,

go to user admin --> search for your user --> Select USer mapping for system, put uid and pwd, and also do not forget to set system alias.

And you are done

Regards,

Ameya

[Former Member · Accepted solution]

please can u tell me the connection properties for sql server 2000

[Former Member · Accepted solution]

Hi,

Here's what's needed in the system (examples are from my system):

• CONNECTION PROPERTIES:

-- Connection URL: jdbc:sap:sqlserver://p031617:1433;DatabaseName=pubs

-- DRIVER CLASS NAME: com.sap.portals.jdbc.sqlserver.SQLServerDriver

-- VALIDATE CONNECTION: yes

• USER MANAGEMENT:

-- USER MAPPING TYPE: admin, user

• DQE: Put in admin user/password (DQE is for distributed queries between multiple, heterogeneous databases, but you still need to use it for simple queries)

• Create an alias

• Go to User Administration and set user mapping for the admin user

• Test connection

Each user that access the system will need user mapping.

Refer this link for details

<a href="http://help.sap.com/saphelp_erp2005/helpdata/en/84/d5df3df2ad685ae10000000a11405a/content.htm">http://help.sap.com/saphelp_erp2005/helpdata/en/84/d5df3df2ad685ae10000000a11405a/content.htm</a>

Regards,

Hemalatha

[Former Member]

Hi,

You can use JDBC Connector

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/30/a0f17aacb34b108b39a96acc33da3f/frameset.htm">JDBC Connector</a>

Refer this link

<a href="https://forums.sdn.sap.com/thread.jspa?messageID=3405116">https://forums.sdn.sap.com/thread.jspa?messageID=3405116</a>

Regards,

Hemalatha