CData Software - Knowledge Base

Recent Articles

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• »

• Using the CData Software ODBC Driver for Monday.com in PyCharm

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

• Operational Reporting on Email from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Email.

• PowerShell Scripting to Replicate Sage 300 to MySQL

  Write a simple PowerShell script to replicate Sage 300 to a MySQL database.

• Integrate Live Active Directory into Custom Business Apps Built in Power Apps

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

• Bidirectional Access to SAP Business One from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate SAP Business One in Filemaker Pro for Mac or Windows.

• How to connect PolyBase to CSV

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live CSV/TSV Files.

• Import Real-Time eBay in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use eBay in ColdFusion.

• Use the CData Software ODBC Driver for MYOB AccountRight in SAS for Real-Time Reporting and Analytics

  Connect to real-time MYOB AccountRight in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MYOB AccountRight.

• Automated Continuous PostgreSQL Replication to Vertica

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

• Analyze SuiteCRM in R

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

• Connect to Unbounce in RapidMiner

  Integrate Unbounce with standard components and data source configuration wizards in RapidMiner Studio.

• How to Visualize Printify Data in Python with pandas

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

• Create Reports from Shopify in Looker Studio

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

• Build Charts with SAP Ariba Procurement in Clear Analytics

  Create dynamic charts and perform analytics based on SAP Ariba Procurement in Clear Analytics.

• Query Pipedrive in MySQL Workbench

  Create a virtual MySQL database for Pipedrive in CData Software Connect (or Connect Server) and work with live Pipedrive in MySQL Workbench.

• Work with Adobe Commerce in FoxPro

  Load Adobe Commerce into a FoxPro database. This article includes full code and a walk-through of the process.

• Connect to Workday in SpagoBI

  Create reports featuring live Workday in SpagoBI Studio. Host Workday reports on SpagoBI Server.

• How to create Visio diagrams from Salesforce

  Automatically update Salesforce & Force.com with the changes you make to Visio master shapes.

• Natively Connect to QuickBooks Time in PHP

  The CData ODBC driver for QuickBooks Time enables you to create PHP applications with connectivity to QuickBooks Time. Leverage the native support for ODBC in PHP.

• Automated Continuous HBase Replication to Snowflake

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

• Connect to Google Ad Manager in CloverDX (formerly CloverETL)

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

• Automate Todoist Replication to Couchbase

  Use CData Sync to Customize and automate Todoist replication to Couchbase.

• How to connect PolyBase to Exact Online

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Exact Online.

• Connect to and Visualize Live TaxJar in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live TaxJar.

• Use Dash to Build to Web Apps on Avalara AvaTax

  Create Python applications that use pandas and Dash to build Avalara AvaTax-connected web apps.

• DataBind Snowflake to the DevExpress Data Grid

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

• Connect to Excel in Google Apps Script

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for xBase

  Provide connectivity to xBase through an SAP BusinessObjects universe.

• Design BIRT Reports on TigerGraph

  Provide current TigerGraph to your embedded analytics.

• Connect to DB2 in NetBeans

  Connect to IBM DB2 in NetBeans with the data source configuration wizard.

• Connect to Quickbase from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for Quickbase to connect to Quickbase and execute queries in PowerBuilder.

• Import Salesforce Pardot into FileMaker Pro

  Create reports that integrate Salesforce Pardot in Filemaker Pro.

• Work with Live Hive in Power Query

  Use CData Connect Cloud to connect to Apache Hive and work with live Apache Hive in Microsoft Power Query.

• Visualize Google Analytics in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for Google Analytics in CData Software Connect (or Connect Server) and build visualizations from live Google Analytics in Tableau Desktop.

• Use Biml to Build SSIS Tasks to Replicate Azure DevOps to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Azure DevOps to SQL Server.

• Import Real-Time Highrise in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Highrise CRM in ColdFusion.

• Integrate Airtable in the Pentaho Report Designer

  Publish reports based on Airtable in the Pentaho BI tool.

• Connect to Active Directory in Jaspersoft Studio

  Execute SQL to remote Active Directory in Jaspersoft Studio.

• DataBind Charts to Active Directory

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Active Directory 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 Use CData Connect to Access Live Calendly in Power Automate

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

• Rapidly Develop Google Ads-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.

• 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.

• Connect to Email in Ruby

  Connect to Email in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• ETL Cvent in Oracle Data Integrator

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

• Access Live CockroachDB in Google Sheets

  Use CData Connect Cloud to gain access to live CockroachDB from your Google Sheets.

• Enable the Gmail JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Gmail.

• Visualize Salesloft from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Salesloft.

• How to use SQLAlchemy ORM to access Wave Financial in Python

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

• Replicate Access for Use in Salesforce Connect

  Replicate Microsoft Access to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Excel Spreadsheet Automation with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Create SSAS Tabular Models from HubSpot

  How to build a SQL Server Analysis Service Tabular Model from HubSpot using CData drivers.

