Agent Management and SQL

Agent Management can both read and write datasets in SQL databases. Using Agent Management 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, Agent Management 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 Agent Management, see the connecting to SQL reference.

• SQL datasets
• SQL write and execution
• Partitioning
• SQL pipelines in Agent Management