Data360 Analyze

 View Only

  • 1.  Insert data in to SQL database

    Employee
    Posted 02-28-2019 15:33

    I have data prepared already in Data3Sixty. How can I insert data into SQL database table?

    Is the JDBC Query node correct node to use? If it is, what sql code should be? 

     

     



  • 2.  RE: Insert data in to SQL database

    Employee
    Posted 02-28-2019 18:33

    Use the JDBC Store node.



  • 3.  RE: Insert data in to SQL database

    Employee
    Posted 03-08-2019 21:32

    JDBC Store node is great for automatically inserting records into your database.  I also recommend looking at the JDBC Execute node as it gives you greater control of your insert and update statements.  For example, you can pass in SQL field bindings and then use those just as you would in any other SQL tool.  The question marks (?) represent the fields in the same sequence as the SQLQueryFieldBindings property.  For example, an insert statement would look like the following (the dashes denote comments)

    INSERT INTO customers (first_name, last_name, email, id)
    VALUES (?, ?, ?, ?)