CData Software - Knowledge Base

Recent Articles

• «
• 458
• 459
• 460
• 461
• 462
• 463
• 464
• 465
• 466
• 467
• »

• Connect to Facebook in SpagoBI

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

• Automated Continuous Amazon Athena Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Amazon Athena replication to Amazon S3.

• Load Okta to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Okta to a database.

• Integrate with SAP HANA using Apache Camel2

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

• Use the CData Software ODBC Driver for SAP Ariba Source in MicroStrategy

  Connect to SAP Ariba Source in MicroStrategy Developer using the CData Software ODBC Driver for SAP Ariba Source.

• Create Datasets from Dynamics 365 Business Central in Domo Workbench and Build Visualizations of Dynamics 365 Business Central in Domo

  Use the CData Software ODBC Driver for Dynamics 365 Business Central to create datasets from Dynamics 365 Business Central in Domo Workbench and then build visualizations in the Domo service.

• Connect to Google Drive in Aqua Data Studio

  Access Google Drive from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Use JayDeBeApi to access Drift in Python

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

• Publish Microsoft Teams-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Microsoft Teams.

• Connect to Sage 200 from a Connection Pool in Jetty

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

• Build Dashboards with Cvent in DBxtra

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

• Query Epicor Kinetic from Node.js

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

• Automated Continuous Amazon Marketplace Replication to SQLite

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

• Create Dynamic Google Contacts Grids Using the Infragistics XamDataGrid

  Learn how you can connect Google Contacts to Infragistics XamDataGrid to build dynamic grids.

• DataBind Charts to Square

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Square 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.

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

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

• Analyze Dynamics NAV in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Microsoft Dynamics NAV and visualize live Microsoft Dynamics NAV in Ingragistics Reveal.

• Connect to SharePoint as an External Source in Dremio

  Use the CData JDBC Driver to connect to SharePoint as an External Source in Dremio.

• How to Seamlessly Import Epicor Kinetic Data into IBM SPSS Modeler

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

• Connect to Square from Crystal Reports

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

• Visualize Google Analytics in TIBCO Spotfire through ODBC

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

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

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

• Query NetSuite in DataGrip

  Create a Data Source for NetSuite in DataGrip and use SQL to query live NetSuite CRM & ERP.

• Easily Integrate Blackbaud FE NXT in Lazarus Pascal IDE

  Learn how to easily integrate live Blackbaud FE NXT in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Connect to HBase in JRuby

  Create a simple JRuby app with access to live Apache HBase.

• Write a Simple Go Application to work with Oracle Service Cloud on Linux

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

• Create Data Visualizations in Cognos BI with Dynamics 365 Business Central

  Access Dynamics 365 Business Central as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Analyze Tally with Power Pivot

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

• Replicate Unbounce from PowerShell

  Write a quick PowerShell script to query Unbounce. Use connectivity to the live data to replicate Unbounce to SQL Server.

• Query Drip as a MySQL Database in Node.js

  Execute MySQL queries against Drip from Node.js.

• Use the CData Software JDBC Driver for Salesforce Data Cloud in MicroStrategy Desktop

  Connect to Salesforce Data Cloud in MicroStrategy Desktop using the CData Software JDBC Driver for Salesforce Data Cloud.

• Design BIRT Reports on ServiceNow

  Provide current ServiceNow to your embedded analytics.

• Analyze Azure Active Directory in R via ODBC

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

• Use the CData Software JDBC Driver for Avro in MicroStrategy Web

  Connect to Apache Avro in MicroStrategy Web using the CData Software JDBC Driver for Avro.

• How to create Visio diagrams from Microsoft Planner

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

• LINQ to Azure Table

  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 Azure Table Data Provider.

• Connect to Square from PowerBuilder via ODBC

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

• Analyze Greenhouse in R via JDBC

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

• Visualize Live Paylocity of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Paylocity using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

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

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

• Integrate Live Odoo into Custom Business Apps Built in Power Apps

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

• Automated Continuous OneNote Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable OneNote replication to Azure SQL Database.

