Inforiver
EDITable
EDITable
  • Introduction to EDITable
    • Why EDITable?
    • Supported Database Connections
  • Get Started
    • EDITable Pre-requisites
      • Admin consent for EDITable's Entra ID
        • Basic consent
        • Full admin consent
    • Install EDITable
    • Add EDITable visual
  • Getting Data into EDITable
    • Connect to Data
      • Get data
      • Assign fields
      • Configuration Steps
        • Configure source
        • Configure Columns
        • Configure Type 2 SCDs (Optional)
    • Create a Table
      • Create From Scratch
      • Use Existing Table
      • Import Data
  • Working with EDITable
    • EDITable interface
    • Manage Columns
      • General
      • Constraints
      • Lookup and Relation
      • Display
      • Import/Export Configuration
      • Add Database Column
      • Insert Column
    • Column Access Control
    • Row Identification
    • Table Operations (Insert/Update/Delete)
      • Edit data
      • Bulk Edit
      • Find and Replace
      • Insert rows
      • Insert Column
      • Import rows
      • Delete rows
      • Duplicate rows
      • Copy rows
      • Preview Changes
      • Reset Changes
    • Explore data
      • Search and filter
      • Sort and reorder
      • Show/Hide columns
      • Pin columns
      • Group Rows By
      • Summarize Column
    • Basic formatting
    • Conditional Formatting
  • Row Access Control
  • Approval Workflow
    • Review Changes - Workflow process
  • Type 2 SCDs
    • Configuring Type 2 SCDs in EDITable
  • Audit logs
  • Webhook
  • Display Settings
  • Commenting and Collaboration
    • Assign users & task status
    • View all comments & track changes
    • Comment Settings
  • Admin Portal & EDITable Console
    • Tables
    • Transaction Logs
    • Insights (Metrics)
    • Utility
      • Download Report
      • Pipeline
        • Power BI & EDITable deployment pipelines
        • Deployment in different destinations
        • Trigger deployment pipeline from external applications
        • Logs & other pipeline options
    • Manage Profile
    • Admin Portal
      • User Management
      • Settings
        • General Settings
        • Writeback Settings
          • Settings
          • EDITable managed DB
        • API token
    • Onboarding Actions
  • Formula and Functions
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEIF
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • LOG
      • MAX
      • MIN
      • PCT
      • POWER
    • Text formatting functions
    • Date functions
      • DATE
      • DATE.FORMAT
    • Other operators
  • Keyboard Shortcuts
  • Release Notes
    • EDITable - v1.7.5
    • EDITable - v1.7
    • EDITable - v1.6.5
    • EDITable - v1.6
Powered by GitBook
On this page
  • Databases Supported
  • Key Features in EDITable

Introduction to EDITable

Master Data Management with Workflows, Audit & Governance

NextWhy EDITable?

Last updated 3 months ago

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 a self-service data management platform within Power BI, empowering business users with little assistance from IT for setup and management.

EDITable creates a table for you in the database and provides a pre-configured Power BI report with a live connection to the table. This enables you to update and manage them in real time.

With EDITable, you can:

Along with these core capabilities, EDITable provides robust data security and governance features, including row and column-level access controls, audits, and approval workflows. It also enables seamless collaboration and integration through commenting, webhooks, and historical data tracking with type 2 SCDs.

EDITable supports forward-looking master data that is needed for plans but has not yet been created in your tables. Whether you are a business user or a database administrator, you can leverage EDITable to suit your needs.

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, Fabric SQL, 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:

  1. Centralized data management for both reference data and flat tables.

  2. Execute CRUD actions on data platforms without any code or extensive customizations.

  3. Writeback and sync your data in real-time, anywhere.

  4. Robust data governance with row and column-level access controls.

  5. Audit logs & approval workflows for change management.

  6. Set up a rule-based approval system.

  7. Support for lookup tables to create custom rules for approvals.

  8. Support for Type 2 SCDs, table editing, and condition-based formatting.

  9. Supports bulk edits and updates.

  10. Collaborate effectively with your team with the commenting capabilities and also notify them via email.

  11. No-code experience and designed for business users.

Build your database from scratch on the required data platforms easily.

Quickly migrate your Excel or CSV data files to your desired destination platforms to manage them.

Update and work with your existing databases in real-time by connecting to them within Power BI.

✅
✅
✅
Manage Reference data and Flat tables
Supported databases
Key Features in EDITable
Page cover image