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 :
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.