Automated data scanning can serve as an alternative to manual object creation but most often, they complement each other.

After creating your business glossary, scan your data to:

  • Automatically detect where your business terms are used in your databases.
  • Create relations between your data and the business glossary.

A. Connect your data server

  1. Navigate to Settings inline-svg-1 > Data Ingestion > Connections.
  2. Click New connection and select your service, e.g., SQL Server.
  3. Name your connection for easier identification in Dawiso.
  4. Connect your servicefollowing the on-screen prompts:
    • Provide your e.g., SQL server credentials.
    • Test the connection and click Save.

B. Create a data source and scan your data

  1. Navigate to Settings inline-svg-1 > Data Ingestion > Data Sources.
  2. Click New data source.
  3. Select your service (here SQL Server) > connected server.
  4. Name your source (and add a description) for easier identification in Dawiso.
  5. Input the database name(s) you want to scan.
  6. Select your destination (e.g., the ‘Sales‘ space) where you want to load your data, and workflow type.
  7. Click the play  button and confirm to ingest your data.

C. Connect data to its business glossary terms

  1. Navigate to Space (‘Sales‘) > App (SQL Server).
  2. Select the object (column) to connect the glossary to.
  3. Scroll down to Business Relations and click  .
  4. Choose which glossary term (e.g., ‘Total Sales’) your column should be related to.
Tip

Your column is now connected to its definition!

Thanks to this connection, you make sure that all parties involved understand what data they are looking at. In Dawiso terms, you just created another relation between objects!