CData Software - Knowledge Base

Recent Articles

---

• «
• 421
• 422
• 423
• 424
• 425
• 426
• 427
• 428
• 429
• 430
• »

• Delighted Reporting and Star Schemas in OBIEE

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

• Automated Continuous Google Analytics Replication to SingleStore

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

• Automated Continuous REST Replication to SingleStore

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

• Provide OData Services of Office 365 Data from a WCF Application

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

• Replicate ClickTime Data in Heroku for Use in Salesforce Connect

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

• Create Dynamics 365 Business Central Reports on JasperReports Server

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

• Automated Continuous EnterpriseDB Replication to SingleStore

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

• Natively Connect to Slack Data in PHP via ODBC (Linux)

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

• Connect to Asana Data from Blazor Apps

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

• Use Biml to Build SSIS Tasks to Replicate Amazon Marketplace Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Amazon Marketplace to SQL Server.

• Replicate Teradata Data to Multiple Databases

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

• Query Mistral AI Data in ColdFusion

  Write standard ColdFusion data access code to connect to Mistral AI.

• Rapidly Develop SurveyMonkey-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by SurveyMonkey.

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

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

• Replicate Multiple Jumpseller Accounts via the CData Sync CLI

  Replicate multiple Jumpseller accounts to one or many databases.

• How to Connect to Clio Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Clio. Leverage the pyodbc module for ODBC in Python.

• How to import Sage Intacct Data into Apache Solr

  Use the CData Software JDBC Driver for Sage Intacct in Data Import Handler and create an automated import of Sage Intacct to Apache Solr Enterprise Search platform.

• Process & Analyze NetSuite Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live NetSuite Data.

• Work with Google Drive Data in FoxPro

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

• Connect to Close Data in the Denodo Platform

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

• DataBind CircleCI Data to the DevExpress Data Grid

  Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide CircleCI to a chart.

• How to load Toggl data into Elasticsearch via Logstash

  Introducing a simple method to load Toggl data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Integrate with JSON Services in JReport Designer

  Create charts and reports based on JSON in JReport Designer.

• Use Dash to Build to Web Apps on ClickTime Data

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

• Access Perigon Data from MySQL in PHP

  Connect to Perigon through the standard MySQL libraries in PHP.

• Access Live Float Data in AWS Lambda

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

• Use the CData Software ODBC Driver for Paymo in MicroStrategy Desktop

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

• Operational Reporting on SAP Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote SAP ERP/NetWeaver.

• Create JDBC-ODBC Bridge Reports on JasperReports Server

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

• Analyze FreeAgent Data in R via JDBC

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

• Automated Continuous GraphQL Replication to SingleStore

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

• Connect Auth0 to IBM WebSphere Using the CData JDBC Driver

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

• Build Data Flows from Clio to SQL Server using SSIS

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

• How to integrate Pipeliner CRM with Apache Airflow

  Access and process Pipeliner CRM in Apache Airflow using the CData JDBC Driver.

• Build Pipelines with Live WordPress Data in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to WordPress from Google Cloud Data Fusion, enabling the integration of live WordPress into the building and management of effective data pipelines.

• Use the CData ODBC Driver for Everhour from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Everhour to connect to Everhour from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Everhour in Excel.

• DataBind Controls to Freshdesk Data in C++Builder

  DataBind to Freshdesk in C++Builder with standard components and controls.

• Easily Integrate Adobe Commerce Data in Lazarus Pascal IDE

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

• Access Live Notion Data in AWS Lambda (with IntelliJ IDEA)

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

• How to Access ADP Data Using Entity Framework

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

• Connect to Adobe Experience Manager Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Getting Started with the CData Tableau Connector for Redis

  Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Redis.

• Build Sage Cloud Accounting-Powered Applications in GitHub Copilot with CData MCP Server

  Use the CData MCP Server for Sage Cloud Accounting to explore live Sage Cloud Accounting Data in GitHub Copilot to assist with building Sage Cloud Accounting-powered applications.

• Getting Started with the CData ADO.NET Provider for Customer.io

  Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.

• How to Connect DBeaver to Beeminder via a JDBC Driver

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

• Migrating data from Google Tasks to Databricks using CData SSIS Components.

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

• Bind Live Basecamp Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Basecamp data

• How to integrate BigQuery with Apache Airflow

  Access and process Google BigQuery in Apache Airflow using the CData JDBC Driver.

• Object-Relational Mapping (ORM) with Pipeliner CRM Data Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Pipeliner CRM into a Java-based ORM framework, Hibernate.

