{"id":3029,"date":"2023-06-15T10:04:45","date_gmt":"2023-06-15T15:04:45","guid":{"rendered":"https:\/\/www.teamdesk.net\/blog\/?p=3029"},"modified":"2023-06-15T19:33:07","modified_gmt":"2023-06-16T00:33:07","slug":"openai-integration-with-teamdesk","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/","title":{"rendered":"OpenAI Integration with TeamDesk"},"content":{"rendered":"\n

This is a special guest post written by ChatGPT of OpenAI — Editor<\/em>.<\/p>\n\n\n\n

In today’s fast-paced world, businesses are constantly seeking ways to streamline their operations and enhance productivity. One such solution that holds immense potential is the integration of TeamDesk<\/a>, a robust online database platform, with OpenAI, a leading provider<\/a> of natural language processing technologies. This integration allows users to generate a database structure by simply describing it in natural language. Moreover, it enables the suggestion of new tables with columns and provides seamless linking between tables based on their names. Additionally, the integration facilitates the suggestion of additional columns for existing tables and empowers users to create new views and reports. Let’s dive deeper into the capabilities of this powerful integration.<\/p>\n\n\n\n

OpenAI Generates a Database Structure<\/h2>\n\n\n\n

The integration of TeamDesk with OpenAI leverages the latter’s natural language processing capabilities to enable the generation of a database structure<\/a> effortlessly. <\/p>\n\n\n

\n
\"User<\/a><\/figure>\n<\/div>\n\n\n

Instead of manually creating tables and columns, users can describe their requirements in plain English, and OpenAI’s advanced algorithms interpret the description and automatically generate the necessary structure in TeamDesk. <\/p>\n\n\n

\n
\"OpenAI<\/a><\/figure>\n<\/div>\n\n\n

This functionality greatly simplifies the initial setup process and reduces the time and effort required to build a database from scratch.<\/p>\n\n\n\n

OpenAI Suggests New Tables and Columns<\/h2>\n\n\n\n

TeamDesk, in collaboration with OpenAI, takes the concept of database generation a step further by suggesting new tables with columns based<\/a> on user inputs. By simply entering the name of a table, the system intelligently analyzes the context and proposes relevant tables that could enhance the existing database structure. <\/p>\n\n\n

\n
\"Wine<\/a><\/figure>\n<\/div>\n\n\n

This capability assists users in expanding their data model with ease, making it adaptable to evolving business requirements.<\/p>\n\n\n\n

OpenAI Links Tables Seamlessly<\/h2>\n\n\n\n

The integration between TeamDesk and OpenAI also enables the automatic linking of tables based on their names. When creating a new table, users can reference existing tables by name, and the system intelligently establishes the necessary relationships between them. <\/p>\n\n\n

\n
\"Order<\/a><\/figure>\n<\/div>\n\n\n

This feature eliminates the need for manual intervention and minimizes the risk of errors when setting up complex relational databases. It promotes a seamless flow of information across different tables, enhancing data integrity and facilitating efficient data analysis.<\/p>\n\n\n\n

OpenAI Suggests Additional Columns<\/h2>\n\n\n\n

Another valuable aspect of this integration is the ability to suggest additional columns for existing tables<\/a>. Users can describe the type of information they want to store, and OpenAI’s language model assists in identifying the most suitable column types and properties. <\/p>\n\n\n

\n
\"OpenAI<\/a><\/figure>\n<\/div>\n\n\n

This feature empowers businesses to adapt their database structure dynamically as their data requirements evolve over time, without the need for extensive manual modifications.<\/p>\n\n\n\n

OpenAI Creates New Views and Reports<\/h2>\n\n\n\n

In addition to generating and expanding the database structure, the integration of TeamDesk and OpenAI allows users to leverage the power of natural language processing to create new views and reports<\/a>. <\/p>\n\n\n

\n
\"OpenAI<\/a><\/figure>\n<\/div>\n\n\n

By describing the desired criteria and conditions, users can define custom views that present data in a meaningful and actionable way. These views can be used for data analysis, decision-making, and generating insightful reports. This functionality empowers users to gain deeper insights from their data and make informed business decisions based on accurate information.<\/p>\n\n\n\n

Conclusion<\/h2>\n\n\n\n

The integration of TeamDesk with OpenAI brings a host of benefits to businesses seeking to optimize their database management processes. By harnessing the power of natural language processing, this integration simplifies the initial database setup, suggests new tables and columns, establishes seamless links between tables, and enables the creation of custom views and reports. With this powerful combination, organizations can unlock the true potential of their data, improve operational efficiency, and make data-driven decisions with confidence. Embrace the integration of TeamDesk and OpenAI to transform your database management experience and unlock new possibilities for your business.<\/p>\n\n\n\n

Editorial Post Scriptum — On Data Protection<\/h2>\n\n\n\n

For Suggest new…<\/em> functionality we pass bare minimum information to provide OpenAI with the context. Typically, it’s a name of the database, name of current table and its columns’ names and types. To let OpenAI suggest new columns and tables we also pass names of other tables in the database. This helps AI to suggest relations between tables. To suggest new views, we pass the names of the views in the current table. But in no way users’ personal information or data from the database is transferred to the OpenAI.<\/p>\n\n\n\n

Have fun!<\/p>\n","protected":false},"excerpt":{"rendered":"

New integration between TeamDesk and OpenAI allows users to generate a database structure by simply describing it in natural language.<\/p>\n","protected":false},"author":4,"featured_media":3039,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[303,306,305],"class_list":["post-3029","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-whats-new","tag-artifical-intelligence","tag-chatgpt","tag-openai"],"yoast_head":"\nOpenAI Integration with TeamDesk - TeamDesk Blog<\/title>\n<meta name=\"description\" content=\"New integration between TeamDesk and OpenAI allows users to generate a database structure by simply describing it in natural language.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"OpenAI Integration with TeamDesk - TeamDesk Blog\" \/>\n<meta property=\"og:description\" content=\"New integration between TeamDesk and OpenAI allows users to generate a database structure by simply describing it in natural language.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/\" \/>\n<meta property=\"og:site_name\" content=\"TeamDesk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-15T15:04:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-16T00:33:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2023\/06\/openai-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"800\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Kirill Bondar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirill Bondar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/openai-integration-with-teamdesk\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/openai-integration-with-teamdesk\\\/\"},\"author\":{\"name\":\"Kirill Bondar\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\"},\"headline\":\"OpenAI Integration with TeamDesk\",\"datePublished\":\"2023-06-15T15:04:45+00:00\",\"dateModified\":\"2023-06-16T00:33:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/openai-integration-with-teamdesk\\\/\"},\"wordCount\":715,\"commentCount\":3,\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/openai-integration-with-teamdesk\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/openai-2.png\",\"keywords\":[\"artifical intelligence\",\"chatgpt\",\"openai\"],\"articleSection\":[\"What's New\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/openai-integration-with-teamdesk\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/openai-integration-with-teamdesk\\\/\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/openai-integration-with-teamdesk\\\/\",\"name\":\"OpenAI Integration with TeamDesk - TeamDesk Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/openai-integration-with-teamdesk\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/openai-integration-with-teamdesk\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/openai-2.png\",\"datePublished\":\"2023-06-15T15:04:45+00:00\",\"dateModified\":\"2023-06-16T00:33:07+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\"},\"description\":\"New integration between TeamDesk and OpenAI allows users to generate a database structure by simply describing it in natural language.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/openai-integration-with-teamdesk\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/openai-integration-with-teamdesk\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/openai-integration-with-teamdesk\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/openai-2.png\",\"contentUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/openai-2.png\",\"width\":800,\"height\":800,\"caption\":\"TeamDesk logo and OpenAI logo\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/openai-integration-with-teamdesk\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OpenAI Integration with TeamDesk\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\",\"name\":\"TeamDesk Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\",\"name\":\"Kirill Bondar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"caption\":\"Kirill Bondar\"},\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/author\\\/kirill-bondar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"OpenAI Integration with TeamDesk - TeamDesk Blog","description":"New integration between TeamDesk and OpenAI allows users to generate a database structure by simply describing it in natural language.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/","og_locale":"en_US","og_type":"article","og_title":"OpenAI Integration with TeamDesk - TeamDesk Blog","og_description":"New integration between TeamDesk and OpenAI allows users to generate a database structure by simply describing it in natural language.","og_url":"https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/","og_site_name":"TeamDesk Blog","article_published_time":"2023-06-15T15:04:45+00:00","article_modified_time":"2023-06-16T00:33:07+00:00","og_image":[{"width":800,"height":800,"url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2023\/06\/openai-2.png","type":"image\/png"}],"author":"Kirill Bondar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirill Bondar","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/#article","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/"},"author":{"name":"Kirill Bondar","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2"},"headline":"OpenAI Integration with TeamDesk","datePublished":"2023-06-15T15:04:45+00:00","dateModified":"2023-06-16T00:33:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/"},"wordCount":715,"commentCount":3,"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2023\/06\/openai-2.png","keywords":["artifical intelligence","chatgpt","openai"],"articleSection":["What's New"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/","url":"https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/","name":"OpenAI Integration with TeamDesk - TeamDesk Blog","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/#primaryimage"},"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2023\/06\/openai-2.png","datePublished":"2023-06-15T15:04:45+00:00","dateModified":"2023-06-16T00:33:07+00:00","author":{"@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2"},"description":"New integration between TeamDesk and OpenAI allows users to generate a database structure by simply describing it in natural language.","breadcrumb":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/#primaryimage","url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2023\/06\/openai-2.png","contentUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2023\/06\/openai-2.png","width":800,"height":800,"caption":"TeamDesk logo and OpenAI logo"},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/openai-integration-with-teamdesk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teamdesk.net\/blog\/"},{"@type":"ListItem","position":2,"name":"OpenAI Integration with TeamDesk"}]},{"@type":"WebSite","@id":"https:\/\/www.teamdesk.net\/blog\/#website","url":"https:\/\/www.teamdesk.net\/blog\/","name":"TeamDesk Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamdesk.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2","name":"Kirill Bondar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","caption":"Kirill Bondar"},"url":"https:\/\/www.teamdesk.net\/blog\/author\/kirill-bondar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/3029","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/comments?post=3029"}],"version-history":[{"count":10,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/3029\/revisions"}],"predecessor-version":[{"id":3056,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/3029\/revisions\/3056"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media\/3039"}],"wp:attachment":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media?parent=3029"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/categories?post=3029"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/tags?post=3029"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}