CData Software - Knowledge Base

Recent Articles

• «
• 418
• 419
• 420
• 421
• 422
• 423
• 424
• 425
• 426
• 427
• »

• Create Datasets from Google Spanner in Domo Workbench and Build Visualizations of Google Spanner in Domo

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

• Load IBM Cloud Object Storage to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load IBM Cloud Object Storage to a database.

• Use the CData Software JDBC Driver for Amazon DynamoDB in MicroStrategy Desktop

  Connect to Amazon DynamoDB in MicroStrategy Desktop using the CData Software JDBC Driver for Amazon DynamoDB.

• Natively Connect to FTP in PHP via ODBC (Linux)

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

• Build Dashboards with Couchbase in Dundas BI

  Create dynamic dashboards and perform analytics based on Couchbase in Dundas BI.

• Integrate with LDAP Objects using Apache Camel2

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

• Create Azure DevOps-Connected Business Apps in AppSheet

  Connect to Azure DevOps via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Azure DevOps.

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

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

• Visualize Printify in Sisense

  Create an ElastiCube in Sisense app with access to Printify.

• How to Access Dynamics CRM Using Entity Framework

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

• Integrate Live Outreach.io into Amazon SageMaker Canvas with RDS

  Use CData Connect AI to connect to Outreach.io from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Outreach.io.

• Build Tableau CRM Analytics-Connected Web Apps with Axios and CData Connect AI

  Use CData Connect AI to connect to live Tableau CRM Analytics and build Tableau CRM Analytics-connected web apps with Axios.

• DataBind Charts to Sugar CRM

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

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed SAP BusinessObjects BI to Power BI dashboards. Simply drag and drop SAP BusinessObjects BI into data visuals on the Power BI canvas.

• Provide OData Services of IBM Cloud Object Storage from a WCF Application

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

• Getting Started with the CData SSIS Components for CSV

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

• Natively Connect to Todoist in PHP via ODBC (Linux)

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

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

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

• A PostgreSQL Interface for SharePoint using the CData ODBC Driver

  Use the SQL Gateway and SharePoint ODBC Driver to create a PostgreSQL entry-point for data access.

• Integrate Azure Synapse into Power Automate Desktop using CData Connect

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

• Integrating LangGraph with Dynamics 365 via CData Connect AI

  Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft Dynamics 365 within automated workflows.

• Access Microsoft Exchange from MySQL in Amazon QuickSight

  Connect to Microsoft Exchange and build visualizations of Microsoft Exchange using a MySQL Connection in Amazon QuickSight.

• Replicate CockroachDB to Multiple Databases via the CData Sync CLI

  Replicate CockroachDB to disparate databases with a single configuration.

• Connect to Marketo as an External Source in Dremio

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

• How to Access Twitter Ads Using Entity Framework

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

• Using the CData Software ODBC Driver for SAP BusinessObjects BI in PyCharm

  Connect to SAP BusinessObjects BI as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP BusinessObjects BI.

• How to Access SAP ByDesign Using Entity Framework

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

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

  Use CData Power BI Connectors to visualize Zoom in Power BI.

• Import Google Cloud Storage into Microsoft Power Query

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

• Use Biml to Build SSIS Tasks to Replicate Adobe Commerce to SQL Server

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

• Automated Continuous CockroachDB Replication to MySQL

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

• Integrate HarperDB with JetBrains RubyMine using CData JDBC Drivers

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

• Query JSON Services through ODBC in Node.js

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

• How to Connect to Live SQL Server from Claude Agent SDK (via CData Connect AI)

  Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Microsoft SQL Server for you.

• Automated Continuous GitHub Replication to MongoDB

  Use CData Sync for automated, continuous, customizable GitHub replication to MongoDB.

• Build a Simple VCL Application for Jira

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

• Create Reports with SharePoint Excel Services in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SharePoint Excel Services.

• Working with Paylocity in LINQPad

  Execute LINQ queries to Paylocity in LINQPad.

• Automate Typeform Integration Tasks from PowerShell

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

• Integrate SAP BusinessObjects BI into Power Automate Desktop using CData Connect

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

• Publish Basecamp-Connected Dashboards in Tableau Server via JDBC

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

• Automated Continuous Microsoft Exchange Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Google Cloud SQL.

• Automated Continuous Act CRM Replication to Databricks

  Use CData Sync for automated, continuous, customizable Act CRM replication to Databricks.

• Automated Continuous Paylocity Replication to PostgreSQL

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

• Connect to Sage Cloud Accounting 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 Sage Business Cloud Accounting.

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

• Create Reports from Oracle HCM Cloud in Looker Studio

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

• Access Sage Intacct from MySQL in Amazon QuickSight

  Connect to Sage Intacct and build visualizations of Sage Intacct using a MySQL Connection in Amazon QuickSight.

• Analyze Basecamp with Power Pivot

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

• Create SSAS Tabular Models from Azure Table

  How to build a SQL Server Analysis Service Tabular Model from Azure Table Storage using CData drivers.

• Access Live Active Directory in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Active Directory from your Excel spreadsheets.

• How to create Avro federated tables in MySQL

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

• Trigger Splunk IFTTT Flows in Azure App Service

  This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.

