Is there any kind of default data source for Open SQL database connections? If yes, how is the name generated?
• In the underlying database, there is a ready-to-use system “Java” database schema of SAP Web AS Java where you preferably put application database tables as well. • On the server side, there is a ready-to-use system data source (caching open database connections on the server side) and the support level on it is “Open SQL.” This system data source references the Java database schema. • It is best to use the system data source to obtain database connections to the Java database schema. • The name of the system data source gets generated according to the name of your SAP Web AS instance, but you are even not required to know it: • Preferably, in the SAP NetWeaver Developer Studio you define a Data Source Alias for your application. The Data Source Alias is acting as a portable reference to the target data source. By default, at deployment, each data source alias gets mapped to the system data source. It means: define a data source alias and use it in your application in each place you
Related Questions
- From apex code, I would like to access a local SQL database or SOAP Web services. How would I access data from my intranet?
- Is there any kind of default data source for Open SQL database connections? If yes, how is the name generated?
- I want to package a large database. Does SQL Packager compress data and schema?
