CData Software - Knowledge Base

Recent Articles

• «
• 523
• 524
• 525
• 526
• 527
• 528
• 529
• 530
• 531
• 532
• »

• How to connect SharePoint with Zoho Creator through external lists

  Provide Zoho Creator to SharePoint users as an external list.

• Automated Continuous Office 365 Replication to Snowflake

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

• Process & Analyze SAP SuccessFactors in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live SAP SuccessFactors .

• Back Up Jira Assets to SQL Server through SSIS

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

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

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

• Use Dash to Build to Web Apps on Monday.com

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

• Automated Continuous SAP HANA XS Advanced Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Microsoft Access.

• Build a Simple VCL Application for Excel Online

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

• Query BigQuery from Node.js

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

• Connect to LinkedIn as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live LinkedIn.

• Edit and Search Dynamics CRM External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of Microsoft Dynamics CRM to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Dynamics CRM objects that you can access from apps and the dashboard.

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

  Use LlamaIndex to query live Microsoft Dynamics 365 data in natural language using Python.

• Create Dynamic Jira Assets Grids Using the Infragistics XamDataGrid

  Learn how you can connect Jira Assets to Infragistics XamDataGrid to build dynamic grids.

• Connect to Live Twitter in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Twitter in CData Connect Cloud and connect to your Twitter from PostgreSQL.

• Consume REST OData Feeds in PowerBuilder

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

• How to Connect to Tally in Using Python: 6 Steps

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

• Build Data Flows from SQL Server to SharePoint Excel Services through SSIS

  Easily push SQL Server data to SharePoint Excel Services using the CData SSIS Tasks for SharePoint Excel Services.

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

  Provide connectivity to Adobe Target through an SAP BusinessObjects universe.

• How to create an RPA flow for QuickBooks Online in UiPath Studio

  Use the QuickBooks Online ODBC Driver to create workflows that access real-time QuickBooks Online without any coding.

• Integrate Google Drive in the Pentaho Report Designer

  Publish reports based on Google Drive in the Pentaho BI tool.

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

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

• Design BIRT Reports on GitHub

  Provide current GitHub to your embedded analytics.

• How to Access Dynamics NAV Using Entity Framework

  This article shows how to access Microsoft Dynamics NAV 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 Cosmos DB in PyCharm

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

• Integrate Marketo in Pentaho Data Integration

  Build ETL pipelines based on Marketo in the Pentaho Data Integration tool.

• Excel Spreadsheet Automation on Bitbucket with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Visualize Procore in Tableau

  The CData ODBC driver for Procore enables you integrate Procore into Tableau dashboards.

• Connect to Confluence from PowerBuilder via JDBC

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

• Build Charts with SAP Netweaver Gateway in Clear Analytics

  Create dynamic charts and perform analytics based on SAP Netweaver Gateway in Clear Analytics.

• Work with Live Sage Intacct in Power Query

  Use CData Connect Cloud to connect to Sage Intacct and work with live Sage Intacct in Microsoft Power Query.

• Use Claude to Talk to Your Azure DevOps via CData Connect Cloud

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

• Use the CData Software JDBC Driver for Microsoft Teams in MicroStrategy Web

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

• Automated Continuous Microsoft Project Replication to Databricks

  Use CData Sync for automated, continuous, customizable Microsoft Project replication to Databricks.

• Build Automated Sage Intacct-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Sage Intacct and build automated workflows in Zapier.

• Connect and Visualize Live Salesforce Marketing Data in Databricks Lakehouse Federation with CData Connect Cloud

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

• Connect to SendGrid in Aqua Data Studio

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

• Access Quickbase as a Remote Oracle Database

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

• Load Kintone to a Database Using Embulk

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

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

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

• Trigger MariaDB IFTTT Flows in Azure App Service

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

• Analyze Vault CRM in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Veeva Vault & Vault CRM and visualize live Veeva Vault & Vault CRM in Ingragistics Reveal.

• Building Dynamic Web Pages with Amazon Athena Using AngularJS

  Create single-page applications with live connectivity to Amazon Athena using the CData API Server.

• DataBind Controls to SAP Fieldglass in Delphi

  DataBind to SAP Fieldglass in Delphi with standard data access components and controls.

• Build Apps with Live MYOB AccountRight in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live MYOB AccountRight into the Adalo platform and build custom mobile and web applications with real-time MYOB AccountRight.

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

  Connect to Shopify from Excel 365 Online (Excel for the web) with CData Connect Cloud.

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

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

• Query Kintone through ODBC in Node.js

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

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

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

• Automated Continuous Zoho Creator Replication to Google BigQuery

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

• DataBind Charts to Adobe Commerce

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

• Analyze Excel Online in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Microsoft Excel Online and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

• Integrate Google Ads into Power Automate Desktop using CData Connect

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