• Replicate Spark in Heroku for Use in Salesforce Connect

  Replicate Apache Spark SQL to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Connect and Visualize Live SharePoint Data in Databricks Lakehouse Federation with CData Connect AI

  Use CData Connect AI to integrate live Microsoft SharePoint into the Databricks platform and create visualization dashboards with real-time Microsoft SharePoint.

• Connect to Redis in JRuby

  Create a simple JRuby app with access to live Redis.

• Design BIRT Reports on Twitter

  Provide current Twitter to your embedded analytics.

• Automated Continuous Drip Replication to SQLite

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

• How to Access Live Odoo in Visual Studio Code via Cline

  Run the CData MCP Server for Odoo on Windows Subsytem for Linux (WSL) and connect to live Odoo ERP from the Cline extension in Visual Studio Code.

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

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

• How to Query Okta in MySQL Workbench

  Execute MySQL queries against live Okta from MySQL Workbench.

• Publish Reports with Oracle Financials Cloud in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Oracle Financials Cloud.

• Explore Geographical Relationships in MongoDB with Power Map

  Create data visualizations with MongoDB in Power Map.

• Process & Analyze Dynamics NAV in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Dynamics NAV .

• Create Microsoft Project-Connected Applications in Appsmith

  Connect to Microsoft Project via CData Connect AI in Appsmith and create custom business applications with real-time access to Microsoft Project.

• Create Zuora-Connected Nintex Workflows

  Use CData Connect AI to connect to Zuora from Nintex Workflow Cloud and build custom workflows using live Zuora.

• Connect and Visualize Live WooCommerce Data in Databricks Lakehouse Federation with CData Connect AI

  Use CData Connect AI to integrate live WooCommerce into the Databricks platform and create visualization dashboards with real-time WooCommerce.

• Visualize Live Tableau CRM Analytics in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live Tableau CRM Analytics into custom reports in Power BI.

• How to Connect to & Open OneNote in Microsoft Excel

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

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

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

• Access Live Blackbaud FE NXT in AWS Lambda (with IntelliJ IDEA)

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

• How to Connect the Power BI Service to Salesforce Marketing: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Natively Connect to Microsoft Exchange in PHP via ODBC (Linux)

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

• Consume Twilio OData Feeds in SAP Lumira

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

• Connect to Google Contacts in the Denodo Platform

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

• Build a Singer.io Tap for IBM Cloud Object Storage With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live IBM Cloud Object Storage data using

• Working with Certinia in LINQPad

  Execute LINQ queries to Certinia in LINQPad.

• Connecting Mastra with Amazon Athena via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.

• Use the CData SSIS Components to Insert New or Update Existing Hive Records from SQL Server

  Easily push SQL Server data to Hive using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Hive or update existing records with data from a SQL Server database.

• Use the CData Software ODBC Driver for HDFS in MicroStrategy

  Connect to Apache HDFS in MicroStrategy Developer using the CData Software ODBC Driver for HDFS.

• Visualize Live Bullhorn CRM in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Bullhorn CRM.

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

  Connect to Twilio from Excel 365 Online (Excel for the web) with CData Connect AI.

• Build Outreach.io-Connected Apps in Choreo

  Use CData Connect AI to connect to Outreach.io from Choreo and build custom apps using live Outreach.io.

• Automated Continuous HCL Domino Replication to SQL Server

  Use CData Sync for automated, continuous, customizable HCL Domino replication to SQL Server.

• Create Reports with Azure Table in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Azure Table Storage.

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live WordPress using the Model Context Protocol.

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

  Use CData Connect AI to connect to SendGrid and integrate live SendGrid into apps built in Microsoft Power Apps.

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

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

• Access Live Azure Data Lake Storage in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Azure Data Lake Storage from your Google Sheets.

• LINQ to Microsoft Project

  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 Microsoft Project Data Provider.

• Connect to Excel in SpagoBI

  Create reports featuring live Microsoft Excel in SpagoBI Studio. Host Excel reports on SpagoBI Server.

• Wave Financial Reporting in OBIEE with the Wave Financial JDBC Driver

  Deploy the Wave Financial JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Getting Started with the CData Excel Add-In for Zuora

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Zuora.

• How to integrate Metabase with Raisers Edge NXT

  Use CData Connect AI to connect to live Raisers Edge NXT and create an interactive dashboard in Metabase from Raisers Edge NXT.

• Getting Started with the CData SSIS Components for Google Analytics

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

• How to Seamlessly Import HarperDB Data into IBM SPSS Modeler

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

• Connect Quickbase to IBM WebSphere Using the CData JDBC Driver

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

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

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

• Connect and Visualize Live Salesforce Pardot Data in Databricks Lakehouse Federation with CData Connect AI

  Use CData Connect AI to integrate live Salesforce Pardot into the Databricks platform and create visualization dashboards with real-time Salesforce Pardot.

• Connect to Oracle in CloverDX (formerly CloverETL)

  Transfer Oracle Database using the visual workflow in the CloverDX data integration tool.

• «
• 418
• 419
• 420
• 421
• 422
• 423
• 424
• 425
• 426
• 427
• »