Mifos BI Configuration

ETL Configuration

  • Be sure to configure data-integration/simple-jndi/jdbc.properties to use UTF-8 for the database connections:
jdbc.properties
SourceDB/type=javax.sql.DataSource
SourceDB/driver=com.mysql.jdbc.Driver
SourceDB/url=jdbc:mysql://localhost:3306/mifos?useUnicode=yes&characterEncoding=UTF-8
SourceDB/user=...
SourceDB/password=...
DestinationDB/type=javax.sql.DataSource
DestinationDB/driver=com.mysql.jdbc.Driver
DestinationDB/url=jdbc:mysql://localhost:3306/mifos_dw?useUnicode=yes&characterEncoding=UTF-8
DestinationDB/user=...
DestinationDB/password=...