CREATE SERVER svr_myss
   FOREIGN DATA WRAPPER ogr_fdw
    OPTIONS (datasource 'ODBC:myuser/mypassword@MYSS',format 'ODBC');

CREATE SERVER svr_myss
   FOREIGN DATA WRAPPER ogr_fdw
   OPTIONS (datasource 'MSSQL:server=localhost,1433;database=mygisdb;user=myuser;password=mypassword',format 'MSSQLSpatial');

CREATE SERVER svr_myss
   FOREIGN DATA WRAPPER ogr_fdw
        OPTIONS (datasource 'ODBC:myuser/mypassword@MYSS,dbo.User,dbo.AnotherTable',
format 'ODBC');

SELECT * INTO myss.orders FROM myss.dbo_orders;

CREATE MATERIALIZED VIEW myss.vw_orders