Configuring Datasource Drivers
If your mashup script uses a <datasource> statement with explicit connection information to access a database and execute direct SQL commands, you must add the JAR files containing JDBC drivers for your data source to the Business Analytics Server classpath and add configuration for these drivers.
Note: | You do not need to add JDBC driver JARs for datasources used in mashups when the mashup script uses implicit datasources. Implicit datasources refer to a named datasource that has already been configured in the Business Analytics Server. |
1. Copy the JAR file for your database driver to the folder for JAR files in MashZoneNG-config.
This is either an external configuration folder for the Business Analytics Server or the default location web-apps-home/presto/WEB-INF/lib.
Important: | It is a best practice is use an external configuration folder, especially for clustered environments. |
2. Restart the Business Analytics Server.