Introduction to EDITable*
EDITable is a no-code, live writeback product that lets you create and manage your master tables/reference data/metadata and flat tables for your reporting & planning applications.
It complements your Master Data Management (MDM) solution as self-service data management platform within Power BI, empowering business users with little assistance from IT for setup and management.
Databases Supported
Choose your preferred database connections to create, migrate and manage data seamlessly. EDITable supports a wide range of cloud-based and on-premise databases including Fabric Warehouse, Azure SQL, Snowflake, Databricks, BigQuery, Amazon Redshift, and PostgreSQL.
Whether you're importing your spreadsheet data into these connections, or connecting to existing databases to manage them, Editable has it all.
Key Features in EDITable
The capabilities of EDITable include:
Centralized data management for both reference data and flat tables.
Execute CRUD actions on data platforms without any code or extensive customizations.
Writeback and sync your data in real-time, anywhere.
Robust data governance with row and column-level access controls.
Audit logs & approval workflows for change management.
Set up a rule-based approval system.
Support for lookup tables to create custom rules for approvals.
Support for Type 2 SCDs, table editing, and condition-based formatting.
Supports bulk edits and updates.
Collaborate effectively with your team with the commenting capabilities and also notify them via email.
No-code experience and designed for business users.
Using EDITable
EDITable not only creates a table for you in the database, but also provides a pre-configured Power BI report with a live connection to the table. This enables you to update and manage them real-time.
✅ If you are starting to build and develop your database, use EDITable's interface to create a table in the above destinations easily.
✅ If you have your data residing in Excel or CSV files, you can quickly migrate them to your desired destination platforms.
✅ If your data already resides in any of the mentioned databases, just connect to them through EDITable to update them.
EDITable supports forward-looking master data that is needed for plans but has not yet been created in your tables. You can be a business user or a database administrator, you can leverage EDITable to suit your needs.
*This document is a work in progress
Last updated