Skip to Content
0
Former Member
Apr 01, 2011 at 12:06 AM

Retrieve data from MS SQL Server 2008 database

21 Views

I have been developing Webdynpro java applications with ECC system as the backend for couple of years.

Now, I am trying to create a system object (portal system) to connect to an external Microsoft SQL Server (2008) Database.

Portal version is EP 7.0

I am planning on using Webdynpro Java or JSP Dynpage application for the frontend. (Visual Composer is not an option for me)

I have looked around on SDN and I am kind of confused on the right way of doing this.

Some posts talk about simply creating a portal system object using the JDBC template.

Whereas some other posts talk about creating a system from Visual Admin on the server.

There are a lot of posts that talk about Visual Composer or BI based JDBC connection - I am not interested in this because there is no BI system involved in my case.

I have the following step by step document which tells to create a datasource through Visual Admin and also a system alias in the portal :

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40db1ed9-b7c2-2b10-66b8-84f6954b6d2d?QuickLink=index&overridelayout=true

I am not sure about what is the link between the datasource and the system created on the portal.

What is the best (or) right way to connect to a SQL Server database to retrieve data from there and display it on the portal ?

What configuration is required from the Visual Administrator ? (Drivers, Datasources, etc)

At the end of the day, in the java coding, what is "really" required to access data from the SQL Server Database (system alias or data source) ?

Thank you in advance.

Jaya