MY_SQL_DATA_WRITER: cannot read fix-length data?

CloverDX Platform
1

Hi,

Looks like MY_SQL_DATA_WRITER only read data in delimited format. If I have a fix-length data file, I have to transform it to a delimited-format, right? So, the graph can look something like:

FIXLEN_DATA_READER → SIMPLE_COPY → MY_SQL_DATA_WRITER

Does Clover load the data record by record, or is there an option to “batch load” the records (say load every 100 records)?

Thanks so much,
albert

2

Hello,
if MySqlDataWriter reads data from input port, it doesn’t matter if it is delimited or fix length - it formats data to temporary file or named pipe and load data to MySql database. You can pass any parameter, that mysql utility or LOAD DATA INFILE statement accept, but seems that there is not anything like batch mode for data loading.

3

Thanks, Agata :slight_smile:

al