Rules and Guidelines for MySQL Sources and Targets

• •The database user account for each target connection must have the INSERT, SELECT, UPDATE, and DELETE privileges.
• •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 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.
• •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.