Public | Automated Build

Last pushed: 5 months ago
Short Description
MSSQL source.
Full Description

Aries Integration for MS SQL Databases

This is an integration to fetch all data from a specified table in Microsoft's SQL Server. The result is then streamed out in JSON chunks, waiting to be picked up by the next activity. The keys of each object streamed out of the activity are lowercase transformed, due to redshift automatically lowercasing all column names. There will also be an added row_number column, containing the original row index of each row.

Configuration

URL

The url field should point to the url of a current SQL Server.

"url": "url",

Port

The port that the SQL Server is running on. Defaults to 1433 if not specified.

"port": "1433",

Database

The database that the query should be run against.

"database": "example_db",

User

The username used for authentication on the database.

"user": "root",

Password

The password associated with the user.

"password": "veryinsecure",

Table

The table to fetch data from.

"table": "dev",

DateTimeColumn

The name of a column of type datetime. Optional. If it exists,
the integration will query for rows where datetimeColumn is greater than or equal to the lastExecuted date
passed into onTask.

 "datetimeColumn: "updated"

Example Config

{
    url: 'localhost',
    port: '1433',
    database: 'example_db',
    user: 'root',
    password: 'veryinsecure',
    table: 'dev',
    datetimeColumn: 'updatedAt'
}

Reponse

The response is the results expected, in JSON format.

{"id":1, ...}
{"id":2, ...}
{"id":3, ...}
{"id":4, ...}
Docker Pull Command
Owner
astronomerio