I am using MySQL migration tool to migrate my data from MongoDB (via MongoDB BI connector) to MySQL.
All first steps performed well.
At Create Schemas step, I get the warning
Unknown storage engine 'MongoDB'.
SQL Error: 1286
And at Create Target Results step, the SQL scripts to create tables fail with the same error output.
Example of query that fails:
CREATE TABLE IF NOT EXISTS `trainingDB`.`gradings` (
`_studentId` VARCHAR(65535) NULL DEFAULT NULL COMMENT '{ \"name\": \"studentId\" }',
`_sessionId` VARCHAR(65535) NULL DEFAULT NULL COMMENT '{ \"name\": \"sessionId\" }')
ENGINE = MongoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin
COMMENT = '{ \"collectionName\": \"gradings\" }'