SQL Server Plugin ----------------- Supports direct access to an SQL Server database. References: * http://www.microsoft.com/sqlserver/ * http://jtds.sourceforge.net/ **Maven** :: org.geotools.jdbc gt-jdbc-sqlserver ${geotools.version} Note that the ``groupId`` is ``org.geotools.jdbc`` for this and other JDBC plugin modules. Connection Parameters ^^^^^^^^^^^^^^^^^^^^^ ============== ============================================ Parameter Description ============== ============================================ ``dbtype`` Must be the string ``sqlserver`` if using the Microsoft Driver, otherwise use ``jtds-sqlserver`` ``host`` Machine name or IP address to connect to ``port`` Port number to connect to ``instance`` Instance of Database to use (instead of port when multiple DB services are running) ``schema`` The database schema to access ``database`` The database to connect to ``user`` User name ``passwd`` Password ============== ============================================ Access ^^^^^^ Example use:: java.util.Map params = new java.util.HashMap(); params.put( "dbtype", "sqlserver"); params.put( "host", "localhost"); params.put( "port", 4866); params.put( "user", "geotools"); params.put( "passwd", "geotools"); DataStore dataStore=DataStoreFinder.getDataStore(params); Setup ^^^^^ Since GeoTools version 14 this module is compiled using the JTDS driver. The driver is still available, but in the meantime Microsoft released an open source version, while JTDS went unsupported. We recomment using the Microsoft JDBC driver, while the JTDS based data store factory is left for backwards compatibility. In either case, you don't have to do anything, both drivers are automatically downloaded by Maven (you might want to exclude one to reduce size).