# import-from-sql-server

## Description

<mark style="color:purple;">`import-from-sql-server`</mark> *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.