Knowledge Base

How to write to a database

Next >>

<< Prev

How to write to a database – tutorial transcript

To write to a dataset using Database Export Block:

Step 1. Drag and drop the DB Export Block from the Block Library or right-click on the Main Canvas and select “Add Export Block” and then “DB Export”.

Step 2. Connect the DB Export Block to a block that contains the data that you would like to export.

Step 3. Click on the DB Export Block to access its settings and press on the “Select Database table” button.

Step 4. Select database type.

Step 5. Connect to the database using your credentials.

Step 6. Provide a name for a new table or select an existing table in the database (choose if you want to append or overwrite the data) and click finish.

write to a database

Step 7. Press the “Run with outputs” button to write to the database.

Contents:

  • DB Export Block settings
  • Database tables

Related Materials:

Transcript – How to write to a database

Other resources:

Tutorial – Connecting to an SQL database
Tutorial – How to edit an SQL query
Documentation

Length:

1:28

You can download a free trial of Analytics Canvas to follow along with the video.

Back to more Support    |   Try Analytics Canvas for Free

Was this article helpful?

Related Tutorials/Video

Need Support?

If you need any further help, don't hesitate to send a support request to our support team.

Contact Support