CData Software - Knowledge Base

Recent Articles

• «
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• »

• Connect to Greenplum from Crystal Reports

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

• Use JayDeBeApi to access ShipStation in Python

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

• Build Microsoft Exchange Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Microsoft Exchange and build visualizations in Tableau Cloud.

• Connect to SAP Business One from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live SAP Business One from Filemaker Pro on Mac.

• How to connect and process GraphQL from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live GraphQL.

• Visualize DB2 in Tableau

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

• Create Authorize.Net Reports on JasperReports Server

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

• Create Dynamic Okta Grids Using the Infragistics XamDataGrid

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

• Extract, Transform, and Load JSON Services in Informatica PowerCenter

  Create a simple Workflow for JSON in Informatica PowerCenter.

• Connect to Cassandra from AWS Glue

  Use CData Connect Cloud to gain access to live Apache Cassandra from your AWS Glue jobs.

• Connect to Coinbase from PowerBuilder via ADO.NET

  This article demonstrates how to access Coinbase from Appeon PowerBuilder using the CData ADO.NET Provider for Coinbase.

• How to Create Power BI Visual Reports with Real-Time IBM Cloud Object Storage

  Use CData Power BI Connectors to visualize IBM Cloud Object Storage in Power BI.

• Replicate Greenplum to Multiple Databases

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

• Access Cvent as a Remote Oracle Database

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

• Connect to HBase in RapidMiner

  Integrate Apache HBase with standard components and data source configuration wizards in RapidMiner Studio.

• SAP Business One Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on SAP Business One facts in real time.

• Connect to Instagram in DBeaver

  Use the CData ODBC Driver to connect to Instagram in DBeaver.

• How to connect to Oracle HCM Cloud from IntelliJ

  Integrate connectivity to Oracle HCM Cloud with wizards in IntelliJ.

• Automated Continuous Instagram Replication to Apache Kafka

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

• Automate Aha Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Aha! and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Connect to Zendesk in HULFT Integrate

  Connect to Zendesk as a JDBC data source in HULFT Integrate

• A PostgreSQL Interface for Facebook Ads (MySQL Remoting via JDBC)

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

• Rapidly Develop Sybase IQ-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Access Couchbase in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Couchbase.

• How to import Adobe Commerce into Apache Solr

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

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

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

• Visualize Confluence in Sisense

  Create an ElastiCube in Sisense app with access to Atlassian Confluence.

• A PostgreSQL Interface for Facebook using the CData ODBC Driver

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

• Connect to GraphQL in HULFT Integrate

  Connect to GraphQL as a JDBC data source in HULFT Integrate

• Visualize SAS Data Sets in TIBCO Spotfire through ODBC

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

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

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

• Connect to SurveyMonkey in RapidMiner

  Integrate SurveyMonkey with standard components and data source configuration wizards in RapidMiner Studio.

• Work with Google Ad Manager in FoxPro

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

• Pipedrive Reporting in OBIEE with the Pipedrive JDBC Driver

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

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

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

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

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

• How to Use a Microsoft Access Database to Update Amazon Athena in Real Time

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

• A PostgreSQL Interface for Microsoft Planner using the CData ODBC Driver

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

• Load Shippo to a Database Using Embulk

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

• Query Smartsheet as a MySQL Database in Node.js

  Execute MySQL queries against Smartsheet from Node.js.

• Bridge WordPress Connectivity with Apache NiFi

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

• Build Data Flows from Sage 200 to SQL Server using SSIS

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

• How to create Amazon Athena federated tables in MySQL

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

• Visualize SAP SuccessFactors in TIBCO Spotfire through OData

  Integrate SAP SuccessFactors into dashboards in TIBCO Spotfire.

• Connect to SingleStore from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live SingleStore from Filemaker Pro on Mac.

• SAP Ariba Source Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on SAP Ariba Source facts in real time.

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

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

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

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

• Integrate Dynamics 365 into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Microsoft Dynamics 365 and integrate live Microsoft Dynamics 365 into your Power Automate tasks.

• Connect to Vault CRM in DBArtisan

  Use wizards in DBArtisan to configure Veeva Vault & Vault CRM as a data source.

• Query Sage 300 in DataGrip

  Create a Data Source for Sage 300 in DataGrip and use SQL to query live Sage 300.

• Use the CData API Server in Microsoft Power BI

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

