SQL databases

DSS can both read and write datasets in SQL databases. You can:

  • Create datasets representing SQL tables (and read and write in them)

  • Create datasets representing the results of a SQL query (and read them)

  • Write code recipes that create datasets using the results of a SQL query on existing SQL datasets. See SQL recipes for more information.

In addition, on most supported databases, DSS is able to:

  • Execute Visual recipes directly in-database (ie: for a visual recipe from the database to the database, the data never moves out of the database)

  • Execute Charts directly in-database

For more information on the range of what DSS can do with SQL databases, please see DSS and SQL.

Note

You might want to start with our detailed tutorial for your first steps with SQL databases in DSS.

You might want to start with that tutorial. The rest of this section is reference information.

DSS provides full support for many databases and experimental support for others. Click on a link for detailed support information for that database.