CData Software - Knowledge Base

Recent Articles

• «
• 424
• 425
• 426
• 427
• 428
• 429
• 430
• 431
• 432
• 433
• »

• How to Create Power BI Visual Reports with Real-Time GraphQL

  Use CData Power BI Connectors to visualize GraphQL in Power BI.

• Use the CData Software ODBC Driver for Exact Online in MicroStrategy Desktop

  Connect to Exact Online in MicroStrategy Desktop using the CData Software ODBC Driver for Exact Online.

• Natively Connect to Quickbase in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Quickbase. Leverage the native support for ODBC in PHP.

• Connect to Google Calendar in CloverDX (formerly CloverETL)

  Transfer Google Calendar using the visual workflow in the CloverDX data integration tool.

• Visualize Dropbox in TIBCO Spotfire through ADO.NET

  Integrate Dropbox into dashboards in TIBCO Spotfire.

• Design BIRT Reports on Excel

  Provide current Microsoft Excel to your embedded analytics.

• Analyze Google Campaign Manager 360 in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Google Campaign Manager 360 and visualize Google Campaign Manager 360 in SAP Analytics Cloud.

• Automated Continuous HBase Replication to SQLite

  Use CData Sync for automated, continuous, customizable HBase replication to SQLite.

• How to connect to Adobe Analytics in DBVisualizer

  Integrate Adobe Analytics with visual data analysis tools and data connection wizards in DBVisualizer

• Connect to Quickbase in ACL Analytics

  Connect to Quickbase via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to Quickbase.

• Analyze Live Presto in SAS Viya

  Use CData Connect Cloud to connect to Presto from SAS Viya and deploy self-service analytics using live Presto.

• Integrate Live Power BI XMLA into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Power BI XMLA and integrate live Power BI XMLA into apps built in Microsoft Power Apps.

• How to create Visio diagrams from HubSpot

  Automatically update HubSpot with the changes you make to Visio master shapes.

• Connect to Sage Intacct in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• How to connect to HubSpot with Squirrel SQL client

  Connect to HubSpot and execute queries in the Squirrel SQL Client.

• Automated Continuous EventBrite Replication to SQL Server

  Use CData Sync for automated, continuous, customizable EventBrite replication to SQL Server.

• How to integrate SharePoint with Apache Airflow

  Access and process Microsoft SharePoint in Apache Airflow using the CData JDBC Driver.

• Establish a Live Connection with Oracle HCM Cloud using Tableau Bridge

  The CData ODBC Driver for Oracle HCM Cloud enables you to integrate live Oracle HCM Cloud into Tableau Cloud dashboards using the Tableau Bridge.

• Connect MySQL to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live MySQL using the CData Python MCP Server.

• Access Live Google Directory in AWS Lambda

  Connect to live Google Directory in AWS Lambda using the CData JDBC Driver.

• Prepare, Blend, and Analyze Google Data Catalog in Alteryx Designer (ODBC)

  Build workflows to access live Google Data Catalog for self-service data analytics.

• How to Access Live Google Drive in Visual Studio Code via Cline

  Run the CData MCP Server for Google Drive on Windows Subsytem for Linux (WSL) and connect to live Google Drive from the Cline extension in Visual Studio Code.

• Extend Google Sheets with Dynamics 365 Business Central

  Make calls to the API Server from Google Apps Script.

• Analyze Confluence in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Atlassian Confluence with the CData JDBC Driver for Confluence.

• Process & Analyze SAP HANA in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live SAP HANA .

• Import Real-Time Kintone via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Kintone in ColdFusion.

• Build Automated Workflows with Live Zoho Creator in Workato

  Use CData Connect Cloud to connect to live Zoho Creator and build automated workflows in Workato.

• How to create Zoho Inventory federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Zoho Inventory in MySQL .

• Analyze BigCommerce in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze BigCommerce in Microsoft R Open.

• Use the CData Software ODBC Driver for Marketo in MicroStrategy

  Connect to Marketo in MicroStrategy Developer using the CData Software ODBC Driver for Marketo.

• How to update Oracle Sales from Excel

  This article explains how to transfer data from Excel to Oracle Sales using the Excel Add-In for Oracle Sales.

