CData Software - Knowledge Base

Recent Articles

---

• «
• 918
• 919
• 920
• 921
• 922
• 923
• 924
• 925
• 926
• 927
• »

• Connect to Sage 300 Data in Ruby

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

• Query VWO Data through ODBC in Node.js

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

• Bidirectional Access to MYOB AccountRight Data from FileMaker Pro

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

• How to load FreeAgent data into Elasticsearch via Logstash

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

• Create SSAS Tabular Models from Salesforce CRM Analytics Data

  How to build a SQL Server Analysis Service Tabular Model from Salesforce CRM Analytics using CData drivers.

• Build a Simple VCL Application for Chargebee Data

  How to build a simple VCL Application to view Chargebee in RAD Studio using the CData ODBC Driver for Chargebee.

• Automated Continuous ClickTime Replication to Google BigQuery

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

• Connect to Shortcut Data in Aqua Data Studio

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

• Integrate with Webflow Data in JReport Designer

  Create charts and reports based on Webflow in JReport Designer.

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

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

• How to Use a Microsoft Access Database to Update Slack Data in Real Time

  Update Slack data by creating a linked table in Microsoft Access with the CData Slack ODBC Driver.

• Create Square-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to Square Data from OutSystems and build custom enterprise apps using live Square.

• Work with Live Google Drive Data in Power Query

  Use CData Connect AI to connect to Google Drive and work with live Google Drive in Microsoft Power Query.

• Visualize Jira Data in TIBCO Spotfire through ADO.NET

  Integrate Atlassian Jira into dashboards in TIBCO Spotfire.

• Operational Reporting on AgileCRM Data from Spotfire Server

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

• Connect to Everhour Data in JRuby

  Create a simple JRuby app with access to live Everhour.

• Import Real-Time DB2 Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use IBM DB2 in ColdFusion.

• Write a Simple Go Application to work with SAP Concur Data on Linux

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

• Connect to Nethunt Data in RazorSQL

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

• Connect to Slack Data through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with Slack Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Stream AgileCRM Data into Apache Kafka Topics

  Access and stream AgileCRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Getting Started with the CData SSIS Components for BigQuery

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for BigQuery.

• Getting Started with the CData Power BI Connector for PabblySubscriptions

  Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.

• How to Easily Query Epicor Kinetic Data in OpenOffice Base

  Connect to Epicor Kinetic data in OpenOffice Base using the CData ODBC Driver for Epicor Kinetic and generate reports with live data insights.

• How to use SQLAlchemy ORM to access Wistia Data in Python

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

• How to Visualize Gmail Data in Python with pandas via CData Connect AI

  Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Gmail in Python.

• How to Visualize Grafana Data in Python with pandas

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

• Connect to SAP Business Warehouse Data from PowerBuilder via JDBC

  This article demonstrates how to access SAP Business Warehouse from PowerBuilder using the SAP Business Warehouse JDBC Driver.

• Access Live IBM Informix Data in Emergent via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live IBM Informix through MCP integration.

• Connect to ZohoMarketingHub Data in RazorSQL

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

• Object-Relational Mapping (ORM) with LinkedIn 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 LinkedIn into a Java-based ORM framework, Hibernate.

• Create Informatica Mappings From/To an ODBC Data Source for Sybase

  Create an ODBC connection to Sybase in Informatica and browse and transfer Sybase.

• Connect to Rootly Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Rootly.

• Access Live LeadDesk Data in Coginiti Pro

  Connect to and query live LeadDesk from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Automate Microsoft Teams Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Microsoft Teams from PowerShell? This article demonstrates how to utilize the Microsoft Teams Cmdlets for tasks like connecting to Microsoft Teams, automating operations, downloading data, and more.

• Working with Freshdesk Data in LINQPad

  Execute LINQ queries to Freshdesk in LINQPad.

• Automated Continuous Pipeliner CRM Replication to Snowflake

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

• Getting Started with the CData Connect AI Python SDK for Slack

  Install the CData Connect AI Python SDK to read and write live Slack with standard DB-API 2.0 Python code.

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

  Provide connectivity to Jodoo through an SAP BusinessObjects universe.

• Integrate Timely Data in the Pentaho Report Designer

  Publish reports based on Timely in the Pentaho BI tool.

• Create Splunk Dataflows on PowerBI.com

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

• Work with Clio Data in FoxPro

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

• Automated Continuous WordPress Replication to Snowflake

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

• Replicate Adobe Analytics Data from PowerShell

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

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

  Use CData Power BI Connectors to visualize Apache Avro in Power BI.

• Build Bullhorn CRM-Connected Web Apps in Servoy

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

• Design BIRT Reports on Azure Analysis Services Data

  Provide current Azure Analysis Services to your embedded analytics.

• How to connect to Salesforce Marketing Data with Squirrel SQL client

  Connect to Salesforce Marketing Cloud and execute queries in the Squirrel SQL Client.

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Zoho CRM within intelligent workflows.

• Work with Act-On Data in FoxPro

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

• Manage MYOB AccountRight Data in DBArtisan as a JDBC Source

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

