All Projects → tds-fdw → Tds_fdw

tds-fdw / Tds_fdw

Licence: other
A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)

Programming Languages

c
50402 projects - #5 most used programming language

Projects that are alternatives of or similar to Tds fdw

Prest
PostgreSQL ➕ REST, low-code, simplify and accelerate development, ⚡ instant, realtime, high-performance on any Postgres application, existing or new
Stars: ✭ 3,023 (+1170.17%)
Mutual labels:  hacktoberfest, postgresql, databases
Nodebb
Node.js based forum software built for the modern web
Stars: ✭ 12,303 (+5069.33%)
Mutual labels:  hacktoberfest, postgresql
Pos
Stars: ✭ 150 (-36.97%)
Mutual labels:  hacktoberfest, postgresql
Uyuni
Source code for Uyuni
Stars: ✭ 169 (-28.99%)
Mutual labels:  hacktoberfest, postgresql
Msbuild.sdk.sqlproj
An MSBuild SDK that provides similar functionality to SQL Server Data Tools (.sqlproj) projects
Stars: ✭ 142 (-40.34%)
Mutual labels:  hacktoberfest, sql-server
Sqlcell
SQLCell is a magic function for the Jupyter Notebook that executes raw, parallel, parameterized SQL queries with the ability to accept Python values as parameters and assign output data to Python variables while concurrently running Python code. And *much* more.
Stars: ✭ 145 (-39.08%)
Mutual labels:  hacktoberfest, postgresql
Manage Fastapi
🚀 CLI tool for FastAPI. Generating new FastAPI projects & boilerplates made easy.
Stars: ✭ 163 (-31.51%)
Mutual labels:  postgresql, databases
Dbatools
🚀 SQL Server automation and instance migrations have never been safer, faster or freer
Stars: ✭ 1,742 (+631.93%)
Mutual labels:  hacktoberfest, sql-server
Nut
Advanced, Powerful and easy to use ORM for Qt
Stars: ✭ 181 (-23.95%)
Mutual labels:  postgresql, sql-server
Obevo
Obevo is a database deployment tool that handles enterprise scale schemas and complexity
Stars: ✭ 192 (-19.33%)
Mutual labels:  postgresql, sql-server
Linqpad.queryplanvisualizer
SQL Server and PostgreSQL query execution plan visualizer for LINQPad
Stars: ✭ 209 (-12.18%)
Mutual labels:  postgresql, sql-server
Nosqlmap
Automated NoSQL database enumeration and web application exploitation tool.
Stars: ✭ 1,928 (+710.08%)
Mutual labels:  hacktoberfest, databases
Pytest Postgresql
This is a pytest plugin, that enables you to test your code that relies on a running PostgreSQL Database. It allows you to specify fixtures for PostgreSQL process and client.
Stars: ✭ 127 (-46.64%)
Mutual labels:  hacktoberfest, postgresql
Querybuilder
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
Stars: ✭ 2,111 (+786.97%)
Mutual labels:  postgresql, sql-server
Transformalize
Configurable Extract, Transform, and Load
Stars: ✭ 125 (-47.48%)
Mutual labels:  postgresql, sql-server
Pg hashids
Short unique id generator for PostgreSQL, using hashids
Stars: ✭ 164 (-31.09%)
Mutual labels:  postgresql, postgresql-extension
Chartbrew
Open-source web platform for creating charts out of different data sources (databases and APIs) 📈📊
Stars: ✭ 199 (-16.39%)
Mutual labels:  hacktoberfest, postgresql
Plsh
PL/sh is a procedural language handler for PostgreSQL that allows you to write stored procedures in a shell of your choice.
Stars: ✭ 111 (-53.36%)
Mutual labels:  postgresql, postgresql-extension
Decoderbufs
INACTIVE: A PostgreSQL logical decoder output plugin to deliver data as Protocol Buffers
Stars: ✭ 116 (-51.26%)
Mutual labels:  postgresql, postgresql-extension
Agensgraph Extension
A graph database extension for PostgreSQL
Stars: ✭ 170 (-28.57%)
Mutual labels:  postgresql, postgresql-extension

TDS Foreign data wrapper

  • Author: Geoff Montee
  • Name: tds_fdw
  • File: tds_fdw/README.md

Logo

Logo SVG

About

This is a PostgreSQL foreign data wrapper that can connect to databases that use the Tabular Data Stream (TDS) protocol, such as Sybase databases and Microsoft SQL server.

This foreign data wrapper requires a library that implements the DB-Library interface, such as FreeTDS. This has been tested with FreeTDS, but not the proprietary implementations of DB-Library.

This should support PostgreSQL 9.2+.

The current version does not yet support JOIN push-down, or write operations.

It does support WHERE and column pushdowns when match_column_names is enabled.

Build Status

centos7 ubuntu18.04
PostgreSQL 9.5 Build Status Build Status
PostgreSQL 9.6 Build Status Build Status
PostgreSQL 10 Build Status Build Status
PostgreSQL 11 Build Status Build Status
PostgreSQL 12 Build Status Build Status
PostgreSQL 13 Build Status Build Status

Installing on CentOS

See installing tds_fdw on CentOS.

Installing on Ubuntu

See installing tds_fdw on Ubuntu.

Installing on Debian

See installing tds_fdw on Debian.

Installing on openSUSE

See installing tds_fdw on openSUSE.

Installing on OSX

See installing tds_fdw on OSX.

Usage

Foreign server

See creating a foreign server.

Foreign table

See creating a foreign table.

User mapping

See creating a user mapping.

Foreign schema

See importing a foreign schema.

Variables

See variables.

Notes about character sets/encoding

  1. If you get an error like this with MS SQL Server when working with Unicode data:

    NOTICE: DB-Library notice: Msg #: 4004, Msg state: 1, Msg: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier., Server: PILLIUM\SQLEXPRESS, Process: , Line: 1, Level: 16
    ERROR: DB-Library error: DB #: 4004, DB Msg: General SQL Server error: Check messages from the SQL Server, OS #: -1, OS Msg: (null), Level: 16

    You may have to manually set tds version in freetds.conf to 7.0 or higher. See The freetds.conf File. and Choosing a TDS protocol version.

  2. Although many newer versions of the TDS protocol will only use USC-2 to communicate with the server, FreeTDS converts the UCS-2 to the client character set of your choice. To set the client character set, you can set client charset in freetds.conf. See The freetds.conf File and Localization and TDS 7.0.

Encrypted connections to MSSQL

It is handled by FreeTDS, so this needs to be configured at the freetds.conf. Seee The freetds.conf File and at freetds.conf settings look for encryption.

Support

If you find any bugs, or you would like to request enhancements, please submit your comments on the project's GitHub Issues page.

Additionally, I do subscribe to several PostgreSQL mailing lists including pgsql-general and pgsql-hackers. If tds_fdw is mentioned in an email sent to one of those lists, I typically see it.

Debugging

See Debugging

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].