Microsoft SQL Server

Connect Microsoft SQL Server to Felt to map spatial tables and views or query them with SQL.

Available on the Business and Enterprise plans. Compare plans

Connect a Microsoft SQL Server database to add its spatial tables and views to maps or query them with SQL. Felt places features on the map from geometry and geography columns.

Connect Microsoft SQL Server

Create a read-only database user for Felt with access to the tables you want to use. Then follow the steps in Add a source and select Microsoft SQL Server. If the database accepts connections only from known addresses, allow Felt's IP addresses.

In Connection, fill in these fields, or click Autofill and paste a connection string such as mssql://read_only:password@your-mssql-host:1433/your_database.

Field	Required	What to enter
Host	Yes	The SQL Server host name or IP address. It can't be localhost.
Port	Yes	The SQL Server port. The default is 1433.
Database	Yes	The name of the database.
Username	Yes	The database user you created for Felt, not your Felt login.
Password	Yes	That user's password. Felt hides it after you save.