MSSQL to OData Bridge is a lightweight service built on Flask, designed to facilitate a seamless integration between Microsoft SQL Server and OData. This project overcomes the limitations of tools like Tableau Public, which do not natively support connections to MSSQL databases, by exposing MSSQL data as an OData service.

Key Features

• Standalone, Docker, or Composer: The service can be run in different environments.
• MSSQL Server Connectivity: Effortlessly connect to and interact with MSSQL Server.
• Configurable SQL Server Details: Easily customize SQL Server settings to fit specific use cases.
• Table and View Information Display: Access detailed information about the tables, views, and their objects.
• OData Service: Share content as OData, allowing for easy integration with various applications.

Why Choose This Project?

The inability of Tableau Free to connect directly to Microsoft SQL Server is a common challenge. This project addresses that pain point by creating a bridge, enabling data visualization and analysis through OData services.

Usage Example

Once the service is running, users can access their MSSQL data via the following URL structure:

http://localhost:5000/odata/v4/{database}/{table_or_view}

Configuration Details

Upon the initial run, the user will be guided to configure the SQL Server connection settings, which will be stored in a JSON file for future use.

Contributions are welcomed, and users are encouraged to submit pull requests or report issues. Support is also available for those who appreciate the work put into this project.