---
title: How to configure the SJS ODBC Connector
description: How to configure the SJS ODBC Connector
---

[Skip to content](https://kb.optymyse.com/how-to-configure-the-sjs-odbc-connector#main-content)

[![optymyse-pos](https://kb.optymyse.com/hubfs/optymyse-pos.svg)](https://kb.optymyse.com/?hsLang=en)

Open main navigation

Close main navigation

- [Contact us](https://www.optymyse.com/)

[Contact us](https://www.optymyse.com/)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Optymyse](https://kb.optymyse.com/?hsLang=en)
2. [Installation and Deployment](https://kb.optymyse.com/installation-and-deployment?hsLang=en)
3. [Connector Configuration](https://kb.optymyse.com/installation-and-deployment?hsLang=en#connector-configuration)

October 13, 2025

# How to configure the SJS ODBC Connector

The ODBC Connector for Optymyse 5.1.x allows you to connect any data source with an ODBC driver to an Optymyse 5.1.x installation (Cloud or On Premise).

For example, you may have data in any one of the following:

SQL Server, Oracle or MySQL database

MS Excel spreadsheet

SalesForce.com

etc.

The ODBC connector allows you to specify an ODBC connection using either a defined DSN, or by specifying the full connection details in the configuration. You may also specify the query to execute on that ODBC connection - this will usually be a SELECT query of some kind; the actual content and format of the query will be dependent on the data source.

To use the ODBC connector for multiple sources you need a feed license per query.

Please download our full PDF below for more information.

[ODBC Connector for Optymyse 5.1.x-v7-20180531\_1209.pdf](https://kb.optymyse.com/hubfs/Knowledge%20Base/ODBC%20Connector%20for%20Optymyse%205.1.x-v7-20180531_1209.pdf?hsLang=en)

- [Using Optymyse](https://kb.optymyse.com/using-optymyse?hsLang=en#main-content)

    - [Getting Started](https://kb.optymyse.com/using-optymyse?hsLang=en#getting-started)
    - [Optymyse Display and Agile](https://kb.optymyse.com/using-optymyse?hsLang=en#optymyse-display-and-agile)
    - [Installation](https://kb.optymyse.com/using-optymyse?hsLang=en#installation)
    - [Permissions](https://kb.optymyse.com/using-optymyse?hsLang=en#permissions)
    - [Triggers](https://kb.optymyse.com/using-optymyse?hsLang=en#triggers)
    - [Optymyse Director - Designer](https://kb.optymyse.com/using-optymyse?hsLang=en#optymyse-director-designer)
    - [Features](https://kb.optymyse.com/using-optymyse?hsLang=en#features)
- [Purchasing](https://kb.optymyse.com/purchasing?hsLang=en#main-content)

    - [Accounts and Billing](https://kb.optymyse.com/purchasing?hsLang=en#accounts-and-billing)
    - [Getting Started](https://kb.optymyse.com/purchasing?hsLang=en#getting-started)
    - [Licensing](https://kb.optymyse.com/purchasing?hsLang=en#licensing)
    - [System Requirements](https://kb.optymyse.com/purchasing?hsLang=en#system-requirements)
- [Installation and Deployment](https://kb.optymyse.com/installation-and-deployment?hsLang=en#main-content)

    - [Hardware Options](https://kb.optymyse.com/installation-and-deployment?hsLang=en#hardware-options)
    - [Connector Configuration](https://kb.optymyse.com/installation-and-deployment?hsLang=en#connector-configuration)
    - [Cloud Installation](https://kb.optymyse.com/installation-and-deployment?hsLang=en#cloud-installation)
    - [PBX Configuration](https://kb.optymyse.com/installation-and-deployment?hsLang=en#pbx-configuration)
    - [Local Installation](https://kb.optymyse.com/installation-and-deployment?hsLang=en#local-installation)
- [Support](https://kb.optymyse.com/support?hsLang=en#main-content)

    - [Connector Metrics](https://kb.optymyse.com/support?hsLang=en#connector-metrics)
    - [Information](https://kb.optymyse.com/support?hsLang=en#information)
- [Troubleshooting](https://kb.optymyse.com/troubleshooting?hsLang=en#main-content)

    - [Connectors](https://kb.optymyse.com/troubleshooting?hsLang=en#connectors)
    - [General](https://kb.optymyse.com/troubleshooting?hsLang=en#general)
    - [Optymyse Director Software](https://kb.optymyse.com/troubleshooting?hsLang=en#optymyse-director-software)

<https://www.linkedin.com/company/optymyse> <https://www.instagram.com/optymyse> <https://www.youtube.com/@Optymyse> [mailto:hello@optymyse.com](mailto:hello@optymyse.com)

Copyright © 2025 Optymyse Ltd. All Rights Reserved.