CData Software - Knowledge Base

Recent Articles

• «
• 666
• 667
• 668
• 669
• 670
• 671
• 672
• 673
• 674
• 675
• »

• How to Connect DBeaver to EnterpriseDB via a JDBC Driver

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

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

  Use CData Power BI Connectors to visualize Sage 200 in Power BI.

• Integrate Oracle Sales with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate Oracle Sales with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Oracle Sales.

• Build MVC Applications with Connectivity to Google Ad Manager

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Ad Manager from an ASP.NET MVC application.

• Analyze WordPress in SAP Analytics Cloud

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

• How to create Visio diagrams from Stripe

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

• Query, Visualize, and Share live Dynamics CRM in Redash

  Use CData Connect AI to connect to live Microsoft Dynamics CRM in Redash for querying, visualizing, and sharing.

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for HDFS

  Provide connectivity to Apache HDFS through an SAP BusinessObjects universe.

• Integrate Live Active Directory into Amazon SageMaker Canvas with RDS

  Use CData Connect AI to connect to Active Directory from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Active Directory.

• Visualize Exact Online in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Exact Online into TIBCO Spotfire.

• Access Salesloft from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Salesloft from HeidiSQL.

• Use JayDeBeApi to access Harvest in Python

  Use standard Python scripting and the development environment of your choice to access live Harvest.

• Getting Started with the CData ODBC Driver for Box

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Box.

• Analyze ActiveCampaign in R via ODBC

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

• Integrate SAP Ariba Source with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate SAP Ariba Source with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP Ariba Source.

• Integrate Real-Time Access to BigQuery in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google BigQuery in real time.

• Access Live Dynamics 365 Business Central in SAS JMP via ODBC

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

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

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

• Use ChatGPT to Talk to Your QuickBooks Online via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your QuickBooks Online for you.

• Create Reports with ClickUp in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date ClickUp.

• Connect and Query Live Cloudant Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live IBM Cloudant into Databricks

• How to Build an ETL App for Acumatica in Python with CData

  Create ETL applications and real-time data pipelines for Acumatica ERP in Python with petl.

• How to Connect to & Open Databricks in Microsoft Excel

  This article uses the CData ODBC driver for Databricks to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Connect to Twitter as an External Data Source using PolyBase

  Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Twitter.

• Build Data Flows from PingOne to SQL Server using SSIS

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

• Connect to Snowflake in RunMyProcess through Connect AI

  Use CData Connect AI to create on OData API for Snowflake and connect to Snowflake in Akorbi Digital RunMyProcess.

• Visualize CSV in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load CSV/TSV Files into TIBCO Spotfire.

• Analyze Raisers Edge NXT with Power Pivot

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

• Import Real-Time Twitter Ads via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Twitter Ads in ColdFusion.

• How to Work with Dynamics CRM in ETL Validator JDBC

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

• Access Snowflake from MySQL in PHP

  Connect to Snowflake through the standard MySQL libraries in PHP.

• Import Twilio into the Power BI Service for Visualizations

  Use CData Connect AI to connect to Twilio and provide access to live Twilio for custom reports in the Power BI Service.

• How to Seamlessly Import xBase Data into IBM SPSS Modeler

  Integrate xBase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Build Visualizations of Oracle Financials Cloud in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle Financials Cloud in Birst.

• Query, Visualize, and Share live Zoho Projects in Redash

  Use CData Connect AI to connect to live Zoho Projects in Redash for querying, visualizing, and sharing.

• Enable the SQL Analysis Services JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with SQL Analysis Services.

• Automate MySQL Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live MySQL and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Connect to Stripe from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Stripe, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Connect to Oracle HCM Cloud in Airbyte ELT Pipelines

  Use CData Connect AI to build ELT pipelines for Oracle HCM Cloud in Airbyte.

• Analyze SAS xpt in R via JDBC

  Use standard R functions and the development environment of your choice to analyze SAS XPORT with the CData JDBC Driver for SAS xpt.

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

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

• Build an OLAP Cube in SSAS from Azure Analysis Services

  Establish a connection to Azure Analysis Services data from SQL Server Analysis Services, and use the Azure Analysis Services Data Provider to build OLAP cubes for use in analytics and reporting.

• Automate Zuora Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Zuora and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Integrate Cassandra into Power Automate Desktop using CData Connect

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

• Connect to Airtable from AWS Glue

  Use CData Connect AI to gain access to live Airtable from your AWS Glue jobs.

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

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

• Build a PostgreSQL Interface for Adobe Commerce using the CData JDBC Driver

  Use the Remoting features of the Adobe Commerce JDBC Driver to create a PostgreSQL entry-point for data access.

• Connect to HubSpot from PowerBuilder via JDBC

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

• Access Live Zoho Inventory in SAS JMP via ODBC

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

• Access Live SAP Ariba Source in AWS Lambda (with IntelliJ IDEA)

  Connect to live SAP Ariba Source in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• How to Query Zoho CRM in MySQL Workbench

  Execute MySQL queries against live Zoho CRM from MySQL Workbench.

• Query Teradata in DataGrip

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

• Connect to HubDB in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• How to connect SharePoint with NetSuite through external lists

  Provide NetSuite CRM & ERP to SharePoint users as an external list.

• Connect to Typeform from PowerBuilder via ADO.NET

  This article demonstrates how to access Typeform from Appeon PowerBuilder using the CData ADO.NET Provider for Typeform.

• Use ChatGPT to Talk to Your ActiveCampaign via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your ActiveCampaign for you.

