Skip to Content
S N

Bulk loading tables in mysql

HI experts,

I have 3 tables with apprx 80K records set to truncate load in staging area.

It takes about 30 mins to load them and as SAP suggested that MYSQL is not supported for bulk loading.

What will be the best approach to load them?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 24 at 04:36 PM

    what is your source? is it a database table or sap table? and are there any transformations/joins applied between source and target?

    Add comment
    10|10000 characters needed characters exceeded

    • Hello,

      try creating aliases in the datastore.. try creating alias for target SCHEMA in source datastore and import target table into source data store. Right click the dataflow properties and check if "use database links" option is checked or not. if not checked please check the option. and also check if source schema has insert grants on the target schema.

  • avatar image
    Former Member
    Jan 29 at 11:36 AM

    Hi SN,

    If you have used MYSQL as a target database then you want to follow below steps to correct the same error:

    Step 1: Open your current job and go to data flow.

    Step 2: Double click on Target table.

    Step 3: Go to Bulk Loader Option -> Unchecked for Bulk Load.

    Step 4: Save job and re execute the same.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 15 at 10:07 PM

    Hi SN, did you find solution for this issue? if so can you please share.

    Add comment
    10|10000 characters needed characters exceeded