EnableYourData.nl

Integration · AFAS Profit

AFAS Profit in Power BI. Via your own data warehouse.

For AFAS Power BI dashboards, you load data from AFAS Profit via the API, for example with GetConnectors, into your own data warehouse. There the data is modelled, after which you use it in ENABLE. ENABLE has no built-in AFAS connector; the connection runs via the warehouse.

Book a demo All integrations
Via your data warehouseERP and accounting

AFAS Profit often holds the core of an organisation: finance, HR, projects and orders. With AFAS Power BI reporting, you make that data visible in dashboards and combine it with other sources, such as your CRM or planning.

In ENABLE you use AFAS data via your own data warehouse. The data is loaded outside the portal via the AFAS Profit API, for example with a standard connector or a custom integration on GetConnectors, and then modelled. Dashboards, the SQL Explorer and the Data API then read from the same model.

In ENABLE

What you do with AFAS Profit data

Financial dashboard

Revenue, costs and result per month from the G/L transactions, compared with budget and last year.

Projects and hours

Hours booked, costs and invoicing per project side by side, so you see where project results are under pressure.

HR dashboard with restricted access

Staffing, starters and leavers per department, visible only to the people who are allowed to see it.

Ask questions in plain language

In the SQL Explorer you ask, for example, for outstanding receivables per customer group. The AI writes the SQL on your warehouse.

Combine with other sources

Put AFAS data alongside your CRM, planning or online shop in one model, with shared keys such as customer or project number.

Steps

How to use AFAS data in ENABLE

  1. 1IntakeWe determine which AFAS data and administrations are needed and choose the best loading route.
  2. 2Loading into your data warehouseData is loaded via the AFAS Profit API into your own PostgreSQL warehouse, outside the ENABLE portal.
  3. 3ModellingTransactions, projects and relations are transformed into a model with fixed definitions.
  4. 4Dashboards and AI in ENABLEPower BI reports and the SQL Explorer use the model. ENABLE reads encrypted and read-only.
  5. 5Access by roleAccess profiles and row-level security determine who sees which figures, for example per department or administration.

Access AFAS data with GetConnectors

With an AFAS integration, you use GetConnectors in AFAS Profit to determine which data is available via the API. For each connector you choose which fields it contains, and you link the connectors to an app connector with its own token. That is also a form of governance: only the fields you need for reporting leave AFAS.

Whether you load the data with a standard connector or a custom integration on those GetConnectors is decided during the intake. ENABLE itself does not connect to AFAS Profit; the portal connects only to your data warehouse, encrypted and read-only.

AFAS Power BI reporting with sensitive data

AFAS often contains personal data, such as employees and salaries. For AFAS reporting, it is therefore important to choose deliberately what you load and who sees what.

  • Load only the fields you really need; you already control that in the GetConnector.
  • Use access profiles and row-level security, so a manager sees only their own department.
  • The AI in the SQL Explorer receives only table and column names, never rows of data. Every executed query is recorded in the audit log.
  • The activity log shows client administrators who did what in the portal.

FAQ

Frequently asked questions

Does ENABLE have a standard integration with AFAS?

No, not as a built-in connector. The data comes via your data warehouse: AFAS Profit data is loaded via the API, for example with a standard connector or a custom integration on GetConnectors, and then used in ENABLE. We determine the best loading route during the intake.

How do I create AFAS Power BI dashboards?

Load the AFAS data via the API into a data warehouse, build a model with fixed definitions there and create the Power BI reports on that model. In ENABLE you then share those dashboards with access by role.

Can I use HR data from AFAS securely in dashboards?

Yes, provided you choose deliberately what you load and who sees what. With access profiles and row-level security, you determine per user which dashboards and rows are visible. Load only the fields you really need.

Can I ask AI questions about my AFAS data?

Yes, if the data is in your data warehouse. In the SQL Explorer, the AI converts your question into SQL. The AI sees only table and column names, no rows of data, and every executed query is recorded in the audit log.

See AFAS Profit data in ENABLE?

In a demo we show how data from AFAS Profit reaches dashboards, plain-language questions and apps via your data warehouse. Book a demo and bring your questions.

Book a demo info@enableyourdata.nl