Data Magazine
R&D Data Catalog
Configuration

Settings

Connection parameters and sync schedule. Settings are stored in your browser only — values entered here are not transmitted from this page.

Data acquisition

Where the catalog reads its source data. Configure whichever paths you have access to — multiple sources can be set up at once.

Collibra · API

OAuth 2.0 Client Credentials. Register an Integration-type application in Collibra (Settings → Manage OAuth applications) to obtain a Client ID and Client Secret.

Base URL
Your Collibra instance URL, no trailing slash.
Client ID
Client Secret
Request timeout
Seconds.

Collibra · Manual (XLSX)

Alternative ingest path for environments where the Python connector cannot reach Collibra directly (no outbound API allowed, no GitHub Actions, etc.). In Collibra, configure a view with the columns you want to publish, export it as XLSX, then run the conversion tool on any PC with Python 3.12+ to produce catalog.json. Drop the result into site-src/public/ and rebuild.

Workflow
Three steps, all offline after the export.
  1. Collibra UI → configure a view with the asset attributes you want → Export as XLSX.
  2. Run the conversion tool locally: python scripts/from_collibra_xlsx.py path/to/export.xlsx
  3. The tool writes site-src/public/catalog.json. Run npm run build and upload the site-src/out/ contents to SharePoint.
Conversion tool
Python 3.12+ required. Internet access not needed.

Not yet released. Collibra XLSX exports have no fixed schema — columns reflect whichever view was exported. The converter will ship once a real export sample from this tenant is available, so the column-name mapping can be validated against actual data rather than guessed.

SharePoint · API (Graph PowerShell)

Direct read/write to a SharePoint document library via Microsoft Graph, using a self-contained PowerShell script and the OAuth 2.0 device code flow (no Client Secret). Requires a Public Client app registration in Entra ID with delegated Sites.Read.All and Sites.ReadWrite.All. Used as a Folder view source.

SharePoint site URL
All document libraries under this site will be auto-enumerated.
Tenant ID
Provided by your Entra ID admin after app registration.
Client ID
Public client app ID. No client secret needed.
Fill in all three fields above to generate the PowerShell script.

SharePoint · Manual (Excel/CSV)

Read/write using SharePoint's built-in Export to Excel / Export to CSV (no admin approval required). Drop the exported files in here to import; write-back generates a CSV plus step-by-step Quick Edit instructions. Used as a Folder view source.

Folder view display

Which acquired source the Folder view page renders. This is a display switch only — it does not configure or trigger data acquisition above.

Display source

Pick which source to render in Folder view. Setup for each source lives under Data acquisition above.

Source

Site publishing

Auth for uploading the built static site to a SharePoint document library. Only needed if you want CI to push the site automatically — manual drag-and-drop into SharePoint never touches these settings.

SharePoint upload target (Microsoft Entra ID)

Register an app in Entra ID (Microsoft Graph: Sites.ReadWrite.All, Application permission) with admin consent. This is a separate registration from the device-code app used by the SharePoint · API source above.

Tenant ID
Client ID
Client Secret
SharePoint site URL
The site collection that will host the catalog.
Document library

Synchronization

When the Collibra connector should refresh the catalog. Manual runs are always available regardless of this setting.

Sync schedule

When the connector should pull from Collibra and refresh SharePoint. Manual runs are always available regardless of this setting.

Frequency
Time of day
Timezone
Manual run
No changes