Skip to main content

​
What is a data source?

A data source is a connection and configuration to external data that the AI Skills in the Skill Store use for analysis. OneS1ght does not copy your data — it stores only the connection details plus settings (columns, types, filters, mapping) and derives the data by applying those settings at query time. The file connector keeps the original as the stored source, while the database and API connectors read live on every query.
This screen is available to Manager and above (owner, manager) only. Menu visibility manage.

​
Three connector families

Depending on the shape of the source, you connect a data source through one of three connector families.

File

Upload CSV, JSON, or Excel files. The original is stored on registration.

Database

Connect to PostgreSQL, MySQL, MS-SQL, Oracle, or MongoDB and read live at query time.

Service (API · OData)

Call an HTTP API or OData service live at query time.
External service integrations (SaaS, etc.) are marked “Coming soon” and will be added in a later iteration.

​
List screen

Use + Add data source to open the wizard, and click a row to open its detail screen. The list supports search, connector filter, sort (Newest, Oldest, Title ↑, Title ↓), and pagination (8 per page).

​
The shared 4-step wizard

Every connector follows a common 4-step flow. File and API connectors add extra steps up front depending on the format (see each connector page).
1

Select connector

Choose the connector that matches your source — File, Database, or Service.
2

Data view · filter

Preview the source (top 100 rows) and add filters so only matching rows are used.
3

Field mapping

For each column, set a Meaning (required, standard field name) and Detail (optional). You can use ✨ AI auto-mapping.
4

Register

Enter a name, review the settings, and register the data source.

​
Filter operators

equals (=) · not equal (≠)

Exact text/number match

contains

Substring match

greater than (>) · less than (<)

Numeric comparison

not empty

Rows where a value exists
Multiple conditions are combined with AND — only rows that satisfy all of them are used.

​
Column types

Text · Number · True/False · Date · Object (JSON)

​
Detail screen

The detail screen shows:
  • Settings: connector, source, header row, filters, and row count. Files show source stored; DB and API show live source.
  • Columns · mapping table: column name, type, meaning, detail.
  • AI Skill output: the exact form passed to the AI Skill (LLM) — metadata (schema, meaning) plus data (up to 100 rows). Table view / JSON tabs.

​
Credential security

Credentials such as database passwords and API keys/headers are encrypted with AES-256-GCM and are never returned to the client. When you edit a data source, leaving a credential field blank keeps the existing value.
Editing a data source never changes the original. Only the settings (columns, types, filters, mapping) change.