• Automated Continuous MYOB AccountRight Replication to MySQL

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

• Build MVC Applications with Connectivity to Box

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

• Visualize Live Zoho CRM of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Zoho CRM using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Connect Zoho CRM to AI Assistants With the CData Python MCP Server

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

• How to Import Data from Blackbaud FE NXT into Google Sheets

  Import Blackbaud FE NXT into a Google spreadsheet that is automatically refreshed.

• How to use SQLAlchemy ORM to access Procore in Python

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

• Automated Continuous Cosmos DB Replication to SingleStore

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

• Bidirectional Access to Avro from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Apache Avro in Filemaker Pro for Mac or Windows.

• Connect to Zendesk from Excel & GoogleSheets!

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

• Easily Integrate Salesforce in Lazarus Pascal IDE

  Learn how to easily integrate live Salesforce & Force.com in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Use Claude to Talk to Your Smartsheet via CData Connect Cloud

  Leverage CData Connect Cloud Remote MCP to enable Claude to securely answer questions and take actions on your Smartsheet for you.

• Access Azure Active Directory from MySQL in Amazon QuickSight

  Connect to Azure Active Directory and build visualizations of Azure Active Directory using a MySQL Connection in Amazon QuickSight.

• Import Excel Online into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Excel Online. In this article, you will use the OData format to import Microsoft Excel Online into Microsoft Power Query.

• Analyze Azure Analysis Services in SAP Analytics Cloud

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

• Build Data Flows from SQL Server to Salesforce Marketing through SSIS

  Easily push SQL Server data to Salesforce Marketing using the CData SSIS Tasks for Salesforce Marketing.

• Viewing Sage 300 in RAD Studio Data Explorer

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

• Automated Continuous Oracle Service Cloud Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to delimited files (CSV/TSV).

• Integrate with Snapchat Ads in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Snapchat Ads in SnapLogic.

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

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

• Model, Search, and Visualize Live MYOB AccountRight in ThoughtSpot

  Use CData Connect Cloud to connect to live MYOB AccountRight for modeling, searching, and visualizing.

• Create Data Visualizations in Cognos BI with Okta

  Access Okta as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Access Live Zoho CRM in AWS Lambda

  Connect to live Zoho CRM in AWS Lambda using the CData JDBC Driver.

• Extend Google Sheets with Monday.com

  Make calls to the API Server from Google Apps Script.

• Connect to Stripe in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Stripe in the Denodo Virtual DataPort Administrator.

• Use Dash to Build to Web Apps on Elasticsearch

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

• Connect to and Visualize Live Airtable in Tableau Prep

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

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

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

• Query QuickBooks Online as a SQL Server Database in Node.js

  Execute SQL Server queries against QuickBooks Online from Node.js.

• Automated Continuous Salesforce Replication to Microsoft Access

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

• Automated Continuous Klipfolio Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Klipfolio replication to Apache Kafka.

• Connect Google Analytics to AI Assistants With the CData Python MCP Server

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

• Build NetSuite-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live NetSuite CRM & ERP.

• Building Dynamic Web Pages with Act-On Using AngularJS

  Create single-page applications with live connectivity to Act-On using the CData API Server.

• How to Visualize Snapchat Ads Data in Python with pandas

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

• Extract, Transform, and Load SFTP in Informatica PowerCenter

  Create a simple Workflow for SFTP in Informatica PowerCenter.

• Automate Power BI XMLA Replication to SAP HANA

  Use CData Sync to customize and automate Power BI XMLA replication to SAP HANA.

• Publish Crystal Reports on Twitter

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Twitter.

• Use CData Connect Cloud to Access Vault CRM in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Veeva Vault & Vault CRM in the Power Pivot business intelligence tool.

• Consume Drip OData Feeds in PowerBuilder

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

• Connect to Unbounce from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Unbounce to connect to Unbounce from Web applications running on WebLogic.

• Connect to Real-Time SendGrid Data in Power Apps Using Dataflows to Build Custom Applications

• «
• 458
• 459
• 460
• 461
• 462
• 463
• 464
• 465
• 466
• 467
• »