DSS and SQL
DSS can both read and write datasets in SQL databases. Using DSS with SQL, 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 about SQL recipes
-
use the SQL Notebook for interactive querying
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
-
create pipelines
For an overview of which databases are supported by DSS, see the connecting to SQL reference .