Maximum length of table/view name in ORACLE vs ODBC connection.

[janus2021]

Hello.

I can not find information about the maximum length of table / view names that Qlik can handle in the ORACLE vs ODBC connection.
Someone who has knowledge maximum length or where i can find information.

[vinieme12]

AFAIK there is no such limitation

[janus2021]

I tried ORACLE and tried to read a table that name is 37 characters long and i got an error: Table name too long(see attachment).

ODBC worked fine.

So have to go with ODBC.

[vinieme12]

That message is returned by the odbc driver and is a driver limitation, this is not related to qliksense 

https://docs.microsoft.com/en-us/sql/odbc/microsoft/table-name-limitations?view=sql-server-ver15#:~:....

Try oledb instead

https://community.qlik.com/t5/Qlik-Sense-Documents/How-to-set-up-an-Oracle-OLE-DB-connection-in-Qlik...