All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.
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
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#'
Attachments Open full size