Named Datasources versus the Default Datasource
Implicit datasources are named when they are configured in the Business Analytics Server. You use this name in SQL statements in mashup scripts to identify which datasource to apply the SQL statements to.
Explicit datasources can also have a name that you can use in SQL statements to identify which datasource to apply the SQL statements to. Named datasources:
Provide better performance because the
Business Analytics Server caches named connections.
Because of this caching, datasource names for each connection must be unique and consistent across all mashups published in one Business Analytics Server.
Allow you to work with multiple datasources in one mashup script.
If the name is omitted in the <datasource> declaration, the datasource is considered a default datasource. SQL statements without a datasource name are applied to the default datasource.
In this example, the datasource on the localhost is treated as the default datasource. Two additional explicit datasources, named HR and Finance are declared:
<datasource url="jdbc:oracledb:osql://localhost:1521"
driverclassname="oracle.jdbc.driver.OracleDriver"
username="system" password=""/>
<datasource url="jdbc:oracledb:osql://234.10.25.2:1521"
driverclassname="oracle.jdbc.driver.OracleDriver"
name="Finance" username="system" password=""/>
<datasource url="jdbc:oracledb:osql://234.10.35.2:1521"
driverclassname="oracle.jdbc.driver.OracleDriver"
name="HR" username="system" password=""/>