• Validate Drip with QuerySurge

  Access and validate Drip in QuerySurge using the CData JDBC Driver.

• ETL PayPal in Oracle Data Integrator

  This article shows how to transfer PayPal into a data warehouse using Oracle Data Integrator.

• Automated Continuous Neo4J Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Neo4J replication to PostgreSQL.

• How to Query EventBrite in MySQL Workbench

  Execute MySQL queries against live Eventbrite from MySQL Workbench.

• How to Visualize Zuora Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Zuora in Python.

• Automated Continuous Act-On Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Act-On replication to Azure SQL Database.

• Replicate Multiple eBay Accounts via the CData Sync CLI

  Replicate multiple eBay accounts to one or many databases.

• Build Data Flows from Redis to SQL Server using SSIS

  Easily back up Redis to SQL Server using the SSIS components for Redis.

• Create Twitter Ads-Connected Dashboards in Grafana

  Connect to Twitter Ads via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Twitter Ads.

• Replicate Multiple Salesforce Accounts via the CData Sync CLI

  Replicate multiple Salesforce accounts to one or many databases.

• Access Live Sage Cloud Accounting in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Sage Business Cloud Accounting into the statistical analysis tools available in SAS JMP. This article shows how to use Sage Business Cloud Accounting in the Graph Builder and Query Builder.

• Automate Kintone Replication to SAP HANA

  Use CData Sync to customize and automate Kintone replication to SAP HANA.

• Automated Continuous Splunk Replication to SQLite

  Use CData Sync for automated, continuous, customizable Splunk replication to SQLite.

• Build a Singer.io Tap for Instagram With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Instagram data using

• Replicate Multiple Zoho Books Accounts via the CData Sync CLI

  Replicate multiple Zoho Books accounts to one or many databases.

• Build Data Flows from Salesforce to SQL Server using SSIS

  Easily back up Salesforce & Force.com to SQL Server using the SSIS components for Salesforce.

• Connect to Google Cloud Storage from a Connection Pool in Jetty

  The Google Cloud Storage JDBC Driver supports connection pooling: This article shows how to connect faster to Google Cloud Storage from Web apps in Jetty.

• Model Adobe Analytics Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Adobe Analytics, enabling the direct import of real-time Adobe Analytics.

• Automated Continuous Bing Ads Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Bing Ads replication to Microsoft Access.

• Analyze FHIR with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for FHIR from Power Pivot. You will use the Table Import Wizard to load FHIR. You can visually build the import query or use any SQL supported by the driver.

• Stream Reckon Accounts Hosted into Apache Kafka Topics

  Access and stream Reckon Accounts Hosted in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Access Live Workday in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Workday into the statistical analysis tools available in SAS JMP. This article shows how to use Workday in the Graph Builder and Query Builder.

• Replicate Avro to Multiple Databases

  Replicate Apache Avro to disparate databases with a point-and-click configuration.

• Create Exact Online-Connected Applications in Appsmith

  Connect to Exact Online via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Exact Online.

• Connect to LinkedIn Ads as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live LinkedIn Ads.

• Automated Continuous PayPal Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable PayPal replication to Google Cloud SQL.

• How to use SQLAlchemy ORM to access Typeform in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Typeform.

• Analyze Greenplum in Cognos Analytics

  Use CData Connect Cloud to connect to Greenplum from Cognos Analytics and analyze live Pivotal GreenPlum.

• Migrating data from HubDB to Google BigQuery using CData SSIS Components.

  Easily push HubDB to Google BigQuery using the CData SSIS Tasks for HubDB and Google BigQuery.

• Automated GraphQL Replication to Teradata

  Use CData Sync to Customize and automate GraphQL replication to Teradata.

• Using the CData Software ODBC Driver for Zoho Projects in PyCharm

  Connect to Zoho Projects as an ODBC data source in PyCharm using the CData Software ODBC Driver for Zoho Projects.

• Zoho Creator Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Zoho Creator facts in real time.

• Automated Redis Replication to Teradata

  Use CData Sync to Customize and automate Redis replication to Teradata.

• Create PayPal Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• Integrate with Jira Service Management in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Atlassian Jira Service Management in SnapLogic.

• Publish Greenplum-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Pivotal GreenPlum.

