Marjory Apps Documentation

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.

Name	Type	Hidden
user	string	false
password	string	true
host	string	false
port	string	false

Create a datasource from a SQL table

Inputs

Name	Type	Description	Exemple	Required
database	string	Choose your database to enable selecting the table		true
tableName	string	The target table to insert the data into		true
schemaOverview	array	Describe the schema of the extracted data		true
whereClause	string	Where clause allowing to filter only the element you want to read in SQL (ex: orders.amount > 100 AND YEAR(orders.order_date) = 2023)	orders.amount > 100 AND YEAR(orders.order_date) = 2023	false

Outputs

Name	Type	Description	Exemple
datasource	object

Create a datasource from a query executed in SQL

Inputs

Name	Type	Description	Exemple	Required
database	string	Choose your database to enable selecting the table		true
query	string	Query allowing to filter only the element you want to read in SQL. Only one statement can be executed.	SELECT * FROM orders WHERE orders.amount > 100 AND YEAR(orders.order_date) = 2023;	true
schemaOverview	array	Describe the schema of the extracted data		true

Outputs

Version(s)

1.0.1

MSSQL

App Overview

Getting Started: Installations

App Items

Events

ETL_TASK

Read Table

Inputs

Outputs

Read Query Results

Inputs

Outputs

Technical Actions