• Replicate Multiple SAP Netweaver Gateway Accounts

  Replicate multiple SAP Netweaver Gateway accounts to one or many databases.

• How to Access SAP Netweaver Gateway Using Entity Framework

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

• Connect to and Query Paylocity in QlikView over ODBC

  Create data visualizations with Paylocity in QlikView.

• Create Outreach.io-Connected Nintex Workflows

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

• Create Informatica Mappings From/To a JDBC Data Source for Redshift

  Create Redshift data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Design BIRT Reports on Google Sheets

  Provide current Google Sheets to your embedded analytics.

• Connect to FTP from a Connection Pool in JBoss

  Integrate FTP Servers into Java servlets: Use the Management Console in JBoss to install the FTP JDBC Driver.

• Connect to ShipStation from PowerBuilder via JDBC

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

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

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

• Back Up Google Data Catalog to SQL Server through SSIS

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

• Extract, Transform, and Load Quickbase in Informatica PowerCenter

  Create a simple Workflow for Quickbase in Informatica PowerCenter.

• Prepare, Blend, and Analyze Google Spanner in Alteryx Designer (ODBC)

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

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

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

• Connect to and Visualize Live Shopify in Tableau Prep

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

• Analyze QuickBooks Time in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of QuickBooks Time and visualize live QuickBooks Time in Infragistics Reveal.

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

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

• Import Oracle HCM Cloud Using Azure Data Factory

  Use CData Connect Cloud to connect to Oracle HCM Cloud from Azure Data Factory and import live Oracle HCM Cloud.

• Visualize IBM Informix in TIBCO Spotfire through OData

  Integrate IBM Informix into dashboards in TIBCO Spotfire.

• Create Dynamic xBase Grids Using the Infragistics XamDataGrid

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

• Prepare, Blend, and Analyze Trello in Alteryx Designer (Connect Cloud)

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

• How to create Oracle federated tables in MySQL

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

• Use JayDeBeApi to access Dynamics 365 Business Central in Python

  Use standard Python scripting and the development environment of your choice to access live Dynamics 365 Business Central.

• Build a PostgreSQL Interface for Oracle Sales using the CData JDBC Driver

  Use the Remoting features of the Oracle Sales JDBC Driver to create a PostgreSQL entry-point for data access.

• Operational Reporting on PayPal from Spotfire Server

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

• How to connect to CSV from Spring Boot

  Connect to CSV in a Spring Boot Application using CData JDBC CSV Driver

• Connect to Phoenix from a Connection Pool in JBoss

  Integrate Apache Phoenix into Java servlets: Use the Management Console in JBoss to install the Phoenix JDBC Driver.

• Integrate CSV with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate CSV with External Services.

• Build Data Flows from EventBrite to SQL Server using SSIS

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

• Klaviyo Reporting and Star Schemas in OBIEE

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

• Publish Crystal Reports on JotForm

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

• Access Live Microsoft Exchange in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Microsoft Exchange into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Exchange in the Graph Builder and Query Builder.

• Automate Zoho Books Replication to Azure Data Lake

  Use CData Sync to customize and automate Zoho Books replication to Azure Data Lake.

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

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

• Build Adobe Commerce-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Adobe Commerce and build web apps with connectivity to live Adobe Commerce.

• Create Azure Table-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Azure Table from OutSystems and build custom enterprise apps using live Azure Table Storage.

• Connect to Cassandra in Google Apps Script via SQL Gateway

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

• Connect to and Query Zuora in QlikView over ODBC

  Create data visualizations with Zuora in QlikView.

• DataBind Charts to Slack

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

• Configure the CData JDBC Driver for Splunk in a Connection Pool in Tomcat

  Connect to Splunk from a connection pool in Tomcat.

• Use CData Connect Cloud to Access SAP Hybris C4C in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live SAP Hybris C4C in the Power Pivot business intelligence tool.

• Automated Continuous Kintone Replication to SQLite

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

• Build GraphQL-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live GraphQL.

• Connect to TaxJar in CloverDX (formerly CloverETL)

  Transfer TaxJar using the visual workflow in the CloverDX data integration tool.

• PowerShell Scripting to Replicate Microsoft OneDrive to MySQL

  Write a simple PowerShell script to replicate Microsoft OneDrive to a MySQL database.

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

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

• Visualize GraphQL from Tableau

  Use the Tableau Desktop business intelligence tool to connect to GraphQL.

• Create Data Visualizations Based On Google Sheets in Mode

  Use CData Connect Cloud to connect to Google Sheets from Mode and build visualizations using live

• Automated Continuous Oracle Service Cloud Replication to MySQL

  Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to MySQL.

• «
• 523
• 524
• 525
• 526
• 527
• 528
• 529
• 530
• 531
• 532
• »