What is the Relation between SAP EP, SAP R/3 and any database

[Former Member]

Hi ALL,

I am learning SAP EP,Webdynpro

Previously I have worked on IBM WebSphere Portal for installation and configuration test purpose on different operating systems.

In case of IBM webSphere Portal

1. There is a default database named as Cloudspace

2. I had configured WebSphere Portal with different databases(Oracle,sql,DB2) just by modifing some portal installation files.

Similarly in case of SAP Enterprise Portal

1. Is there any default database.

2. How can we configure the portal with different databases(Oracle,sql,DB2)

3. Why the SAP R/3 comes into the picture in case of SAP EP

4. can we communicate to any database(Oracle,sql,DB2) through NetWeaver Developer Studio by writing any code or by setting any fields.

Please help out me

Regards

Seshu

[Former Member · Accepted solution]

Hi,

EP heving default database is MAXDB...

Yes, using JDBC connector you can communicate Oracle,sql with EP..

Refer this link

http://help.sap.com/saphelp_nw04/helpdata/en/30/a0f17aacb34b108b39a96acc33da3f/frameset.htm

Configure SQL with EP: Creating system for connecting sql with ep

1 - In System administration> System Configuration, create a new system (from template)

2 - Select 'jdbc system'

3 - Provide the system name etc

4 - Provide the jdbc driver url etc information. The jdbc driver is already deployed on the J2EE engine via Visual administrator and tested to be ok

5 - We provided valid username/password via user mapping

if the info is useful for u assign points.

Regards,

Senthil K.

[Former Member · Accepted solution]

Hi Senthil ,

Do you remember me ?

How are you ?

I was searching about the JDBC Connector and i found your answear here .

I have a new project and i want in the NWDS to create a Portal Application and i want to connect with JDBC Connector to a DB.

The steps as i understand are

1. Create a JDBC system in the portal as you say

2. Use the code in the link you sent.

Senthil what else do i need for these?

Do you have any completed example or tutorial for these please?

Please Senthil this is urgent as i must until Monday solve the problem so i appreciate any your help.

P.S. We didn't start the project ww was talk about .

The client solve it with another way.

So i didnt inform you about it.

Regards,

Ari

[Former Member]

Hi! Sesshanna,

Welcome to SAP Enterprise Portal.

1.Like IBM webSphere Portal,SAP EP is also have a default DataBase Named MaxDB, this database comes with portal installer and you need to install this DataBase as well.

2.you will get a lots of document on SDN to configure the databases like(Oracle,sql,DB2), you need to make an entry in Visual Administrator(go.bat).But if you want to use DataBase in standalone application then you can use the same code which generally we use in any Java Code(Code written in point 4).

3.You can use SAP R/3 as BackEnd to access R/3 RFC in WebDynpro application, which is used to develop any customized application.

4.you can write the following code in any view or controller of the NWDS:--

MessageManager msgMgr = (MessageManager)wdThis.wdGetAPI().
getComponent().getMessageManager();
                String  serverName = "172.21.1.62";
	String portNumber = "1526";
	String sid = "vision";
  String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
	String userName = "scott";
	String password = "tiger";
	Connection connection = null;
		
	try {
	 // Load the JDBC driver 
	String driverName = "oracle.jdbc.driver.OracleDriver";
	Class.forName(driverName);
	connection = DriverManager.getConnection(url, userName, password);
	Statement stmt =connection.createStatement();
ResultSet resultSet = stmt.executeQuery("select * from patni_employee");
	
	   if(resultSet.next()) {
		msgMgr.reportWarning(resultSet.getString(1));
		msgMgr.reportWarning(resultSet.getString(2));
	   }
	} catch(Exception exc) {
	 exc.printStackTrace();
	} 

regards,

Mithileshwar