Match Designer Database

[kevink]

Can Teradata 13 be used for the QualityStage Match Designer database?

It tests successfully when configuring the Test Environment in Match Designer, but throws syntax errors when attempting to test a match pass.

Code: Select all

##E IIS-DSEE-TDOD-00007 15:03:54(002) <main_program> [IBM(DataDirect OEM)][ODBC Teradata Client driver][Teradata]Syntax error, expected something like a 'CHECK' keyword between ',' and the 'Value' keyword.
##E IIS-DSEE-TDOD-00062 15:03:54(003) <MWI_Odbc_Write> Table create failed: {0} 

So it would appear to me that whatever SQL is generated to create tables is not compatible with whatever Teradata expects. This would make my client really sad were it the case.

[rjdickson]

Hi Kevin,

Teradata is not supported as the Match Designer Database. Only DB2, Oracle, and SQL Server.

No need to be sad, though! One of those three is already being used for the repository, so it can be used the the Match Designer Database, too!