• How to use SQLAlchemy ORM to access Klipfolio in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Klipfolio.

• Integrate Bullhorn CRM into Power Automate Desktop using CData Connect

  CData Connect for Bullhorn CRM enables you to integrate Bullhorn CRM into workflows built using Microsoft Power Automate Desktop.

• Integrate Zoho Inventory in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zoho Inventory from Informatica Cloud.

• Build a Simple VCL Application for Jira Assets

  How to build a simple VCL Application to view Jira Assets in RAD Studio using the CData ODBC Driver for Jira Assets.

• Access Live Email in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for Email to create a Email source in TIBCO Data Virtualization Studio and gain access to live Email from your TDV Server.

• Analyze MailChimp in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of MailChimp and visualize MailChimp in SAP Analytics Cloud.

• Use the CData Software ODBC Driver for EnterpriseDB in MicroStrategy

  Connect to EnterpriseDB in MicroStrategy Developer using the CData Software ODBC Driver for EnterpriseDB.

• How to Connect DBeaver to SFTP via a JDBC Driver

  Manage SFTP with visual tools in DBeaver like the query browser.

• Connect to PostgreSQL from PowerBuilder via JDBC

  This article demonstrates how to access PostgreSQL from PowerBuilder using the PostgreSQL JDBC Driver.

• Integrate Zendesk in the Pentaho Report Designer

  Publish reports based on Zendesk in the Pentaho BI tool.

• Build a Simple VCL Application for Sage Intacct

  How to build a simple VCL Application to view Sage Intacct in RAD Studio using the CData ODBC Driver for Sage Intacct.

• Query Snowflake from Node.js

  Use the OData endpoint of the CData API Server to connect to your Snowflake and perform CRUD operations on Snowflake from Node.js.

• Access Live NetSuite in Excel (Desktop) via Connect Cloud

  Use CData Connect Cloud to gain access to live NetSuite CRM & ERP from your Excel spreadsheets.

• Create Basecamp Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Basecamp data access from reports, embedded analytics, and more.

• Create Reports from Freshdesk in Looker Studio

  Use CData Connect Cloud to gain access to live Freshdesk and create custom reports in Looker Studio.

• Connect to OneNote in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• How to use SQLAlchemy ORM to access Splunk in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Splunk.

• Query eBay in DataGrip

  Create a Data Source for eBay in DataGrip and use SQL to query live eBay.

• Integrate with Sybase using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sybase to a JSON file on disk.

• Visualize Oracle Sales in Sisense

  Create an ElastiCube in Sisense app with access to Oracle Sales.

• Choosing the Best Method to Connect LinkedIn Ads to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use LinkedIn Ads from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Salesforce Marketing Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Salesforce Marketing facts in real time.

• How to Work with ShipStation in ETL Validator JDBC

  Connect to ShipStation from ETL Validator jobs using the CData Software JDBC Driver.

• Automated Sybase Replication to Teradata

  Use CData Sync to Customize and automate Sybase replication to Teradata.

• Access FTP as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access FTP Servers from your Oracle system.

• How to integrate Metabase with Marketo

  Use CData Connect Cloud to connect to live Marketo and create an interactive dashboard in Metabase from Marketo.

• Replicate Salesforce Data to SAP Datasphere with CData Sync

  Use CData Sync to replicate Salesforce data into SAP Datasphere via SAP HANA.

• DataBind Salesforce to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Salesforce with the DevExpress Windows Forms and Web controls to provide Salesforce & Force.com to a chart.

• Access Live Microsoft Project in Coginiti Pro

  Connect to and query live Microsoft Project from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Connect and Visualize Live Smartsheet Data in Databricks Lakehouse Federation with CData Connect Cloud

  Use CData Connect Cloud to integrate live Smartsheet into the Databricks platform and create visualization dashboards with real-time Smartsheet.

• Access Google Ads from MySQL in PHP

  Connect to Google Ads through the standard MySQL libraries in PHP.

• Automated Continuous Hive Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Hive replication to SQL Server.

• Integrate with Asana using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Asana to a JSON file on disk.

• «
• 424
• 425
• 426
• 427
• 428
• 429
• 430
• 431
• 432
• 433
• »