CData Software - Knowledge Base
Recent Articles
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Redis to Power BI dashboards. Simply drag and drop Redis into data visuals on the Power BI canvas.
-
Replicate Multiple Sybase IQ Accounts via the CData Sync CLI
Replicate multiple Sybase IQ accounts to one or many databases.
-
Query Raisers Edge NXT in DataGrip
Create a Data Source for Raisers Edge NXT in DataGrip and use SQL to query live Raisers Edge NXT.
-
Connect and Query Live MailChimp Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live MailChimp into Databricks
-
Integrate with CockroachDB in SnapLogic
Use CData Connect AI to connect to and integrate with live CockroachDB in SnapLogic.
-
Use Microsoft Copilot Studio to talk to your Elasticsearch via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Elasticsearch for you.
-
Automated Continuous IBM Informix Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable IBM Informix replication to Google Cloud SQL.
-
Access Raisers Edge NXT from MySQL in PHP
Connect to Raisers Edge NXT through the standard MySQL libraries in PHP.
-
Connect to Live Amazon Athena in PostGresSQL Interface through CData Connect AI
Create a live connection to Amazon Athena in CData Connect AI and connect to your Amazon Athena from PostgreSQL.
-
Integrating LangChain with Confluence via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Atlassian Confluence within automated workflows.
-
Create a Data Access Object for Kintone using JDBI
A brief overview of creating a SQL Object API for Kintone in JDBI.
-
Build Zoho Creator-Connected Apps in Choreo
Use CData Connect AI to connect to Zoho Creator from Choreo and build custom apps using live Zoho Creator.
-
Connect to Sage Cloud Accounting in DBeaver
Use the CData ODBC Driver to connect to Sage Business Cloud Accounting in DBeaver.
-
Use the CData SSIS Components to Insert New or Update Existing Tableau CRM Analytics Records from SQL Server
Easily push SQL Server data to Tableau CRM Analytics using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Tableau CRM Analytics or update existing records with data from a SQL Server database.
-
Query LDAP Objects through ODBC in Node.js
Use node-odbc to execute SQL queries against LDAP from Node.js.
-
Choosing the Best Method to Connect MySQL to SQL Server: 5 Options Explained
Discover multiple ways to connect and use MySQL from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to MYOB AccountRight in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use Databricks Agent Bricks to Talk to Your Snapchat Ads via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Snapchat Ads for you.
-
Back Up Facebook Ads to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Facebook Ads. In this article, we will employ an SSIS workflow to populate a database with Facebook Ads data.
-
How to Connect to Live Spark Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Apache Spark SQL securely in real time.
-
Use the CData SSIS Components to Insert New or Update Existing Adobe Commerce Records from SQL Server
Easily push SQL Server data to Adobe Commerce using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Adobe Commerce or update existing records with data from a SQL Server database.
-
Natively Connect to Harvest in PHP
The CData ODBC driver for Harvest enables you to create PHP applications with connectivity to Harvest. Leverage the native support for ODBC in PHP.
-
Deploy the ADO.NET Provider for Jira Assets on an SSRS Report Server
Connect to Jira Assets from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to Work with SAP Fieldglass in ETL Validator JDBC
Connect to SAP Fieldglass from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Shippo in JRuby
Create a simple JRuby app with access to live Shippo.
-
Automated Continuous Vault CRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Vault CRM replication to PostgreSQL.
-
Analyze REST in R via JDBC
Use standard R functions and the development environment of your choice to analyze REST with the CData JDBC Driver for REST.
-
Build Dashboards with Airtable in Dundas BI
Create dynamic dashboards and perform analytics based on Airtable in Dundas BI.
-
Migrating data from Cvent to Snowflake using CData SSIS Components.
Easily push Cvent to Snowflake using the CData SSIS Tasks for Cvent and Snowflake.
-
Migrating data from ADP to Databricks using CData SSIS Components.
Easily push ADP to Databricks using the CData SSIS Tasks for ADP and Databricks.
-
Back Up JotForm to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for JotForm. In this article, we will employ an SSIS workflow to populate a database with JotForm data.
-
Access Live MariaDB in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate MariaDB into the statistical analysis tools available in SAS JMP. This article shows how to use MariaDB in the Graph Builder and Query Builder.
-
Migrating data from HCL Domino to Google BigQuery using CData SSIS Components.
Easily push HCL Domino to Google BigQuery using the CData SSIS Tasks for HCL Domino and Google BigQuery.
-
Connect to Couchbase through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Couchbase using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build SurveyMonkey-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SurveyMonkey.
-
LINQ to Google Spanner
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Google Spanner Data Provider.
-
Getting Started with the CData Power BI Connector for Facebook Ads
-