sources

Add SQL Server connection

Create a new Microsoft SQL Server database connection.

POST /api/v1/sources/add/mssql/

Headers

Authorizationrequired

any - API key authentication using Bearer scheme

Request Body

typerequired

string - Connection type identifier. Must be `MSSQL`

account_name

string - Display name for the connection

hostname

string - SQL Server hostname

port

integer - Port number

username

string - Database username

password

string - Database password

database_name

string - Database name

connection_string

string - Alternative: ODBC connection string instead of individual parameters

Response

id

integer - The ID of the created connection

cURL

curl --request POST \
  --url https://api.camelai.com/api/v1/sources/add/mssql/ \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '{
  "type": "MSSQL",
  "account_name": "SQL Server",
  "hostname": "db.example.com",
  "port": 1433,
  "username": "db_user",
  "password": "secure-password",
  "database_name": "analytics",
  "connection_string": "postgresql://db_user:secure-password@db.example.com:5432/analytics"
}'

200

{
  "id": 123
}