Discussion board where members can learn more about Qlik Sense Data Connectivity.
I started a new project in my Desktop version, trying to play with datas from an Oracle database with one SQL table A.
I set up an Oracle connector but I have an issue : the primary key "ID" is formatted in the RAW format. When I load the table, the datas are all read as: system.byte.
It seems that the RAW format is not supported for the Oracle Database from what I read below:https://help.qlik.com/en-US/compose-datawarehouses/November2020/Content/ComposeForDataWarehouses/Mai...
Do you have a workaound?
I tried to use the SQL function UTL_RAW.CAST_TO_VARCHAR2 in the load script to convert the RAW data type to VARCHAR2 but it was not better.
FYI, I don't have the hand on the DB to change the datatype, I have just access in read only.
Many thanks for your support !