# Flux Configuration to read from SQL Server

**URL:** <https://community.influxdata.com/t/flux-configuration-to-read-from-sql-server/24101>\
**Category:** InfluxDB 2\
**Tags:** influxdb, query, flux\
**Created:** [March 3, 2022, 11:16am UTC](https://community.influxdata.com/t/flux-configuration-to-read-from-sql-server/24101 "2022-03-03T11:16:56Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![JMU](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@JMU](https://community.influxdata.com/u/JMU)\
**Post date:** [March 3, 2022, 11:16am UTC](https://community.influxdata.com/t/flux-configuration-to-read-from-sql-server/24101/1 "2022-03-03T11:16:56Z")

</div>

Hi everyone

In the query builder of our InfluxDB we want to read data from a SQL Server.  
How would it be the configuration?

> import “sql”
> 
> |\> sql.from(driverName: “sqlserver”, dataSourceName: “sqlserver://“user”:“password”@“server\_name”?database=database\_name”, query:"SELECT TOP (1000) \* FROM TABLE)

OR

> |\> sql.from(driverName: “sqlserver”, server=\*\*\*\*\*\*\*;user id=“user”;database=“database\_name”;

In Flux documentation the example is in postgre so i don’t know how to configure it.

Thanks beforehand
