Collect - Add update RAW and VARBINARY data conversions for most common source databases
As part of every install of DSP or new data source type added, we have to change the RAW and VARBINARY data types to convert properly to character fields. Here are two examples that should come out of the box configured:
ODBCHANA
New Data Type Format NVARCHAR(#2XLENGTH#)
New Data Type NVARCHAR
New Data Length #2XLENGTH#
New Data Precision 0
New Data Scale 0
Process Flag Accept
Column Override Template CAST("#COLUMNNAME#" AS NVARCHAR(#2XLENGTH#)) #COLUMNNAME#
ODBCOracle
New Data Type NVARCHAR
New Data Length #2XLENGTH#
New Data Precision 0
New Data Scale 0
Process Flag Accept
Column Override Template RAWTOHEX(#COLUMNNAME#) #COLUMNNAME#
-
John Slagle
- Jul 1 2020
- Likely to Implement
Related ideas
Team, for what it is worth, here is the fix I use:
UPDATE DataGarage.[dbo].[ztTargetSourceConnectionTypeDataConversion] SET
[NewDataTypeFormat]='VARBINARY(50)',
[NewDataType]='VARBINARY',
[NewDataLength]='50'
WHERE [DataType]='RAW' AND [NewDataLength]='#2XLENGTH#'