• How to create Visio diagrams from OneNote Data

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

• Visualize Live Float Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Float.

• Visualize PingOne Data in Sisense

  Create an ElastiCube in Sisense app with access to PingOne.

• DataBind Controls to Zoho Creator Data in C++Builder

  DataBind to Zoho Creator in C++Builder with standard components and controls.

• Automated Continuous Email Replication to Vertica

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

• Connect to Invoiced Data in Google Apps Script via SQL Gateway

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

• Provide OData Services of Hubstaff Data from a WCF Application

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

• Integrate Pipeline CRM Data in the Pentaho Report Designer

  Publish reports based on Pipeline CRM in the Pentaho BI tool.

• Integrate PDFMonkey with JetBrains RubyMine using CData JDBC Drivers

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

• Getting Started with the CData Python Connector for MessageBird

  Learn to install and license the CData Python Connector

• Connect to JotForm Data in Jaspersoft Studio

  Execute SQL to remote JotForm in Jaspersoft Studio.

• Visualize Snapchat Ads Data in Sisense

  Create an ElastiCube in Sisense app with access to Snapchat Ads.

• Integrate with Hive Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live Apache Hive in SnapLogic.

• Connect to EnterpriseDB Data from a Connection Pool in Jetty

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

• Build MailChimp-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live MailChimp.

• Replicate PagerDuty Data from PowerShell

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

• Rapidly Develop Power BI XMLA-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Power BI XMLA.

• Publish Cohere-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Cohere.

• Build MVC Applications with Connectivity to Clari Data

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

• Connect to CampaignMonitor Data in Aqua Data Studio

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

• Automated Continuous Google Cloud Storage Replication to SQLite

  Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to SQLite.

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

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

• How to create Egnyte federated tables in MySQL

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

• Create Datasets from Short.io in Domo Workbench and Build Visualizations of Short.io Data in Domo

  Use the CData Software ODBC Driver for Short.io to create datasets from Short.io in Domo Workbench and then build visualizations in the Domo service.

• Getting Started with the CData ODBC Driver for QuickBooks Time

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

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

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

• Bridge Figshare Connectivity with Apache NiFi

  Access and process Figshare in Apache NiFi using the CData JDBC Driver.

• Import and Visualize FreshBooks Data in Power View

  Create data visualizations based on FreshBooks in Excel.

• Integrating GitHub Copilot CLI with ZohoPeople via CData CLI

  CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.

• Query ZohoMarketingHub Data through ODBC in Node.js

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

• Bridge XML Connectivity with Apache NiFi

  Access and process XML Files in Apache NiFi using the CData JDBC Driver.

• Access Excel Data from MySQL in PHP

  Connect to Excel through the standard MySQL libraries in PHP.

• Connect to Telegram Data from PowerBuilder via JDBC

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

• Connect to Parallel Data in JRuby

  Create a simple JRuby app with access to live Parallel.

• Connect to Couchbase Data in RazorSQL

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

• Create Reports with Moosend Data in SAP Crystal Reports

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

• Access NetSuite Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access NetSuite CRM & ERP from your Oracle system.

• Automated Continuous HelloSign Replication to PostgreSQL

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

• Object-Relational Mapping (ORM) with Omnisend Data Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Omnisend into a Java-based ORM framework, Hibernate.

• Replicate Stripe Data in Heroku for Use in Salesforce Connect

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

• Consume NetSuite OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on NetSuite feeds that reflect any changes in SAP Lumira.

• Use Biml to Build SSIS Tasks to Replicate Elasticsearch Data to SQL Server

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

• Integrating Boomi Agentstudio with Square Data via CData Connect AI

  Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Square, enabling AI agents to act on live enterprise data within your integration and automation workflows.

• Automated Continuous Square Replication to MySQL

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

• Integrate Clari Data in the Pentaho Report Designer

  Publish reports based on Clari in the Pentaho BI tool.

• Getting Started with the CData Tableau Connector for Airtable

  Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Airtable.

• Rapidly Develop Access-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Access.

• Connect to and Query Google Contacts Data in QlikView over ODBC

  Create data visualizations with Google Contacts in QlikView.

• Integrate Live Notion Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Notion to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.

• Back Up Jumpseller to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Jumpseller data.

• How to Connect to ChartMogul Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to ChartMogul. Leverage the pyodbc module for ODBC in Python.

• «
• 421
• 422
• 423
• 424
• 425
• 426
• 427
• 428
• 429
• 430
• »