PhloemDocs
Markdown
Integration

SQL Server

Microsoft SQL Server database

Category
Databases
Runs in
The Phloem cloud — nothing to install

Lets you and Hamming query a Microsoft SQL Server database in T-SQL, with its tables listed in Trace.

What Phloem reads

  • Tables, columns and foreign keys of every schema in the database you name, listed in Trace for Hamming and SQL autocomplete
  • Base tables only. Views are not listed, but you can still query them by name.

What you need

  • The server's host and port (default 1433), reachable from Phloem's cloud
  • The database name
  • A SQL Server login (username and password). A read-only login is best.

Connect

  1. In the console, open Connectors, choose Add connector, then SQL Server.
  2. Enter a Display Name, then Host, Port, Database, Username and Password.
  3. Under TDS Version, pick your server's protocol version (default 7.3 (SQL Server 2008+)).
  4. Choose Test Connection, then Create Connection.

What Hamming can do

  • Run T-SQL that you or Hamming write

Notes

  • Phloem runs any statement, not only SELECT. Connect with a read-only login.
  • Sign-in uses SQL Server authentication (username and password).

#Connection fields

What the Add connector form asks for.

FieldTypeRequired
Host
localhost
TextYes
Port
1433
Number—
Database
master
TextYes
Username
sa
Text—
PasswordSecret—
TDS Version
TDS protocol version
One of
7.0 (SQL Server 7.0) · 7.1 (SQL Server 2000) · 7.2 (SQL Server 2005) · 7.3 (SQL Server 2008+) · 7.4 (SQL Server 2012+)
—

Updated