CData Software - Knowledge Base
Recent Articles
-
Extract, Transform, and Load Twitter Ads in Informatica PowerCenter
Create a simple Workflow for Twitter Ads in Informatica PowerCenter.
-
Use the CData Software JDBC Driver for Office 365 in MicroStrategy
Connect to Microsoft Office 365 in MicroStrategy Developer using the CData Software JDBC Driver for Office 365.
-
Connect to Dynamics NAV in RapidMiner
Integrate Microsoft Dynamics NAV with standard components and data source configuration wizards in RapidMiner Studio.
-
Excel Spreadsheet Automation on Amazon S3 with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Replicate Cvent from PowerShell
Write a quick PowerShell script to query Cvent. Use connectivity to the live data to replicate Cvent to SQL Server.
-
Migrating data from SuiteCRM to Snowflake using CData SSIS Components.
Easily push SuiteCRM to Snowflake using the CData SSIS Tasks for SuiteCRM and Snowflake.
-
Using the CData Software ODBC Driver for Twilio in PyCharm
Connect to Twilio as an ODBC data source in PyCharm using the CData Software ODBC Driver for Twilio.
-
Natively Connect to Google Directory in PHP
The CData ODBC driver for Google Directory enables you to create PHP applications with connectivity to Google Directory. Leverage the native support for ODBC in PHP.
-
Automated Continuous XML Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable XML replication to PostgreSQL.
-
Connect to Acumatica in SpagoBI
Create reports featuring live Acumatica ERP in SpagoBI Studio. Host Acumatica reports on SpagoBI Server.
-
Automated Continuous IBM Informix Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable IBM Informix replication to Google BigQuery.
-
Use JayDeBeApi to access Klaviyo in Python
Use standard Python scripting and the development environment of your choice to access live Klaviyo.
-
Use Azure AI Foundry to Talk to Your SAP Ariba Source via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SAP Ariba Source for you.
-
Query Blackbaud FE NXT as a SQL Server Database in Node.js
Execute SQL Server queries against Blackbaud FE NXT from Node.js.
-
Edit and Search External Couchbase Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Couchbase to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Couchbase objects that you can access from apps and the dashboard.
-
Connect to Raisers Edge NXT as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Raisers Edge NXT.
-
Automated Continuous Oracle Sales Replication to Databricks
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Databricks.
-
LINQ to Google Ad Manager
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 Ad Manager Data Provider.
-
Query Twilio in DataGrip
Create a Data Source for Twilio in DataGrip and use SQL to query live Twilio.
-
How to Connect DBeaver to Amazon Marketplace via a JDBC Driver
Manage Amazon Marketplace with visual tools in DBeaver like the query browser.
-
Using the CData Software ODBC Driver for HubDB in PyCharm
Connect to HubDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for HubDB.
-
Create Power BI Reports on Real-Time Google Cloud Storage
Use the CData ODBC Driver for Google Cloud Storage to visualize Google Cloud Storage in Power BI Desktop.
-
Automated Continuous Vault CRM Replication to MySQL
Use CData Sync for automated, continuous, customizable Vault CRM replication to MySQL.
-
Query, Visualize, and Share live Amazon S3 in Redash
Use CData Connect AI to connect to live Amazon S3 in Redash for querying, visualizing, and sharing.
-
Automated Continuous LinkedIn Ads Replication to SQL Server
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to SQL Server.
-
How to update Microsoft Exchange from Excel
This article explains how to transfer data from Excel to Microsoft Exchange using the Excel Add-In for Microsoft Exchange.
-
Automated Continuous RSS Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable RSS replication to Amazon Redshift.
-
Connect to CSV in JRuby
Create a simple JRuby app with access to live CSV/TSV Files.
-
Connect to Gmail in SpagoBI
Create reports featuring live Gmail in SpagoBI Studio. Host Gmail reports on SpagoBI Server.
-
How to Query ShipStation in MySQL Workbench
Execute MySQL queries against live ShipStation from MySQL Workbench.
-
Access Live DocuSign Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live DocuSign data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
ActiveCampaign Reporting in OBIEE with the ActiveCampaign JDBC Driver
Deploy the ActiveCampaign JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Live Clio in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Clio into the statistical analysis tools available in SAS JMP. This article shows how to use Clio in the Graph Builder and Query Builder.
-
Use the CData Software JDBC Driver for Act-On in MicroStrategy Desktop
Connect to Act-On in MicroStrategy Desktop using the CData Software JDBC Driver for Act-On.
-
Use CData Connect AI to Access QuickBooks Time in Microsoft Power Pivot
Use CData Connect AI to connect to live QuickBooks Time in the Power Pivot business intelligence tool.
-
Automated Continuous LDAP Replication to Vertica
Use CData Sync for automated, continuous, customizable LDAP replication to Vertica.
-
How to connect to HubSpot from Spring Boot
Connect to HubSpot in a Spring Boot Application using CData JDBC HubSpot Driver
-
How to Connect DBeaver to Amazon Athena via a JDBC Driver
Manage Amazon Athena with visual tools in DBeaver like the query browser.
-
How to Connect Flowise AI Agents to Live Dynamics 365 Business Central via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
Use the CData Software ODBC Driver for Jira Assets in MicroStrategy
Connect to Jira Assets in MicroStrategy Developer using the CData Software ODBC Driver for Jira Assets.
-
Build Data Flows from ConstantContact to SQL Server using SSIS
Easily back up ConstantContact to SQL Server using the SSIS components for ConstantContact.
-
Replicate Cassandra in Heroku for Use in Salesforce Connect
Replicate Apache Cassandra to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Power BI XMLA in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Power BI XMLA in Airbyte.
-
Migrating data from Salesloft to Google BigQuery using CData SSIS Components.
Easily push Salesloft to Google BigQuery using the CData SSIS Tasks for Salesloft and Google BigQuery.
-
Integrate CockroachDB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate CockroachDB with External Services.
-
Object-Relational Mapping (ORM) with Unbounce Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Unbounce into a Java-based ORM framework, Hibernate.
-
How to Connect to Phoenix in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apache Phoenix. Leverage the pyodbc module for ODBC in Python.
-
Build Snowflake-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Snowflake and create custom apps in Bubble.
-
Create Informatica Mappings From/To an ODBC Data Source for Office 365
Create an ODBC connection to Office 365 in Informatica and browse and transfer Microsoft Office 365.
-
Query MariaDB as a SQL Server Database in Node.js
Execute SQL Server queries against MariaDB from Node.js.
-
Automated Pinterest Replication to Teradata
Use CData Sync to Customize and automate Pinterest replication to Teradata.
-
Build Dashboards with SendGrid in DBxtra
Create dynamic dashboards and perform analytics based on SendGrid in DBxtra.
-
Connect to SingleStore from a Connection Pool in JBoss
Integrate SingleStore into Java servlets: Use the Management Console in JBoss to install the SingleStore JDBC Driver.
-
Access Live Sybase IQ in TIBCO Data Virtualization
-