Rules and Guidelines for MySQL Sources and Targets

• •The database user account for each database target connection must have the INSERT, SELECT, UPDATE and DELETE privileges.
• •You cannot include lookup fields of Text or Ntext data type as MySQL connections use a UTF-8 code data type.
• •When you read data from a MySQL source, you must not use the full outer join operation.
• •When you read data from a MySQL source that contains Float columns, the Secure Agent imports the Float data type as the Real data type.
• •When you read data from a MySQL source that contains Double columns, the Secure Agent imports the Double data type as Decimal data type.
• •If a task writes time data from a MySQL source to a flat file, the Data Synchronization task converts the time data to a Date/Time data type. The date is the current date and time is the time specified in the source. You can use a string function in an expression to remove the date before loading data to the flat file.
• •When you read time data from a MySQL source, the Data Synchronization task converts the time to the Coordinated Universal Time (UTC) time zone. Consider the time zone change if you create data filters and field mapping expressions based on time.