Getting Started


Getting Started


Connect AIEmbedded CloudCData Connect Spreadsheets is a consolidated connectivity platform that links applications to a broad ecosystem of real-time data sources through consistent, standards-compliant interfaces. Connect AIEmbedded CloudCData Connect Spreadsheets provides tools to access data seamlessly from any system, anywhere.

With Connect AI, you can unify access to all of the cloud applications, databases, APIs, and services across an organization.

Key Features

  • Broad Data Connectivity: Connect AIEmbedded CloudCData Connect Spreadsheets allows you to transform data into a simple language that any reporting tool, analytics dashboard, or spreadsheet can understand. It can connect to a vast range of applications (including those for accounting, marketing, customer relationship management, and more) by using a consistent approach that is already supported by many data tools.Connect to over 250 systems, select the data you want, and seamlessly sync changes back to your original sources, right within Microsoft Excel or Google Sheets.
  • Real-Time Data Access: Connect AIEmbedded CloudCData Connect Spreadsheets gives you access to your data in real time, which creates an agile and flexible work environment that adapts and changes as quickly as your data does. This approach avoids the pitfalls of traditional Extract, Transform, Load (ETL) processes that rely on moving data to separate locations.
  • Create, Read, Update, Delete (CRUD) Support: Read and Write operations are supported. Operations are controlled by security settings that you can configure in Connect AIEmbedded CloudCData Connect Spreadsheets or in your data sources.
  • Secure Access: Administrators can create query users and define their access permissions for each data source individually.
  • Comprehensive Data Model & Dynamic Discovery: Connect AIEmbedded CloudCData Connect Spreadsheets provides comprehensive access to all of the data that is exposed in the underlying connections, including full access to dynamic data and searchable metadata.
  • Workspaces: Connect AI provides a sleek way to organize, catalog, and control access to specific data. You can bundle related data items separately in a simple and scalable way with workspaces.

For more information about these key features, see Technology.

Get Started

For a high-level overview about setting up and using Connect AI, see Quick Start Guide.For a high-level overview about setting up and using Embedded Cloud, see Quick Start Guide.

For more detailed information about the features of Connect AIEmbedded CloudCData Connect Spreadsheets, see the documentation outlined below:

  • Dashboard—Information about navigating Connect AIEmbedded CloudCData Connect Spreadsheets and accessing features.

  • Sources—Steps for connecting data sources to Connect AIEmbedded CloudCData Connect Spreadsheets to make your data available for use.

  • Integrations—Steps for connecting integration tools to Connect AIEmbedded CloudCData Connect Spreadsheets to access data from your data sources.

  • API—Information about connecting to data via the REST API, OData, and OpenAPI protocols. REST API protocol.

  • Virtual Databases—Information about the virtual database feature of Connect AI, including SQL Server.

  • SQL Reference—List of supported SQL syntax and code examples.

Get Support

For assistance with using Connect AIEmbedded CloudCData Connect Spreadsheets, there are two main resources available:

  • The Status page, which shows the current status and incident history for the application services.
  • CData Technical Support, which you can also access by clicking the Support link at the bottom of the dashboard.