Use the following rules and guidelines for MySQL sources:
•You cannot include lookup fields of Text or Ntext data type because MySQL connections use a UTF-8 code page.
•When you use a saved query to read data from a MySQL source, you must not use the full outer join operation.
•When you use a saved query to read data from a MySQL source that contains Float columns, the Secure Agent imports the Float data type as Real data type.
•When you use a saved query to read data from a MySQL source that contains Double columns, the Secure Agent imports the Double data type as Decimal data type.
•You cannot use the select * from <table_name> command in a saved query. You must provide the explicit column list.
•When you run a MySQL mapping to read from a stored procedure, ensure that the precision of the Float data type does not exceed 18.
•When the source column name that you read has hyphens and you use the Create New at Runtime option to create a target, the hyphens in the table name are converted to underscores in the target column.
•You cannot use SQL ELT optimization to push the transformation logic to MySQL.