CData Software - Knowledge Base
Recent Articles
-
ETL Zoho Projects in Oracle Data Integrator
This article shows how to transfer Zoho Projects into a data warehouse using Oracle Data Integrator.
-
Access Live Facebook in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Facebook into the statistical analysis tools available in SAS JMP. This article shows how to use Facebook in the Graph Builder and Query Builder.
-
DataBind Controls to Google Calendar in C++Builder
DataBind to Google Calendar in C++Builder with standard components and controls.
-
Working with Sage 200 in LINQPad
Execute LINQ queries to Sage 200 in LINQPad.
-
Consume SAP HANA XS Advanced OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP HANA XS Advanced feeds that reflect any changes in SAP Lumira.
-
Visualize Splunk from Tableau
Use the Tableau Desktop business intelligence tool to connect to Splunk.
-
Create Twilio Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Drift from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Drift from HeidiSQL.
-
Use the CData ODBC Driver for Greenplum in Microsoft Power Query
You can use the CData Greenplum ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Pivotal GreenPlum into Microsoft Power Query.
-
How to use SQLAlchemy ORM to access QuickBooks in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of QuickBooks Desktop.
-
NetSuite Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to NetSuite CRM & ERP through CData Connect AI using different applications and tools.
-
LINQ to Typeform
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 Typeform Data Provider.
-
Automated Continuous Klipfolio Replication to SQL Server
Use CData Sync for automated, continuous, customizable Klipfolio replication to SQL Server.
-
DataBind QuickBooks Time to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for QuickBooks Time with the DevExpress Windows Forms and Web controls to provide QuickBooks Time to a chart.
-
Connect and Query Live Office 365 Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft Office 365 into Databricks
-
Automated Continuous Invoiced Replication to Oracle
Use CData Sync for automated, continuous, customizable Invoiced replication to Oracle.
-
Design BIRT Reports on Databricks
Provide current Databricks to your embedded analytics.
-
Access Twitter as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Twitter from your Oracle system.
-
Connect to Live Sugar CRM in PostGresSQL Interface through CData Connect AI
Create a live connection to Sugar CRM in CData Connect AI and connect to your Sugar CRM from PostgreSQL.
-
Load Dynamics 365 to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Dynamics 365 to a database.
-
Query Square in DataGrip
Create a Data Source for Square in DataGrip and use SQL to query live Square.
-
Integrate with SFTP using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SFTP to a JSON file on disk.
-
Visualize QuickBooks in TIBCO Spotfire through OData
Integrate QuickBooks Desktop into dashboards in TIBCO Spotfire.
-
Visualize Live Dynamics CRM of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Dynamics CRM using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Adobe Commerce in Cognos Analytics
Use CData Connect AI to connect to Adobe Commerce from Cognos Analytics and analyze live Adobe Commerce.
-
Connect to Live MariaDB in PostGresSQL Interface through CData Connect AI
Create a live connection to MariaDB in CData Connect AI and connect to your MariaDB from PostgreSQL.
-
Replicate Pipedrive in Heroku for Use in Salesforce Connect
Replicate Pipedrive to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Google Ad Manager from PowerBuilder via ADO.NET
This article demonstrates how to access Google Ad Manager from Appeon PowerBuilder using the CData ADO.NET Provider for Google Ad Manager.
-
Rapidly Develop Reckon Accounts Hosted-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.
-
Connect to Reckon 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 Reckon.
-
Integrate Live SAP SuccessFactors into Blue Prism for Intelligent Robotic Process Automation (RPA)
-