import-from-sql-server

Description

import-from-sql-server adaptor imports data from a Microsoft SQL Server database.

Inputs

hostname Type: text Required: Yes The hostname (e.g., localhost) or the IP address (e.g., 127.0.0.1) of the database server.

port Type: number Required: No The port of the database server. If unspecified, defaults to 1433.

database Type: text Required: Yes The name of the database.

username Type: text Required: No The username to connect to the database.

password Type: text Required: No The password to connect to the database.

query Type: text Required: Yes The SQL query reading from the database (e.g., SELECT * from table WHERE ...).

Outputs

data Type: datatable A datatable containing the imported data.

Examples

Example 1: Default behaviour.

Inputs:

hostname: localhost

database: demoDB

username: demo_user

password: demo_password

query:

SELECT 1 AS field1, 'a' AS field2
UNION
SELECT 2 AS field1, 'b' AS field2
UNION
SELECT 3 AS field1, 'c' AS field2

Outputs:

data:

field1	field2
1	a
2	b
3	c

-> Imported data from SQL server database into Data-flo.