available datasource factories, with the available driver. For instance, once you installed the jdbc feature, you can install pax-jdbc-postgresql feature, providing the PostgreSQL datasource factory: database you want to connect: jdbc:ds-create The jdbc:ds-create command automatically creates a datasource definition file by leveraging pax-jdbc. The jdbc:ds-create command requires either: • the --driverName argument is required. It’s the name of the datasource. The name is used to identify the datasource, and to create the datasource definition file ( deploy/datasource- [name].xml ). • the -u option is optional

# DataSource to use dataSource.target=(osgi.jndi.service.name=jdbc/decanter) # SQL Query to retrieve data query=select * from TABLE This configuration file allows you to configure the datasource to and the SQL query to perform: • the datasource.name property contains the name of the JDBC datasource to use to connect to the database. You can create this datasource using the Karaf jdbc:create command Decanter JDBC Appender Configuration ####################################### # Name of the JDBC datasource datasource.name=jdbc/decanter # Name of the table storing the collected data table.name=decanter #

and role retrieval are configurable using the following parameters. Name Description datasource The datasource as on OSGi ldap filter or as JDNI name query.password The SQL query that retries the password className="org.apache.karaf.jaas.modules.jdbc.JDBCLoginModule" flags="required"> datasource = osgi:javax.sql.DataSource/(osgi.jndi.service.name=jdbc/karafdb) query.password = SELECT PASSWORD FROM USERS className="org.apache.karaf.jaas.modules.jdbc.JDBCLoginModule" flags="required"> datasource = jndi:aries:services/ javax.sql.DataSource/(osgi.jndi.service.name=jdbc/karafdb) query.password = SELECT PASSWORD FROM

connection to the database: • the datasource.name property contains the name of the JDBC datasource to use to connect to the database. You can create this datasource using the Karaf jdbc:create command Decanter JDBC Appender Configuration ####################################### # Name of the JDBC datasource datasource.name=jdbc/decanter # Name of the table storing the collected data table.name=decanter #