@kapa.ai How do I setup my self hosted instance of airbyte to get data from share point

To pull data from SharePoint into a self‑hosted (OSS) Airbyte instance, you’ll use the Microsoft SharePoint source connector. ### 1. Make sure Airbyte OSS is running If you haven’t already, deploy Airbyte Self‑Managed Community locally (Docker +

abctl

) and access the web UI. [[OSS quickstart](https://docs.airbyte.com/platform/1.6/using-airbyte/getting-started/oss-quickstart)] ### 2. Create an Azure AD app for SharePoint (Graph API) You need an application with Application permissions in Azure AD to let Airbyte read files from SharePoint. [[SharePoint setup](https://docs.airbyte.com/integrations/sources/microsoft-sharepoint#step-1-set-up-sharepoint-application)] High‑level steps: 1. Go to [Azure Portal](https://portal.azure.com/#home) → Azure Active Directory → App registrations → New registration. 2. Register the app (single‑tenant is fine) and note: - Application (client) ID - Directory (tenant) ID 3. Under Certificates & secrets, create a client secret and copy its value. 4. Under API permissions → Add a permission → Microsoft Graph → Application permissions: - Add at least:

Files.Read.All

. [[SharePoint setup](https://docs.airbyte.com/integrations/sources/microsoft-sharepoint#step-1-set-up-sharepoint-application)] 5. Click Grant admin consent. You now have: - Tenant ID - Client ID - Client secret ### 3. Configure the Microsoft SharePoint source in Airbyte OSS In your self‑hosted Airbyte UI: [[SharePoint OSS setup](https://docs.airbyte.com/integrations/sources/microsoft-sharepoint#step-2-set-up-the-microsoft-sharepoint-connector-in-airbyte)] 1. Go to Sources → + New source. 2. Choose Microsoft SharePoint as the source type. 3. Enter a Name for the source. 4. Set Search Scope: -

ACCESSIBLE_DRIVES

– all SharePoint drives the user can access -

SHARED_ITEMS

– shared items only -

ALL

– both (default) [[SharePoint source](https://docs.airbyte.com/integrations/sources/microsoft-sharepoint)] 5. Folder Path: optional; leave empty to search all folders (not applied to shared items). [[SharePoint source](https://docs.airbyte.com/integrations/sources/microsoft-sharepoint)] 6. Switch auth to Service Key Authentication. 7. Fill in: - User Principal Name (UPN) for the user (e.g.

<mailto:user@company.com|user@company.com>

) [[SharePoint OSS setup](https://docs.airbyte.com/integrations/sources/microsoft-sharepoint#step-2-set-up-the-microsoft-sharepoint-connector-in-airbyte)] - Tenant ID - Client ID - Client secret 8. Start Date:

YYYY-MM-DD

– only data added on/after this date will be replicated. [[SharePoint OSS setup](https://docs.airbyte.com/integrations/sources/microsoft-sharepoint#step-2-set-up-the-microsoft-sharepoint-connector-in-airbyte)] ### 4. Define what files to sync (streams) Still in the source setup: [[SharePoint source](https://docs.airbyte.com/integrations/sources/microsoft-sharepoint)] 1. Add a stream: - File Type (e.g.

csv

,

jsonl

, etc.). - Format: choose one of

CSV

,

Parquet

,

Avro

, or

JSONL

. - Name: logical name for this stream. - Optional: - Input schema (JSON) if you want to enforce a schema; otherwise

{}

to infer automatically. - Globs to pattern‑match which files to sync (e.g.

**

for all files). 2. Click Set up source and test the connection. ### 5. Create a destination and connection 1. Add a destination (e.g. Postgres, Snowflake, S3, etc.) in Airbyte. 2. Create a Connection from your Microsoft SharePoint source to that destination. 3. Choose sync mode (Full Refresh / Incremental) and schedule. [[SharePoint file settings](https://docs.airbyte.com/integrations/sources/microsoft-sharepoint#copy-raw-files-configuration)] ### 6. (Optional) Copy raw files instead of parsing If you just want to move files as‑is (e.g. for unstructured or binary data) and your Airbyte version/destination supports it, enable Copy Raw Files in the SharePoint source’s file‑based settings. Files are copied bit‑for‑bit without parsing. [[Copy raw files](https://docs.airbyte.com/integrations/sources/microsoft-sharepoint#copy-raw-files-configuration)] --- If you share what destination you’re using (e.g. S3, warehouse, DB), I can outline the minimal connection settings for that combo specifically.