• Build Data Flows from LinkedIn Ads to SQL Server using SSIS

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

• Connect to and Query IBM Informix Data in QlikView over ODBC

  Create data visualizations with IBM Informix in QlikView.

• Analyze Sentry Data in R via JDBC

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

• Connect to SAP HANA Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP HANA.

• How to connect Amazon QuickSight to Salesforce Data

  Create a connection to Salesforce & Force.com in CData Connect AI and insert Salesforce & Force.com into Amazon QuickSight SPICE to build interactive dashboards.

• How to Seamlessly Import Supabase Data into IBM SPSS Modeler

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

• Build an OLAP Cube in SSAS from Zoho Recruit Data

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

• Use the CData Software ODBC Driver for IBM Cloud Object Storage in MicroStrategy Desktop

  Connect to IBM Cloud Object Storage in MicroStrategy Desktop using the CData Software ODBC Driver for IBM Cloud Object Storage.

• Connect to Short.io Data in HULFT Integrate

  Connect to Short.io as a JDBC data source in HULFT Integrate

• Automated Continuous OData Replication to Google BigQuery

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

• Replicate PolarTeamPro Data to Multiple Databases via the CData Sync CLI

  Replicate PolarTeamPro to disparate databases with a single configuration.

• Access Clio Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Clio from your Oracle system.

• dbt Cloud Transformations with CData Sync

  CData Sync supports integration with dbt Cloud, allowing users to develop, control, and run transformations in a supported destination database.

• Use Dash to Build to Web Apps on Azure Analysis Services Data

  Create Python applications that use pandas and Dash to build Azure Analysis Services-connected web apps.

• How to connect PolyBase to Parquet

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

• Using the CData Software ODBC Driver for SQL Server in PyCharm

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

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

  Provide connectivity to Zoho Projects through an SAP BusinessObjects universe.

• Use the CData Software JDBC Driver for Freshsales in MicroStrategy

  Connect to Freshsales in MicroStrategy Developer using the CData Software JDBC Driver for Freshsales.

• Working with Anaplan Data in LINQPad

  Execute LINQ queries to Anaplan in LINQPad.

• Work with Oracle Service Cloud Data in FoxPro

  Load Oracle Service Cloud into a FoxPro database. This article includes full code and a walk-through of the process.

• Access Live Dynamics 365 Data in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Microsoft Dynamics 365 from your Google Sheets.

• Use the CData Software ODBC Driver for CSV in MicroStrategy

  Connect to CSV/TSV Files in MicroStrategy Developer using the CData Software ODBC Driver for CSV.

• Connect Front Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

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

• Visualize Sentry Data in TIBCO Spotfire through ODBC

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

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

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

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

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

• Build a PostgreSQL Interface for SharePoint Excel Services Data using the CData JDBC Driver

  Use the Remoting features of the SharePoint Excel Services JDBC Driver to create a PostgreSQL entry-point for data access.

• Query Presto Data as a MySQL Database in Node.js

  Execute MySQL queries against Presto from Node.js.

• Moving Data from Missive to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live Missive data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

• Connect to NetSuite Data in RunMyProcess through Connect AI

  Use CData Connect AI to create on OData API for NetSuite Data and connect to NetSuite CRM & ERP in Akorbi Digital RunMyProcess.

• Connect SingleStore Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

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

• Visualize Live PivotalTracker Data of Power BI Report Builder in Power BI Service

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

• Integrate Kintone Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Kintone from Informatica Cloud.

• Connect to Humanity Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Humanity.

• How to connect PolyBase to ZohoMarketingHub

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

• Build Data Flows from SQL Server to SingleStore through SSIS

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

• Use the CData Software ODBC Driver for Dynamics NAV in MicroStrategy Web

  Connect to Microsoft Dynamics NAV in MicroStrategy Web using the CData Software ODBC Driver for Dynamics NAV.

• Connect to Twilio Data in RazorSQL

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

• Process & Analyze Spotify Data in Databricks (AWS)

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

• Visualize HubSpot Data in TIBCO Spotfire through ADO.NET

  Integrate HubSpot into dashboards in TIBCO Spotfire.

• Build Microsoft Ads-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to Microsoft Ads Data from Zoho Analytics and import live Microsoft Ads.

• Use the CData Software ODBC Driver for Act-On in MicroStrategy Web

  Connect to Act-On in MicroStrategy Web using the CData Software ODBC Driver for Act-On.

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

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

• Connect to Wrike from Asprova with CData Software ODBC Driver for Wrike

  This article shows how to connect faster to Wrike data from Asprova.

• Rapidly Develop Zoho Recruit-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 Zoho Recruit.

• Automated Continuous Google Tasks Replication to AlloyDB

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

• How to Query Live Sendwithus Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Sendwithus data in natural language using Python.

• Process & Analyze Amazon DynamoDB Data in Databricks (AWS)

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

• Automated Continuous Aha! Replication to PostgreSQL

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

• «
• 918
• 919
• 920
• 921
• 922
• 923
• 924
• 925
• 926
• 927
• »