BLOB Data Type- How to Handle

[Former Member]

Hi All,

I am connecting to HANA and accesing HANA Tables which is having a column with BLOB data type .

I need to create a universe and need to access the universe in webi, but webi cannot handle BLOB data types , do we any alternative solution to handle BLOB data type objects in IDT.

Regards,

Nagaraj

[former_member182521 · Accepted solution]

Hi Nagaraj,

Even in relational databases you cant use the BLOB & CLOB datasources. The alternative is to typecast the datatype to Longtext  (SQLSERVER) or VARCHAR(4000) as in Oracle. You can try to create a object at universe level which refer the typecasted values from your BLOB datatype.

But you need to anticipate some data truncation when your BLOB data exceeds the maxumum limit of the converted type.

Regards,

Mani

[Former Member · Accepted solution]

Hi Mani,

I am connecting to HANA , let me know how to typecast the same in IDT.

Syntax of the function will be helpfull.

Regards,

Nagaraj

[former_member182521 · Accepted solution]

You can use the HANA's typecasting functions such as TO_VARCHAR and TO_NVARCHAR and the maximum length would be 5000.

The syntax would be

SELECT  TO_VARCHAR (Your BLOB column) "New Varchar" FROM your table;

SELECT  TO_NVARCHAR (Your BLOB column) "New NVarchar" FROM your table;

For more reference kindly refer

http://help.sap.com/hana/html/sql_function_to_nchar.html

http://help.sap.com/hana/html/_csql_data_types.html

Regards,

Mani