CData Software - Knowledge Base
Recent Articles
-
Integrate Presto in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Presto from Informatica Cloud.
-
How to connect to BigCommerce in DBVisualizer
Integrate BigCommerce with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect SharePoint with Monday.com through external lists
Provide Monday.com to SharePoint users as an external list.
-
DataBind Zoho Projects to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Zoho Projects with the DevExpress Windows Forms and Web controls to provide Zoho Projects to a chart.
-
Analyze CockroachDB in Looker
Use CData Connect AI to connect to CockroachDB from Looker and build custom apps using live CockroachDB.
-
Excel Spreadsheet Automation on Sage 300 with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Connect to Oracle Service Cloud in NetBeans
Connect to Oracle Service Cloud in NetBeans with the data source configuration wizard.
-
Create Datasets from WooCommerce in Domo Workbench and Build Visualizations of WooCommerce in Domo
Use the CData Software ODBC Driver for WooCommerce to create datasets from WooCommerce in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect DBeaver to Square via a JDBC Driver
Manage Square with visual tools in DBeaver like the query browser.
-
Automate Confluence Replication to Azure Data Lake
Use CData Sync to customize and automate Atlassian Confluence replication to Azure Data Lake.
-
Integrate Google Campaign Manager 360 with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Campaign Manager 360 with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Campaign Manager 360.
-
Automated Continuous Cosmos DB Replication to Oracle
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Oracle.
-
Connect to Shippo in Ruby
Connect to Shippo in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect to Zuora from Spring Boot
Connect to Zuora in a Spring Boot Application using CData JDBC Zuora Driver
-
Integrate Certinia with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Certinia with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Certinia.
-
Integrate Twilio with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Twilio with External Services.
-
Connect to Klaviyo from PowerBuilder via ADO.NET
This article demonstrates how to access Klaviyo from Appeon PowerBuilder using the CData ADO.NET Provider for Klaviyo.
-
Connect to Procore in RazorSQL
Connect to Procore from wizards and query Procore from the GUI in the RazorSQL database management tool.
-
How to integrate xBase with Apache Airflow
Access and process xBase in Apache Airflow using the CData JDBC Driver.
-
Connect to Zoho Projects in SpagoBI
Create reports featuring live Zoho Projects in SpagoBI Studio. Host Zoho Projects reports on SpagoBI Server.
-
Query, Visualize, and Share live Twilio in Redash
Use CData Connect AI to connect to live Twilio in Redash for querying, visualizing, and sharing.
-
Connect to LinkedIn Ads in Ruby
Connect to LinkedIn Ads in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Azure DevOps Replication to Databricks
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Databricks.
-
Access Freshdesk from MySQL in PHP
Connect to Freshdesk through the standard MySQL libraries in PHP.
-
Build Greenhouse-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Greenhouse and build web apps with connectivity to live Greenhouse.
-
Connecting Agentforce with Azure Table via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Azure Table Storage for you.
-
Establish a Live Connection with SAP BusinessObjects BI using Tableau Bridge
The CData ODBC Driver for SAP BusinessObjects BI enables you to integrate live SAP BusinessObjects BI into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Live Hive in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Apache Hive into custom reports in Power BI.
-
Build Printify-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Printify and build web apps with connectivity to live Printify.
-
Consume GitHub OData Feeds in SAP Lumira
Use the API Server to create data visualizations on GitHub feeds that reflect any changes in SAP Lumira.
-
Configure the CData JDBC Driver for LinkedIn in a Connection Pool in Tomcat
Connect to LinkedIn from a connection pool in Tomcat.
-
Create Informatica Mappings From/To an ODBC Data Source for Twitter
Create an ODBC connection to Twitter in Informatica and browse and transfer Twitter.
-
Import Azure Synapse into the Power BI Service for Visualizations
Use CData Connect AI to connect to Azure Synapse and provide access to live Azure Synapse for custom reports in the Power BI Service.
-
How to Query Azure DevOps in MySQL Workbench
Execute MySQL queries against live Azure DevOps from MySQL Workbench.
-
How to Query Live CockroachDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live CockroachDB data in natural language using Python.
-
Create BigQuery Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time BigQuery data access from reports, embedded analytics, and more.
-
Stream Klipfolio into Apache Kafka Topics
Access and stream Klipfolio in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live Instagram in Coginiti Pro
Connect to and query live Instagram from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for SuiteCRM in MicroStrategy Desktop
Connect to SuiteCRM in MicroStrategy Desktop using the CData Software ODBC Driver for SuiteCRM.
-
Automated Continuous Couchbase Replication to Oracle
Use CData Sync for automated, continuous, customizable Couchbase replication to Oracle.
-
Create Reports from Outreach.io in Looker Studio
Use CData Connect AI to gain access to live Outreach.io and create custom reports in Looker Studio.
-
Integrate Outreach.io in the Pentaho Report Designer
Publish reports based on Outreach.io in the Pentaho BI tool.
-
How to connect and process Google Sheets from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Sheets.
-
Build a Simple VCL Application for Invoiced
How to build a simple VCL Application to view Invoiced in RAD Studio using the CData ODBC Driver for Invoiced.
-
Visualize Azure DevOps in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Azure DevOps into TIBCO Spotfire.
-
Stream WordPress into Apache Kafka Topics
Access and stream WordPress in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Edit and Search Asana External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Asana to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Asana objects that you can access from apps and the dashboard.
-
Build Pipelines with Live Cassandra in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Cassandra from Google Cloud Data Fusion, enabling the integration of live Apache Cassandra into the building and management of effective data pipelines.
-
Integrate Live NetSuite into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to NetSuite CRM & ERP and integrate live NetSuite CRM & ERP into apps built in Microsoft Power Apps.
-
Deploy the ADO.NET Provider for Outreach.io on an SSRS Report Server
Connect to Outreach.io 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.
-
Choosing the Best Method to Connect Exact Online to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Exact Online from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software ODBC Driver for Facebook Ads in MicroStrategy Web
Connect to Facebook Ads in MicroStrategy Web using the CData Software ODBC Driver for Facebook Ads.
-
View Reports on Real-Time Google Contacts in Power BI Report Server
Use the CData ODBC Driver for Google Contacts to visualize Google Contacts in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Seamlessly Import Cloudant Data into IBM SPSS Modeler
Integrate Cloudant data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Replicate Multiple MariaDB Accounts via the CData Sync CLI
Replicate multiple MariaDB accounts to one or many databases.
-
Visualize Live Oracle Sales of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Oracle Sales using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Semantic Layer Views for Shippo in APOS Live Data Gateway
Use the CData Connector for Shippo in APOS Live Data Gateway to build Semantic Layer Views for Shippo.
-
How to Connect DBeaver to Microsoft Exchange via a JDBC Driver
Manage Microsoft Exchange with visual tools in DBeaver like the query browser.
-
Deploy the ADO.NET Provider for Sage 300 on an SSRS Report Server
Connect to Sage 300 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.
-
Using the CData Software ODBC Driver for Sage 50 UK in PyCharm
Connect to Sage 50 UK as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sage 50 UK.
-
How to Access Cassandra Using Entity Framework
This article shows how to access Apache Cassandra using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automate Elasticsearch Replication to Couchbase
Use CData Sync to Customize and automate Elasticsearch replication to Couchbase.
-
Connect to SAP Ariba Source from PowerBuilder via JDBC
This article demonstrates how to access SAP Ariba Source from PowerBuilder using the SAP Ariba Source JDBC Driver.
-
Connecting Mastra with MySQL via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.
-
Rapidly Develop Acumatica-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Connect to Live QuickBooks Online in PostGresSQL Interface through CData Connect AI
Create a live connection to QuickBooks Online in CData Connect AI and connect to your QuickBooks Online from PostgreSQL.
-
Build Salesforce Marketing-Connected Apps in Choreo
Use CData Connect AI to connect to Salesforce Marketing from Choreo and build custom apps using live Salesforce Marketing Cloud.
-
Create Informatica Mappings From/To an ODBC Data Source for BambooHR
Create an ODBC connection to BambooHR in Informatica and browse and transfer BambooHR.
-
Automated Continuous Blackbaud FE NXT Replication to MongoDB
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to MongoDB.
-
Use the CData SSIS Components to Insert New or Update Existing Impala Records from SQL Server
Easily push SQL Server data to Impala using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Impala or update existing records with data from a SQL Server database.
-
Automated Continuous PostgreSQL Replication to Amazon S3
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Amazon S3.
-
Build AI/ML Models with Live Dynamics 365 Data using Dataiku
-