• Perform Batch Operations with Zendesk in Apache NiFi

  Connect to Zendesk and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Connect to SAP SuccessFactors in RazorSQL

  Connect to SAP SuccessFactors from wizards and query SAP SuccessFactors from the GUI in the RazorSQL database management tool.

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

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

• Access Live Google Directory in Excel 365 Online (Excel for the web)

  Connect to Google Directory from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Automated Salesforce Replication to Teradata

  Use CData Sync to Customize and automate Salesforce & Force.com replication to Teradata.

• Connect to Dynamics GP in CloverDX (formerly CloverETL)

  Transfer Microsoft Dynamics GP using the visual workflow in the CloverDX data integration tool.

• Provide OData Services of Printify from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Printify by developing a WCF Service Application.

• Build TaxJar-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to TaxJar and build web apps with connectivity to live TaxJar.

• PowerShell Scripting to Replicate Zoho Books to MySQL

  Write a simple PowerShell script to replicate Zoho Books to a MySQL database.

• Publish Clio-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Clio.

• Query Bing Ads as a MySQL Database in Node.js

  Execute MySQL queries against Bing Ads from Node.js.

• Connect to WordPress in RazorSQL

  Connect to WordPress from wizards and query WordPress from the GUI in the RazorSQL database management tool.

• Write a Simple Go Application to work with Azure Data Catalog on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Data Catalog.

• Access EventBrite from MySQL in HeidiSQL

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

• Prepare, Blend, and Analyze Azure Synapse in Alteryx Designer

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

• Connect to Zoho Books from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Zoho Books from Crystal Reports.

• How to connect to Facebook in DBVisualizer

  Integrate Facebook with visual data analysis tools and data connection wizards in DBVisualizer

• Write a Simple Go Application to work with Instagram on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Instagram.

• How to Visualize DocuSign Data in Python with pandas

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

• Prepare, Blend, and Analyze JSON Services in Alteryx Designer

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

• Excel Spreadsheet Automation with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Connect to Live Google Campaign Manager 360 in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Google Campaign Manager 360 in CData Connect Cloud and connect to your Google Campaign Manager 360 from PostgreSQL.

• Analyze Smartsheet in R

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

• Connect to Sage 300 in DBArtisan

  Use wizards in DBArtisan to configure Sage 300 as a data source.

• Integrate Live WooCommerce into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to WooCommerce from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live WooCommerce.

• How to Visualize Workday Data in Python with pandas

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

• How to Work with HubSpot in AWS Glue Jobs Using JDBC

  Connect to HubSpot from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Create Adobe Commerce Dataflows on PowerBI.com

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

• How to Work with Quickbase in AWS Glue Jobs Using JDBC

  Connect to Quickbase from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Visualize Live Salesforce in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Salesforce & Force.com.

• Automated Continuous SAP Hybris C4C Replication to SQL Server

  Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to SQL Server.

• How to connect to Email in DBVisualizer

  Integrate Email with visual data analysis tools and data connection wizards in DBVisualizer

• Analyze QuickBooks Time in Looker

  Use CData Connect Cloud to connect to QuickBooks Time from Looker and build custom apps using live QuickBooks Time.

• How to Access Oracle HCM Cloud Using Entity Framework

  This article shows how to access Oracle HCM Cloud using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Connect to Live Zenefits in MicroStrategy through CData Software Connect Server

  Create a virtual database for Zenefits in CData Software Connect Server and connect to it from MicroStrategy.

• Import Real-Time Drip in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Drip in ColdFusion.

• Create Reports with Azure Data Catalog in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Azure Data Catalog.

• Automated Continuous Dynamics NAV Replication to Vertica

  Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Vertica.

• Build IBM Cloud Data Engine-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to IBM Cloud Data Engine and build web apps with connectivity to live IBM Cloud Data Engine.

• Build Dashboards with ShipStation in DBxtra

  Create dynamic dashboards and perform analytics based on ShipStation in DBxtra.

• Viewing Drip in RAD Studio Data Explorer

  How to view Drip in RAD Studio Data Explorer using the CData ODBC Driver for Drip.

• Automated Continuous Printify Replication to PostgreSQL

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

• How to Connect to & Open Google Spanner in Microsoft Excel

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

• Import Trello Using Azure Data Factory

  Use CData Connect Cloud to connect to Trello from Azure Data Factory and import live Trello.

• Analyze Google Directory with Power Pivot

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

• LINQ to LinkedIn Ads

  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 LinkedIn Ads Data Provider.

• Query BigQuery in ColdFusion

  Write standard ColdFusion data access code to connect to Google BigQuery.

• Automated Continuous Google Search Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Google Search replication to AlloyDB.

• Connect to SAP Ariba Source in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• »