Business Intelligence for INFOR M3
Click&DECiDE BAI Ad-Hoc Queries, Reporting Tool and Dashboards can be fully integrated with INFOR M3:
Smart Office integration
Click&DECiDE reports and Dashboards can be directly integrated in your INFOR Smart Office.
By using the M3 API, Click&DECiDE is able to access to all M3MI programs and transactions such as MDBREADMI, and preserves the integrity and the security of the M3 data. To simplify the life of the end user, we have created some functions such as, automatic conversion of the packed date, time, and timestamp fields.
Click&DECiDE can access to the iSeries database with our own interface or by using ODBC. Click&DECiDE can also import all query/400.
Click&DECiDE BI solution
Since our Version 16, Click&DECiDE is the perfect solution with INFOR M3 due to theses fonctionalities above, but it's not the only reason why Click&DECiDE it's the perfect product for you. We also have many functionalities that more than 1 000 companies are using since many years.
Ad Hoc queries:
We can work on any kind of data, and export in any format such as: Report, Dashboard, PDF, Excel files or real time, Power pivot, Power BI, Infor Smart Office, QlikView, etc.…
It is really easy to make your own query. You don’t even need to use your keyboard or to know the SQL language.
Simple to complex reports can be created with builder.
Dashboard & Pivot:
Direct on your Web Portal, you can create any kind of interactive Dashboard or dynamic Pivot..
You can create your own web portal skin, and report templates according to your graphic chart.
You can access to all your reports, dashboards, and pivots without installing any clients on your devices (computer, pad, or smart phone). Moreover, for Excel, Power BI, QlikView, etc..., the Web Portal is acting like a data hub, by following protocol such as: Web query, oDATA feed, REST, XML, RSS feed, and more. Finally, you can use our Web Portal to access to other applications.
Click&DECiDE allows you to join information of different sources. Per example you can make a single query, joining the production information coming from your iSeries, with your budget in Excel. And the result can be presented in a SQL server table.
Agile ETL functionality:
In addition to bufferise the result of your queries, by user or user groups, a query can generate automatically a data transfer from any database to SQL server. Moreover, those queries can be scheduled every night, hours… then the end users will only work on the SQL server. These features will prevent the end user to damage the database and overload the production server.
Scheduling task & keyword:
Keywords such as: last month, yesterday, etc. simplify the scheduling of your monthly, daily…reports. And the result can be displayed through a calendar interface.
Too much information kills the information. To avoid none relevant information, you can create alerts that will generate your reports only if your thresholds are achieves, and send the result by mail, or RSS feed.
The security, rights and parameters can be managed by user groups, or users, which can come from Active Directory or Click&DECiDE administration manager.