Tables
The driver models the data in Asana as a list of tables in a relational database that can be queried using standard SQL statements.
CData JDBC Driver for Asana Tables
| Name | Description |
| Attachments | To Delete and Query from the Attachments in the tasks. |
| GoalMembership | To Create, Delete and Query memberships in the Goal. |
| Goals | To Create, Update, Delete and Query the Goals table. |
| PortfolioItems | To Create, delete, and Query Items in the Portfolio. |
| PortfolioMembership | To Create, Delete and Query memberships in the Portfolio. |
| Portfolios | To Create, update, delete, and query from Portfolios table. |
| ProjectMembership | To Create, Delete and Query memberships in the Project. |
| Projects | To Create, Update, Delete and Query the Projects table. |
| ProjectStatuses | To Create, Delete and Query from ProjectStatuses table. A project status is an update on the progress of a particular project, and is sent out to all project followers when created. |
| Sections | To Create, Update, Delete, and Query from Sections table. A section is a subdivision of a project that groups tasks together. |
| Stories | To Create, Update, Delete and Query from stories table. A story represents an activity associated with an object in the Asana system. Stories are generated by the system whenever users take actions such as creating or assigning tasks, or moving tasks between projects. |
| SubTasks | To Create, update, delete, and query from SubTasks table. |
| Tags | To Create, Update and Query from Tags table. A tag is a label that can be attached to any task in Asana. It exists in a single workspace. |
| Tasks | To Create, Update, Delete and Query from Tasks table. |
| TeamMembership | To represents a users connection to a team. |
| Teams | A team is used to group related projects and people together within an organization. Each project in an organization is associated with a team. |
| WorkspaceMembership | To Create, Delete and Query memberships in the Workspace. |
| Workspaces | To Update and Query from Workspaces table. A workspace is the highest-level organizational unit in Asana. All projects and tasks have an associated workspace. |