CData Software - Knowledge Base
Recent Articles
-
Model Google Ads Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Ads, enabling the direct import of real-time Google Ads.
-
Use Dash to Build to Web Apps on Google Campaign Manager 360
Create Python applications that use pandas and Dash to build Google Campaign Manager 360-connected web apps.
-
Integrate with live OneNote in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft OneNote in Jitterbit.
-
Build Voice Agents in ElevenLabs with access to Live Act CRM
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Act CRM.
-
Salesforce Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Salesforce facts in real time.
-
How to Use a Microsoft Access Database to Update SFTP in Real Time
Update SFTP data by creating a linked table in Microsoft Access with the CData SFTP ODBC Driver.
-
Build Charts with MySQL in Clear Analytics
Create dynamic charts and perform analytics based on MySQL in Clear Analytics.
-
Build Pipelines with Live Azure Analysis Services in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Azure Analysis Services from Google Cloud Data Fusion, enabling the integration of live Azure Analysis Services into the building and management of effective data pipelines.
-
Create Jira Service Management-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Jira Service Management from Klipfolio and build custom visualizations using live Atlassian Jira Service Management.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed MongoDB to Power BI dashboards. Simply drag and drop MongoDB into data visuals on the Power BI canvas.
-
Create Dynamic Active Directory Grids Using the Infragistics XamDataGrid
Learn how you can connect Active Directory to Infragistics XamDataGrid to build dynamic grids.
-
Automate SurveyMonkey Replication to Azure Synapse
Use CData Sync to customize and automate SurveyMonkey replication to Azure Synapse.
-
Provide OData Services of Salesforce Marketing from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Salesforce Marketing Cloud by developing a WCF Service Application.
-
Use Dash to Build to Web Apps on Dynamics 365
Create Python applications that use pandas and Dash to build Dynamics 365-connected web apps.
-
Migrating data from Acumatica to Snowflake using CData SSIS Components.
Easily push Acumatica ERP to Snowflake using the CData SSIS Tasks for Acumatica and Snowflake.
-
Automated Continuous Google Search Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Search replication to SQL Server.
-
How to connect to Workday with Squirrel SQL client
Connect to Workday and execute queries in the Squirrel SQL Client.
-
Access Oracle from MySQL in PHP
Connect to Oracle through the standard MySQL libraries in PHP.
-
Write a Simple Go Application to work with Azure Data Lake Storage on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Data Lake Storage.
-
Automated Continuous ClickUp Replication to MySQL
Use CData Sync for automated, continuous, customizable ClickUp replication to MySQL.
-
Automated Continuous TaxJar Replication to Vertica
Use CData Sync for automated, continuous, customizable TaxJar replication to Vertica.
-
How to Connect DBeaver to Azure Synapse via a JDBC Driver
Manage Azure Synapse with visual tools in DBeaver like the query browser.
-
Build MVC Applications with Connectivity to Tally
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Tally from an ASP.NET MVC application.
-
Use the CData ODBC Driver for NetSuite from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for NetSuite to connect to NetSuite CRM & ERP from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring NetSuite CRM & ERP in Excel.
-
A PostgreSQL Interface for Microsoft Project using the CData ODBC Driver
Use the SQL Gateway and Microsoft Project ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Quickbase
Provide connectivity to Quickbase through an SAP BusinessObjects universe.
-
Enable the Authorize.Net JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Authorize.Net.
-
Build Data Flows from Coinbase to SQL Server using SSIS
Easily back up Coinbase to SQL Server using the SSIS components for Coinbase.
-
Consume Zoho Projects OData Feeds in PowerBuilder
This article demonstrates how to consume Zoho Projects as OData feeds from PowerBuilder using the API Server.
-
How to Create Power BI Visual Reports with Real-Time Adobe Analytics
Use CData Power BI Connectors to visualize Adobe Analytics in Power BI.
-
How to Connect to Live Azure DevOps in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Azure DevOps without replication.
-
Automated Continuous Splunk Replication to Databricks
Use CData Sync for automated, continuous, customizable Splunk replication to Databricks.
-
Import and Visualize Cloudant in Power View
Create data visualizations based on IBM Cloudant in Excel.
-
Connect Redis to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Redis using the CData Python MCP Server.
-
Create Data Visualizations in Cognos BI with Jira
Access Atlassian Jira as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software ODBC Driver for MariaDB in MicroStrategy Desktop
Connect to MariaDB in MicroStrategy Desktop using the CData Software ODBC Driver for MariaDB.
-
Viewing Klaviyo in RAD Studio Data Explorer
How to view Klaviyo in RAD Studio Data Explorer using the CData ODBC Driver for Klaviyo.
-
Explore Geographical Relationships in MySQL with Power Map
Create data visualizations with MySQL in Power Map.
-
Natively Connect to Redshift in PHP
The CData ODBC driver for Redshift enables you to create PHP applications with connectivity to Amazon Redshift. Leverage the native support for ODBC in PHP.
-
Use Dash to Build to Web Apps on IBM Cloud Object Storage
Create Python applications that use pandas and Dash to build IBM Cloud Object Storage-connected web apps.
-
Automated Continuous Slack Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Slack replication to Amazon S3.
-
Build Microsoft Teams Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Microsoft Teams and build visualizations in Tableau Cloud.
-
Use Microsoft Copilot Studio to talk to your Jira Service Management 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 Atlassian Jira Service Management for you.
-
How to Connect to Live Redshift in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Amazon Redshift without replication.
-
Create Informatica Mappings From/To a JDBC Data Source for DB2
Create DB2 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Analyze Gmail with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Gmail from Power Pivot. You will use the Table Import Wizard to load Gmail. You can visually build the import query or use any SQL supported by the driver.
-
Access Cosmos DB as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Azure Cosmos DB from your Oracle system.
-
Automated Continuous Zoho Inventory Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to delimited files (CSV/TSV).
-
How to Query MarkLogic in MySQL Workbench
Execute MySQL queries against live MarkLogic from MySQL Workbench.
-
Amazon DynamoDB Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Amazon DynamoDB facts in real time.
-
Build Google Analytics Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Analytics and build visualizations in Tableau Cloud.
-
Analyze SAP Business One in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP Business One and visualize SAP Business One in SAP Analytics Cloud.
-
Access XML from MySQL in PHP
Connect to XML through the standard MySQL libraries in PHP.
-
Use the CData Software ODBC Driver for SQL Analysis Services in MicroStrategy
Connect to SQL Analysis Services in MicroStrategy Developer using the CData Software ODBC Driver for SQL Analysis Services.
-
Connect to BigQuery in Claris FileMaker Pro
-