• Analyze Monday.com in Slingshot with CData API Server

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

• Automated Continuous Certinia Replication to Azure SQL Database

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

• How to Access Live Exact Online in Visual Studio Code via Cline

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

• Access SAP Ariba Source as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP Ariba Source from your Oracle system.

• Connect to Printify in NetBeans

  Connect to Printify in NetBeans with the data source configuration wizard.

• Build Reckon-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Reckon from Zoho Analytics and import live Reckon.

• Connect to Office 365 in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Microsoft Office 365 in Google Apps Script.

• Automated Continuous Exact Online Replication to Microsoft Access

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

• Connect to Highrise in DBeaver

  Use the CData ODBC Driver to connect to Highrise CRM in DBeaver.

• Create SSAS Tabular Models from Google Calendar

  How to build a SQL Server Analysis Service Tabular Model from Google Calendar using CData drivers.

• Visualize Sybase in Sisense

  Create an ElastiCube in Sisense app with access to Sybase.

• Create Power BI Reports on Real-Time Facebook

  Use the CData ODBC Driver for Facebook to visualize Facebook in Power BI Desktop.

• Viewing Google Spanner in RAD Studio Data Explorer

  How to view Google Spanner in RAD Studio Data Explorer using the CData ODBC Driver for Google Spanner.

• Connect to Box in RapidMiner

  Integrate Box with standard components and data source configuration wizards in RapidMiner Studio.

• Integrate Avalara AvaTax into Power Automate Desktop using CData Connect

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

• Easily Build Angular2 Database Apps

  Use the API Server and Angular 2 to Build Dynamic Web Apps with Live Database Data.

• Automated Continuous SharePoint Excel Services Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to OneLake in Microsoft Fabric.

• Replicate Epicor Kinetic to Multiple Databases

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

• Connect to Cvent as an External Source in Dremio

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

• Create Dashboards and Visualize Live Asana in Geckoboard

  Use CData Connect Cloud to connect to live Asana and create dashboards for real-time monitoring and visualization in Geckoboard.

• Connect to Active Directory in Jaspersoft Studio

  Execute SQL to remote Active Directory in Jaspersoft Studio.

• Create Apps from Avalara AvaTax in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Avalara AvaTax and build apps from live Avalara AvaTax in Qlik Sense Cloud.

• Automated Continuous QuickBooks Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable QuickBooks replication to Amazon Redshift.

• Connect to Airtable from PowerBuilder via JDBC

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

• Connect to REST in DBArtisan

  Use wizards in DBArtisan to configure REST as a data source.

• Automate Redshift Replication to Azure Data Lake

  Use CData Sync to customize and automate Amazon Redshift replication to Azure Data Lake.

• DataBind Controls to Xero in Delphi

  DataBind to Xero Accounting in Delphi with standard data access components and controls.

• How to Access Jira Using Entity Framework

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

• How to connect and process Microsoft Dynamics NAV from Azure Databricks

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

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

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

• A PostgreSQL Interface for Salesforce Data Cloud using the CData ODBC Driver

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

• Visualize Live Monday.com of Power BI Report Builder in Power BI Service

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

• Access Live SharePoint in SAS JMP via ODBC

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

• Connect to Zoho Projects from Excel & GoogleSheets!

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

• Integrate HubSpot into Power Automate Desktop using CData Connect

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

• Build Visualizations of Bing Ads in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Bing Ads in Birst.

• How to Connect to & Open HubDB in Microsoft Excel

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

• Creating Active Directory-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Active Directory to Unqork and build custom business apps.

• Connect to Wave Financial from a Connection Pool in WebLogic

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

• Visualize Salesforce in TIBCO Spotfire through ODBC

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

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

  Connect to your Sage Business Cloud Accounting using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• How to Connect DBeaver to Instagram via a JDBC Driver

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

• Publish Crystal Reports on Microsoft Project

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

• Create Reports with Xero in SAP Crystal Reports

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Data Catalog

  Provide connectivity to Google Data Catalog through an SAP BusinessObjects universe.

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

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

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

  Provide connectivity to Eventbrite through an SAP BusinessObjects universe.

• How to Connect to Live Trello in n8n Workflows and Agents (via CData Connect Cloud)

  Leverage the CData Connect Cloud Remote MCP Server to enable n8n to securely read and take actions on your Trello for you.

• «
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• »