Import & promote

1 min read Last updated Jun 16, 2026

Step 1 · Populate the staging schema

Download Efimis-1.0.sql and run it against your Microsoft SQL Server database. Populate the staging tables with your source data. See the Schema reference for field definitions and validation rules.

Step 2 · Import into the staging environment

Submit your MSSQL connection string to start the import. Our ETL system will read from your database and load the data into a provisioned staging tenant for validation.

Endpoint: POST /etl/import

Request body:

{
    "connectionString": "your-mssql-connection-string-here"
}

Response — 202 Accepted:

{
    "message": "Import request queued successfully.",
    "requestId": "unique-request-id"
}

Monitor the import status using GET /etl/import-status/{requestId}.

Step 3 · Validate

Step 4 · Promote to production

Once validation passes, promote the staged data to the live tenant.

Endpoint: POST /etl/promote-to-production

Request body:

{
    "requestId": "unique-request-id"
}

Response:

{
    "message": "Promotion to production started.",
    "requestId": "unique-request-id"
}

Track progress via GET /etl/import-status/{requestId}.