IA and ODBC SQL Server TEXT data type
Posted: Mon Sep 18, 2017 1:00 pm
I am running IA on AIX with ODBC pointed at SQL Server.
Some columns have TEXT data type (like a CLOB) which are variable width up to 2 GB in size. Customer was hoping IA would do data classification on these columns and detect sensitive data if present, which is an advertised feature of the tool. Does it not work on large objects? Is there a workaround?
So far I have found that IA reports such columns as data type "STRING" with length "--" and status as "Error." The option to "Include columns with length over 512 characters" is enabled. The corresponding DataStage job log contains a fatal message about having the array size set to 1 for LOB columns.
Some columns have TEXT data type (like a CLOB) which are variable width up to 2 GB in size. Customer was hoping IA would do data classification on these columns and detect sensitive data if present, which is an advertised feature of the tool. Does it not work on large objects? Is there a workaround?
So far I have found that IA reports such columns as data type "STRING" with length "--" and status as "Error." The option to "Include columns with length over 512 characters" is enabled. The corresponding DataStage job log contains a fatal message about having the array size set to 1 for LOB columns.