• Connect to Couchbase from AWS Glue

  Use CData Connect AI to gain access to live Couchbase from your AWS Glue jobs.

• Prepare, Blend, and Analyze SuiteCRM in Alteryx Designer (ODBC)

  Build workflows to access live SuiteCRM for self-service data analytics.

• Validate Quickbase with QuerySurge

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

• Automated Continuous TaxJar Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable TaxJar replication to Google BigQuery.

• Connect to SuiteCRM in HULFT Integrate

  Connect to SuiteCRM as a JDBC data source in HULFT Integrate

• Use CloverDX (formerly CloverETL) and CData JDBC Drivers to Transfer Data

  The CData JDBC Drivers work with all tools that support JDBC. This allows for rapid data integration with a tool of your choice. This article shows how CData drivers can be used from CloverDX, a data integration tool, to transfer data between two data stores.

• Use the CData Software JDBC Driver for Cloudant in MicroStrategy Desktop

  Connect to IBM Cloudant in MicroStrategy Desktop using the CData Software JDBC Driver for Cloudant.

• DataBind Procore to the DevExpress Data Grid

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

• Manage MongoDB in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for MongoDB.

• Query TigerGraph through ODBC in Node.js

  Use node-odbc to execute SQL queries against TigerGraph from Node.js.

• Create Jira-Connected Applications in Appsmith

  Connect to Jira via CData Connect AI in Appsmith and create custom business applications with real-time access to Atlassian Jira.

• Consume Shippo OData Feeds in PowerBuilder

  This article demonstrates how to consume Shippo as OData feeds from PowerBuilder using the API Server.

• Automated Continuous ConstantContact Replication to MySQL

  Use CData Sync for automated, continuous, customizable ConstantContact replication to MySQL.

• Analyze Dynamics CRM in Cognos Analytics

  Use CData Connect AI to connect to Dynamics CRM from Cognos Analytics and analyze live Microsoft Dynamics CRM.

• Use CData Connect AI to Access Blackbaud FE NXT in Microsoft Power Pivot

  Use CData Connect AI to connect to live Blackbaud FE NXT in the Power Pivot business intelligence tool.

• Connect to Shopify in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Shopify and the SQL Gateway to access Shopify from Google Apps Script.

• Use the CData Software ODBC Driver for Azure Active Directory in MicroStrategy Desktop

  Connect to Azure Active Directory in MicroStrategy Desktop using the CData Software ODBC Driver for Azure Active Directory.

• Build ServiceNow Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live ServiceNow and build visualizations in Tableau.

• Query PostgreSQL in ColdFusion

  Write standard ColdFusion data access code to connect to PostgreSQL.

• Integrate Live SAP HANA into Custom Business Apps Built in Power Apps

  Use CData Connect AI to connect to SAP HANA and integrate live SAP HANA into apps built in Microsoft Power Apps.

• Connect Wave Financial to IBM WebSphere Using the CData JDBC Driver

  Use the CData JDBC Driver to connect Wave Financial with IBM WebSphere for seamless data integration and connectivity.

• Connect SAP Ariba Source to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your SAP Ariba Source using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Model Impala Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and Impala, enabling the direct import of real-time Apache Impala.

• Connect SAP Fieldglass to AI Assistants With the CData Python MCP Server

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

• Automate Google Campaign Manager 360 Replication to Azure Synapse

  Use CData Sync to customize and automate Google Campaign Manager 360 replication to Azure Synapse.

• Automated Continuous ConstantContact Replication to SingleStore

  Use CData Sync for automated, continuous, customizable ConstantContact replication to SingleStore.

• Automated Continuous AlloyDB Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable AlloyDB replication to IBM DB2.

• Use JayDeBeApi to access Microsoft Teams in Python

  Use standard Python scripting and the development environment of your choice to access live Microsoft Teams.

• Connect to Dynamics CRM from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Dynamics CRM using standard SQL.

• Connect to Klaviyo in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Klaviyo and the SQL Gateway to access Klaviyo from Google Apps Script.

• Automate SuiteCRM Replication to Azure Data Lake

  Use CData Sync to customize and automate SuiteCRM replication to Azure Data Lake.

• How to Connect to Live Dynamics CRM from Claude Agent SDK (via CData Connect AI)

  Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Microsoft Dynamics CRM for you.

• View Reports on Real-Time xBase in Power BI Report Server

  Use the CData ODBC Driver for xBase to visualize xBase in Power BI Desktop and then publish them to Power BI Report Server.

• Using the CData Software ODBC Driver for WooCommerce in PyCharm

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

• Prepare, Blend, and Analyze Cloudant in Alteryx Designer (Connect AI)

  Build workflows to access live IBM Cloudant for self-service data analytics.

• Deploy the ADO.NET Provider for Microsoft Teams on an SSRS Report Server

  Connect to Microsoft Teams 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.

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

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

• Replicate Multiple Coinbase Accounts

  Replicate multiple Coinbase accounts to one or many databases.

• Replicate Multiple Google Ad Manager Accounts

  Replicate multiple Google Ad Manager accounts to one or many databases.

• Integrating Gumloop with Tableau CRM Analytics via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Tableau CRM Analytics within automated workflows.

• Automated Continuous Sage 50 UK Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Sage 50 UK replication to Azure SQL Database.

• Process & Analyze Google Contacts in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Google Contacts .

• Automated Continuous SAP Fieldglass Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Microsoft Access.

• Integrate with FHIR in JReport Designer

  Create charts and reports based on FHIR in JReport Designer.

• «
• 666
• 667
• 668
• 669
• 670
• 671
• 672
• 673
• 674
• 675
• »