Import data into MySQL

Comments

8 comments

  • Nuri Ensing NetSuite Integration Whiz
    Celigo University Level 4: Legendary
    Awesome Follow-up
    Engaged

    Hi

    I kindly want to know if I am correct here:

    1. Bulk SQL Method: This method is optimized for large data volumes. It automatically creates a bulk insert SQL query for each batch of records(batch is per page of records), which is ideal for efficiently inserting large numbers of records into a database in fewer transactions. It only uses INSERT.

    2. SQL Query Once per Page of Records: This option allows you to execute a custom SQL query for each page of data. It provides more flexibility in terms of the SQL operations you can perform (not limited to just bulk inserts) and is useful when you need to run specific SQL commands on each batch of data.

    1
  • Kathyana Queeman Community moderator Technical Writer
    Engaged
    Celigo University Level 2: Seasoned

    Hi Yash Kumar

    This issue seems a bit complicated, so I've created a ticket for you (Ticket No. 201005). I'll follow the ticket so we can update the article as soon as possible. If you could comment on the ticket and provide the import ID, it would help a lot. You can find the import ID as follows:

    1. Navigate to your integration and click on your Flow.
    2. In the flow builder, click your import
    3. Navigate to the URL at the top of your webpage.
    4. Find the import ID.

    The URL will look like this

    https://integrator.io/integrations/58f5••••••••5cfe/flowBuilder/58f54•••••••••••••5d05/edit/imports/5c•••••••••••••••397c8

    In this case, your import ID will be 5c•••••••••••••••397c8 

    –– OR ––

    1. Navigate to Resources → Import.
    2. Select your import. 
    3. Navigate to the URL at the top of your webpage.
    4. Find the import ID.

    The URL will look like this:

    https://integrator.io/imports/edit/imports/60df••••••••••••3a7e

    In this case, your import ID is 60df••••••••••••3a7e

    Let me know if you need anything else. For any documentation-related questions, you can also reach out to writers@celigo.com. Thanks! 

     

     

     

     

     

     

    0
  • Kathyana Queeman Community moderator Technical Writer
    Engaged
    Celigo University Level 2: Seasoned

    Hi Nuri Ensing

    1. Bulk SQL Method: You are correct in that the Bulk SQL method creates a bulk insert SQL query for each batch of records. I believe each batch is per page of records, but I think Rohit Prasad might be better suited to answer that. 

    2. SQL Query Once per Page of Records: This executes a custom SQL query once per page of data. Slightly different than a custom SQL query for each page of data. From what I understand, it allows you to run one query for each page, as opposed to a different query for each page. Is that correct, Rohit Prasad?

    This is my understanding, but Rohit may have more in-depth knowledge, so I would wait for his confirmation. Thanks! 

    0
  • Yash Kumar Salesforce Integration Whiz NetSuite Integration Whiz
    Awesome Follow-up
    Engaged
    Magento 2-NetSuite IA Certification
    Salesforce-NetSuite IA Certification
    ZenDesk-NetSuite IA Certification
    Celigo University Level 4: Legendary

    Hi Kathyana Rule

    I appreciate your prompt response. Good news— the issue resolved itself, and all the flows are back to their usual functioning. It seems like I encountered a sporadic issue following the recent release, but it's reassuring to know that it got fixed on its own may be something happed in the Backed. 

    Thanks again for your assistance!

    0
  • Yash Kumar Salesforce Integration Whiz NetSuite Integration Whiz
    Awesome Follow-up
    Engaged
    Magento 2-NetSuite IA Certification
    Salesforce-NetSuite IA Certification
    ZenDesk-NetSuite IA Certification
    Celigo University Level 4: Legendary

    Hi Kathyana Rule

    After the recent release. We are getting this error and all the imports have been errored out due to the same. It says to use one of the four available import options and we are doing the same. But still it pops up with this.

    0
  • Kathyana Queeman Community moderator Technical Writer
    Engaged
    Celigo University Level 2: Seasoned

    Hi Yash Kumar

    Just saw your response! I'm glad the issue resolved itself. You can either close the ticket by commenting on it, or you can leave it open so our internal team can review the issue and check that there isn't something bigger happening in the background. It's completely up to you. 

    Thanks! 

    0
  • Kathyana Queeman Community moderator Technical Writer
    Engaged
    Celigo University Level 2: Seasoned

    Hi Yash Kumar

    Let me reach out to some people internally and get back to you! 

    Thanks!

    0
  • Tyler Lamparter Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    Nuri Ensing you are correct in your understanding.

    0

Please sign in to leave a comment.