B2Data is a platform to simplify and streamline the processing of business data to allow companies to fetch data from multiple data sources, prepare, cleanse, and transform it to create insightful data presentation using the strength of Excel, or feed BI systems or other systems for further use
B2Data is based on a modular workflow-architecture, business users can intuitively create data scenarios with almost no programming needed to be run on-demand or fully automated
Easily fetch data, directly from any database including Infor LN, Baan ERP or any other database.
Use VisualQuery node to drag-and-drop tables, connect tables, search and choose the fields you need for the task or report without writing any SQL code.
Use our Query node to write your own SQL query or simply paste a query.
Define JAVA variables or properties, and use them in your SQL statement!
Coming Soon
Modify ERP reports without customizing the ERP or use the data from ERP canned reports to generate new reports.
Structure and unify the data from multiple data sources
Use DataPrep node to drag-and-drop tables from different sources, reorder, rename fields, remove unwanted columns, change datatypes and enrich your data by inserting new calculated fields using our advanced scripting editor with autocomplete.
Join different types of datasources (such as Excel, CSV, SQL…), with, auto-suggested, transformation options that can help you fix common pre-join issues, convert some mismatched datatypes on the fly and save time!
Create insightful reports utilizing the power of Excel or send the data to an external BI system.
Automatic creation of visual Excel reports from multiple data sources
An example of a fully-generated Excel Report with different views/sheets:
An example for a fully generated Excel Report with different views/sheets:
Deliver data in different ways and methods, such as API, XML, JSON, Excel File, PDF, CSV, Email, Archive, DMS, Printer and more.
Some of the delivery methods above are coming soon…
Contact us for more Information
Deploy to production for Live Workflows, running in the background, ready to receive “run requests” from users (manually or via input-form), triggers, scheduling or API.
Schedule data workflows to perform at a particular time.
Set triggers based of file or folder change or on HTTP requests and much more!
Securely publish Report workflows globally across your organization with permissions per user or department.
Infor native features (Infor Cloudsuite, LN on-prem, M3 on-prem)
Related blog article:
The challenge of extracting data from Baan and Infor LN database
The API makes it easy for customer and developers to create applications and interface between B2Data and your business application.
