Redash Connection to TIBCO Data Virtualization

datavirtualization · June 25, 2020, 1:14pm

We just installed Redash and wanted to connect to TIBCO Data Virtualization custom JDBC or ODBC connector. This will require installing the custom driver from TIBCO more details are in below link:

We are very new to redash so if someone can guide us on how to set up custom JDBC/ODBC connection (preferably JDBC) it will be great help to us.

k4s1m · June 25, 2020, 2:58pm

AFAIK Redash doesn’t have any JDBC connectors. The back-end is all Python and it uses ODBC in most places. You can still write a query runner for this, but you’ll need to hack it yourself since there isn’t any JDBC prior art.

There is this older post on the forum about implementing a new query runner. As long as you can use your JDBC driver from Python then it should work. I don’t know enough about JDBC to say if that’s quite possible though

datavirtualization · June 25, 2020, 3:50pm

Thanks. For custom ODBC connection if you can point me where to start that will be great.

k4s1m · June 25, 2020, 6:11pm

Check this out. Redash recently added an ODBC version of the Microsoft SQL Server connector. It uses pyodbc which can be installed with pip install pyodbc. The rest of the code happens in Python.

github.com

getredash/redash/blob/master/redash/query_runner/mssql_odbc.py

import logging
import sys
import uuid

from redash.query_runner import *
from redash.query_runner.mssql import types_map
from redash.utils import json_dumps, json_loads

logger = logging.getLogger(__name__)

try:
    import pyodbc

    enabled = True
except ImportError:
    enabled = False


class SQLServerODBC(BaseSQLQueryRunner):
    should_annotate_query = False

This file has been truncated. show original

▼Categories

▼Tags

Redash Connection to TIBCO Data Virtualization