CData Software - Knowledge Base
Recent Articles
-
DataBind Charts to Trello
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Trello from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
How to Connect to Live Reckon Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Reckon securely in real time.
-
How to Use a Microsoft Access Database to Update SAP Concur in Real Time
Update SAP Concur data by creating a linked table in Microsoft Access with the CData SAP Concur ODBC Driver.
-
Establish a Live Connection with SAP Fieldglass using Tableau Bridge
The CData ODBC Driver for SAP Fieldglass enables you to integrate live SAP Fieldglass into Tableau Cloud dashboards using the Tableau Bridge.
-
Using the CData Software ODBC Driver for SQL Server in PyCharm
Connect to SQL Server as an ODBC data source in PyCharm using the CData Software ODBC Driver for SQL Server.
-
How to connect to Snowflake from IntelliJ
Integrate connectivity to Snowflake with wizards in IntelliJ.
-
Import Real-Time Gmail via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Gmail in ColdFusion.
-
Access Sybase as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sybase from your Oracle system.
-
Import Redshift into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Amazon Redshift. In this article, you will use the OData format to import Amazon Redshift into Microsoft Power Query.
-
Connect to Live Cassandra in MicroStrategy through CData Connect AI
Create a live connection to Cassandra in CData Connect AI and connect to your Apache Cassandra from MicroStrategy.
-
How to integrate Google Sheets with Apache Airflow
Access and process Google Sheets in Apache Airflow using the CData JDBC Driver.
-
Build eBay Analytics-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to eBay Analytics and build web apps with connectivity to live eBay Analytics.
-
Import and Visualize HCL Domino in Power View
Create data visualizations based on HCL Domino in Excel.
-
Access Live Xero in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Xero Accounting from your Excel spreadsheets.
-
Excel Spreadsheet Automation on Dynamics 365 with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Integrate YouTube Analytics in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live YouTube Analytics from Informatica Cloud.
-
Automated Continuous BambooHR Replication to Amazon S3
Use CData Sync for automated, continuous, customizable BambooHR replication to Amazon S3.
-
Choosing the Best Method to Connect MYOB AccountRight to SQL Server: 5 Options Explained
Discover multiple ways to connect and use MYOB AccountRight from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
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.
-
Enable the Drift JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Drift.
-
Prepare, Blend, and Analyze Google Analytics in Alteryx Designer (Connect AI)
Build workflows to access live Google Analytics for self-service data analytics.
-
Create AlloyDB-Connected Dashboards in Grafana
Connect to AlloyDB via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google AlloyDB.
-
Connect to DocuSign in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for DocuSign and connect to DocuSign in Akorbi Digital RunMyProcess.
-
Manage Cloudant in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Cloudant.
-
Easily Integrate Klipfolio in Lazarus Pascal IDE
Learn how to easily integrate live Klipfolio in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Zoho CRM from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zoho CRM from HeidiSQL.
-
Configure the CData JDBC Driver for QuickBooks Time in a Connection Pool in Tomcat
Connect to QuickBooks Time from a connection pool in Tomcat.
-
Replicate Multiple QuickBooks Online Accounts via the CData Sync CLI
Replicate multiple QuickBooks Online accounts to one or many databases.
-
Connect to Google Contacts from AWS Glue
Use CData Connect AI to gain access to live Google Contacts from your AWS Glue jobs.
-
Connect to Redshift through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Redshift using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
View Reports on Real-Time LinkedIn Ads in Power BI Report Server
Use the CData ODBC Driver for LinkedIn Ads to visualize LinkedIn Ads in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData SSIS Components to Insert New or Update Existing Slack Records from SQL Server
Easily push SQL Server data to Slack using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Slack or update existing records with data from a SQL Server database.
-
Write a Simple Go Application to work with Azure Synapse on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Synapse.
-
Create Data Visualizations Based On Oracle HCM Cloud in Mode
Use CData Connect AI to connect to Oracle HCM Cloud from Mode and build visualizations using live
-
Visualize JotForm in Sisense
Create an ElastiCube in Sisense app with access to JotForm.
-
How to connect to Google Contacts with Squirrel SQL client
Connect to Google Contacts and execute queries in the Squirrel SQL Client.
-
Create Data Visualizations Based On Splunk in Mode
Use CData Connect AI to connect to Splunk from Mode and build visualizations using live
-
Build Dashboards with Cosmos DB in Dundas BI
Create dynamic dashboards and perform analytics based on Azure Cosmos DB in Dundas BI.
-
Use the CData Software ODBC Driver for BigCommerce in MicroStrategy
Connect to BigCommerce in MicroStrategy Developer using the CData Software ODBC Driver for BigCommerce.
-
Connect to Google Sheets from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Sheets to connect to Google Sheets from Web applications running on WebLogic.
-
Consume Presto OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Presto feeds that reflect any changes in SAP Lumira.
-
Replicate Multiple Stripe Accounts via the CData Sync CLI
Replicate multiple Stripe accounts to one or many databases.
-
Automated Continuous FHIR Replication to Vertica
Use CData Sync for automated, continuous, customizable FHIR replication to Vertica.
-
Analyze FHIR in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of FHIR and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Use the CData Software ODBC Driver for Sage Cloud Accounting in MicroStrategy Web
Connect to Sage Business Cloud Accounting in MicroStrategy Web using the CData Software ODBC Driver for Sage Cloud Accounting.
-
How to connect to SAP SuccessFactors with Squirrel SQL client
Connect to SAP SuccessFactors and execute queries in the Squirrel SQL Client.
-
Use the CData SSIS Components to Insert New or Update Existing Amazon DynamoDB Records from SQL Server
Easily push SQL Server data to Amazon DynamoDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Amazon DynamoDB or update existing records with data from a SQL Server database.
-
Integrate LDAP Objects in Pentaho Data Integration
Build ETL pipelines based on LDAP in the Pentaho Data Integration tool.
-
Use the CData Software JDBC Driver for XML in MicroStrategy Desktop
Connect to XML Files in MicroStrategy Desktop using the CData Software JDBC Driver for XML.
-
How to Access Live JSON Services in Power Automate Desktop via ODBC
The CData ODBC Driver for JSON enables you to integrate JSON into workflows built using Microsoft Power Automate Desktop.
-
Create Blackbaud FE NXT-Connected Nintex Workflows
Use CData Connect AI to connect to Blackbaud FE NXT from Nintex Workflow Cloud and build custom workflows using live Blackbaud FE NXT.
-
Connect to Salesforce Pardot from a Connection Pool in WebLogic
Use the CData JDBC Driver for Salesforce Pardot to connect to Salesforce Pardot from Web applications running on WebLogic.
-
Connect to Azure Analysis Services in Jaspersoft Studio
Execute SQL to remote Azure Analysis Services in Jaspersoft Studio.
-
Create Informatica Mappings From/To a JDBC Data Source for LinkedIn
Create LinkedIn data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live WordPress in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live WordPress from your Excel spreadsheets.
-
Automated Continuous Tableau CRM Analytics Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Tableau CRM Analytics replication to IBM DB2.
-
Automated Continuous QuickBooks Replication to IBM DB2
Use CData Sync for automated, continuous, customizable QuickBooks replication to IBM DB2.
-
Connect to CockroachDB through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with CockroachDB using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Asana from PowerBuilder via JDBC
This article demonstrates how to access Asana from PowerBuilder using the Asana JDBC Driver.
-
Automated Continuous Instagram Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Instagram replication to IBM DB2.
-
Object-Relational Mapping (ORM) with TaxJar 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 TaxJar into a Java-based ORM framework, Hibernate.
-
Access Live CouchDB in Coginiti Pro
Connect to and query live Apache CouchDB from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Azure DevOps Replication to MySQL
Use CData Sync for automated, continuous, customizable Azure DevOps replication to MySQL.
-
Connect to Smartsheet from HeidiSQL
Use CData Connect AI to connect to and query live Smartsheet from HeidiSQL.
-
Build AI/ML Models with Live Phoenix Data using Dataiku
-