M
Marian Edu
Guest
Hi, now that someone else ask the same question it suddenly hit me there can't really be a trial/evaluation version since this is more a solution than a product and it also include predefined database (warehouse, maybe staging) schema, reports, dashboards and KPI's (most likely per industry verticals) and those sort of things aren't just made available as trial version 
If you only want to get the tool(s) then check out Pentaho's data integration solution - Kettle and for reporting/analytics the solution seems to work with LogiAnalytics products. As for data connectivity Kettle have a number of jobs that lets you get data from database tables, insert/update/delete records and even call stored procedures... this is using JDBC so any database that provides such a drivel will work, the one that comes bundled with OE should work as well. If you need more that plain raw data access we do have a JDBC driver that let you access the business logic layer through the application server (currently working on a version that can do that using akera.io appsrv) that lets you call 4gl business logic that can return result set(s) back to the JDBC client using the stored procedure interface or define custom business views that looks like tables for the client only the data is prepared by 4g - http://acorn.ro/products/abl-jdbc/ The same is true for LogiAnalytics as their deployment product can work with JDBC, however the designer being a .net application can only work with odbc/ado/oledb but there are a number of other solutions that you can evaluate: Pentaho Reporting, Jasper Reports, Birt to only name a few. As for the last question even if the solution come with a predefined datawarehouse structure the mappings in ETL jobs still need to be updated/created to match your source database structure, probably extra transformation steps will also be required so I think it's save to say the ETL part will pretty much need to be redo for your specific data source(s)... however, having a predefined data warehouse database structure all reports/dashboards bundled in will work out of the box unless you need to have those adapted to your needs but can still be a big plus. Good luck. Marian Edu Acorn IT www.acorn-it.com www.akera.io
Continue reading...
If you only want to get the tool(s) then check out Pentaho's data integration solution - Kettle and for reporting/analytics the solution seems to work with LogiAnalytics products. As for data connectivity Kettle have a number of jobs that lets you get data from database tables, insert/update/delete records and even call stored procedures... this is using JDBC so any database that provides such a drivel will work, the one that comes bundled with OE should work as well. If you need more that plain raw data access we do have a JDBC driver that let you access the business logic layer through the application server (currently working on a version that can do that using akera.io appsrv) that lets you call 4gl business logic that can return result set(s) back to the JDBC client using the stored procedure interface or define custom business views that looks like tables for the client only the data is prepared by 4g - http://acorn.ro/products/abl-jdbc/ The same is true for LogiAnalytics as their deployment product can work with JDBC, however the designer being a .net application can only work with odbc/ado/oledb but there are a number of other solutions that you can evaluate: Pentaho Reporting, Jasper Reports, Birt to only name a few. As for the last question even if the solution come with a predefined datawarehouse structure the mappings in ETL jobs still need to be updated/created to match your source database structure, probably extra transformation steps will also be required so I think it's save to say the ETL part will pretty much need to be redo for your specific data source(s)... however, having a predefined data warehouse database structure all reports/dashboards bundled in will work out of the box unless you need to have those adapted to your needs but can still be a big plus. Good luck. Marian Edu Acorn IT www.acorn-it.com www.akera.ioContinue reading...