16.10 - Operational Considerations - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

Timestamp Datatype is not supported with either Simba ODBC drivers for MongoDB or DataDirect ODBC drivers for MongoDB, because MongoDB uses this Datatype for its internal purposes and the drivers do not allow the data to be exported. Instead, use the Date type in place of the Timestamp in MongoDB.

Simba ODBC drivers for MongoDB support exporting the data from MongoDB in JSON format, which can be of type CLOB. But since the ODBC Operator does not support the CLOB type yet, you can cast it into VARCHAR, which can be a Maximum of 64KB, and then use the NEW JSON() procedure in the APPLY statement to export the data into Teradata database from MongoDB as JSON type.

In order to achieve this, Simba ODBC Drivers for MongoDB supports a syntax in the select statement as follows:

'SELECT DocumentAsJson FROM <collection Name>'
This feature and the above syntax is not supported by the DataDirect ODBC drivers for MongoDb, and is unique to Simba ODBC Drivers for MongoDB.