macOS не подключается Tableau

sablastik commented 3 years ago

Сервер 20.6.6.7 Драйвер 1.1.8.20200710

Строка подключения в odbc.ini: Url = http://login:pass@host:8123/query?database=default&max_result_bytes=4000000&buffer_size=3000000

Табло просто открывает DSN и ничего не показывает. Ни структуры базы, ни ошибок. Что с этим можно сделать?

yurifal commented 3 years ago

А если нажать на значок Search (лупу), который расположен возле жирного креста в поле ввода имени Таблицы (Enter table name)?

sablastik commented 3 years ago

А если нажать на значок Search (лупу), который расположен возле жирного креста в поле ввода имени Таблицы (Enter table name)?

Нет. Совсем пустота. Этих элементов нет. Как и не происходит запросов метаданных на получение схемы

traceon commented 3 years ago

Try to make sure the Driver and DSN are configured correctly using command line tool from iODBC.

sablastik commented 3 years ago

Try to make sure the Driver and DSN are configured correctly using command line tool from iODBC.

Can you describe the process? According to https://github.com/ClickHouse/clickhouse-odbc#configuration-iodbc, I've just edited odbc.ini & odbcinst.ini

chrsle commented 3 years ago

@traceon would be great to have the process. trying to connect clickhouse to tableau and cannot figure it out

sablastik commented 3 years ago

@traceon I've rechecked my odbc.inn & odbcinst.ini connections - I can connect Tableau to clickhouse server 19.7.5.27, but when I try to use DSN with the same parameters changing IP to 20.6.6.7 - nothing happens

sablastik commented 3 years ago

I've found that database in DSN to 20.6.6.7 is mandatory. While connection to 19.7.5.27 without pointing out database leads to 'Select Database' dialog:

p.s. however I haven't figured out how to use one line connection specs: # Url = https://default:password@localhost:8443/query?database=default&max_result_bytes=4000000&buffer_size=3000000 it doesn't work neither with 19.7.5.27, nor with 20.6.6.7

traceon commented 3 years ago

Tableau Desktop for macOS expects the ODBC driver to be built against iODBC. You are building for iODBC, right?

But first of all, try to make sure iodbctest works with the DSN from the console, and after that use Tableau:

echo "SELECT 1" | iodbctest "DSN=MyClickHouseDSN"

chrsle commented 3 years ago

Tableau Desktop for macOS expects the ODBC driver to be built against iODBC. You are building for iODBC, right?

But first of all, try to make sure iodbctest works with the DSN from the console, and after that use Tableau:
echo "SELECT 1" | iodbctest "DSN=MyClickHouseDSN"

Ok. I don't think I'm there yet. How do I create the driver?

traceon commented 3 years ago

How do you get Tableau working with 19.7.5.27 if you don't have a driver?

chrsle commented 3 years ago

How do you get Tableau working with 19.7.5.27 if you don't have a driver?

I don't have that either. I don't have anything.

traceon commented 3 years ago

Please take a look at README.md in the root of the repo.

traceon commented 3 years ago

To use Tableau Desktop with ClickHouse server you'll need:

Tableau Desktop (where to get, how to configure, and how to use is out of scope)
ClickHouse server (where to get, how to configure, and how to use is out of scope, but see clickhouse.tech)
ClickHouse ODBC Driver ("you are here"), see README.md

sablastik commented 3 years ago

Tableau Desktop for macOS expects the ODBC driver to be built against iODBC. You are building for iODBC, right?

But first of all, try to make sure iodbctest works with the DSN from the console, and after that use Tableau:
echo "SELECT 1" | iodbctest "DSN=MyClickHouseDSN"

@traceon I've tried to check with this command:

echo "SELECT 1" | iodbctest "DSN=ClickNew"

iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.1319.0723
Driver: 1.1.8.20200710 (CLICKHOUSEODBCW.DLL)

1: SQLExec = Connection refused (1) SQLSTATE=HY000
SQL>
SQL>
Have a nice day.%

ClickHouse / clickhouse-odbc

macOS не подключается Tableau #319