CData Software - Knowledge Base

Recent Articles

• «
• 160
• 161
• 162
• 163
• 164
• 165
• 166
• 167
• 168
• 169
• »

• Visualize Bitbucket in TIBCO Spotfire through ADO.NET

  Integrate Bitbucket into dashboards in TIBCO Spotfire.

• Design BIRT Reports on Oracle

  Provide current Oracle Database to your embedded analytics.

• How to Build an ETL App for Epicor Kinetic in Python with CData

  Create ETL applications and real-time data pipelines for Epicor Kinetic in Python with petl.

• Query Azure Table as a MySQL Database in Node.js

  Execute MySQL queries against Azure Table Storage from Node.js.

• Use the CData ODBC Driver for Reckon in Microsoft Power Query

  You can use the CData Reckon ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Reckon into Microsoft Power Query.

• Connect to CockroachDB in NetBeans

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

• Extend Google Sheets with Databricks

  Make calls to the API Server from Google Apps Script.

• Import Reckon Accounts Hosted Using Azure Data Factory

  Use CData Connect Cloud to connect to Reckon Accounts Hosted from Azure Data Factory and import live Reckon Accounts Hosted.

• Automated Continuous LDAP Replication to Snowflake

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

• Query Zuora as a SQL Server Database in Node.js

  Execute SQL Server queries against Zuora from Node.js.

• Build Charts with Microsoft Planner in Clear Analytics

  Create dynamic charts and perform analytics based on Microsoft Planner in Clear Analytics.

• Add EnterpriseDB to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for EnterpriseDB with the Informatica Enterprise Data Catalog to classify and organize data.

• Create OneNote-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to OneNote from Klipfolio and build custom visualizations using live Microsoft OneNote.

• Use the CData ODBC Driver for Confluence in Microsoft Power Query

  You can use the CData Confluence ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Atlassian Confluence into Microsoft Power Query.

• Integrate DocuSign into Power Automate Desktop using CData Connect

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

• How to import LDAP Objects into Apache Solr

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

• Connect to Sage Cloud Accounting in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Sage Business Cloud Accounting in Airbyte.

• Visualize HubSpot in Tableau

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

• Integrate Twilio in the Pentaho Report Designer

  Publish reports based on Twilio in the Pentaho BI tool.

• Avalara AvaTax Reporting and Star Schemas in OBIEE

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

• Build Pipelines with Live Epicor Kinetic in Google Cloud Data Fusion (via CData Connect Cloud)

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

• Load Zuora to a Database Using Embulk

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

• Build Twitter Ads Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Twitter Ads and build visualizations in Tableau Cloud.

• How to work with Zoho Inventory in Apache Spark using SQL

  Access and process Zoho Inventory in Apache Spark using the CData Software JDBC Driver.

• Build Data Flows from Salesloft to SQL Server using SSIS

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

• How to connect to Blackbaud FE NXT from IntelliJ

  Integrate connectivity to Blackbaud FE NXT with wizards in IntelliJ.

• Excel Spreadsheet Automation on Snapchat Ads with the QUERY Formula

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

• How to Query Live Facebook in Claude Desktop

  Connect to and query live Facebook in Claude Desktop using the CData MCP Server.

• Using the CData Software ODBC Driver for Zuora in PyCharm

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

• Natively Connect to Microsoft Exchange in PHP

  The CData ODBC driver for Microsoft Exchange enables you to create PHP applications with connectivity to Microsoft Exchange. Leverage the native support for ODBC in PHP.

• Automated Continuous HCL Domino Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable HCL Domino replication to Microsoft Access.

• How to Work with HCL Domino in AWS Glue Jobs Using JDBC

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

• Use the CData Software ODBC Driver for Sugar CRM in MicroStrategy Web

  Connect to Sugar CRM in MicroStrategy Web using the CData Software ODBC Driver for Sugar CRM.

• Create Informatica Mappings From/To a JDBC Data Source for Google Campaign Manager 360

  Create Google Campaign Manager 360 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Connect to Azure Analysis Services from Excel & GoogleSheets!

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

• Publish Crystal Reports on Zuora

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

• Create Reports with Hive in SAP Crystal Reports

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

• Create Power BI Reports on Real-Time TaxJar

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

• Automate XML Replication to Azure Synapse

  Use CData Sync to customize and automate XML Files replication to Azure Synapse.

• Connect to Excel Online in Ruby

  Connect to Microsoft Excel Online in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Create SSAS Tabular Models from Drift

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

• Automated Continuous SQL Server Replication to Oracle

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

• Consume Amazon DynamoDB OData Feeds in SAP Lumira

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

• Integrate Live Zoho Inventory into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Zoho Inventory from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zoho Inventory.

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

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

• Replicate Multiple SAP Ariba Source Accounts via the CData Sync CLI

  Replicate multiple SAP Ariba Source accounts to one or many databases.

• Analyze DocuSign in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze DocuSign in Microsoft R Open.

• Create Google Sheets-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Google Sheets from OutSystems and build custom enterprise apps using live Google Sheets.

• Connect and Visualize Live Google Analytics Data in Databricks Lakehouse Federation with CData Connect Cloud

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

• Use Dash to Build to Web Apps on Microsoft Teams

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

• LINQ to DB2

  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 DB2 Data Provider.

• How to load SAP data into Elasticsearch via Logstash

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

• How to Build an ETL App for XML in Python with CData

  Create ETL applications and real-time data pipelines for XML Files in Python with petl.

• Connect to JotForm in RapidMiner

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

• Use the CData Software ODBC Driver for Cassandra in MicroStrategy

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

• Import Real-Time SAP Concur via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use SAP Concur in ColdFusion.

• Query, Visualize, and Share live SAP Hybris C4C in Redash

  Use CData Connect Cloud to connect to live SAP Hybris C4C in Redash for querying, visualizing, and sharing.

• Connect to Klaviyo in HULFT Integrate

  Connect to Klaviyo as a JDBC data source in HULFT Integrate

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

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

• Automate Google Analytics Replication to SAP HANA

  Use CData Sync to customize and automate Google Analytics replication to SAP HANA.

• Automated Continuous Aha Replication to PostgreSQL

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

• Integrate Real-Time Access to Google Directory in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Directory in real time.

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

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

• Design BIRT Reports on Coinbase

  Provide current Coinbase to your embedded analytics.

• Automated Continuous Azure Blob Storage Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Snowflake.

• Build Data Flows from Active Directory to SQL Server using SSIS

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

• Create Adobe Analytics-Connected Business Apps in AppSheet

  Connect to Adobe Analytics via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Adobe Analytics.

• Connect to Cosmos DB in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Use the CData Software ODBC Driver for Azure Active Directory in MicroStrategy Web

  Connect to Azure Active Directory in MicroStrategy Web using the CData Software ODBC Driver for Azure Active Directory.

• Process & Analyze MariaDB in Databricks (AWS)

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

• Connect to Google Analytics in RazorSQL

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

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

• Automated Continuous Klaviyo Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Klaviyo replication to IBM DB2.

• Build Google Contacts-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for Google Contacts and create custom apps in Bubble.

• How to Seamlessly Import SAP Ariba Source Data into IBM SPSS Modeler

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

• Write a Simple Go Application to work with Confluence on Linux

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

• Analyze PostgreSQL with Power Pivot

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

• Connect to Google Drive in Ruby

  Connect to Google Drive in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Use JayDeBeApi to access HubDB in Python

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

• Consume Neo4J OData Feeds in PowerBuilder

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

• Create Azure DevOps Dataflows on PowerBI.com

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

• Automated Continuous MYOB AccountRight Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Microsoft Access.

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

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

• Create SAP Ariba Source-Connected Dashboards in Grafana

  Connect to SAP Ariba Source via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to SAP Ariba Source.

• How to connect SharePoint with QuickBooks through external lists

  Provide QuickBooks Desktop to SharePoint users as an external list.

• Excel Spreadsheet Automation on HubSpot with the QUERY Formula

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

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

  Create an ODBC connection to Microsoft Teams in Informatica and browse and transfer Microsoft Teams.

• Building Dynamic Web Pages with Gmail Using AngularJS

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

• Build a PostgreSQL Interface for Adobe Analytics using the CData JDBC Driver

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

• Visualize Live Presto of Power BI Report Builder in Power BI Service

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

• Connect to Microsoft Teams in DBArtisan

  Use wizards in DBArtisan to configure Microsoft Teams as a data source.

• Integrate Live Zendesk into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Zendesk from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zendesk.

• How to Connect to & Open Impala in Microsoft Excel

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

• Automate LinkedIn Integration Tasks from PowerShell

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

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

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

• Query Adobe Analytics through ODBC in Node.js

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

• How to Query Live Authorize.Net in Claude Desktop

  Connect to and query live Authorize.Net in Claude Desktop using the CData MCP Server.

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

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

• Connect to Vault CRM from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Veeva Vault & Vault CRM using standard SQL.

• How to create Invoiced federated tables in MySQL

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

• «
• 160
• 161
• 162
• 163
• 164
• 165
• 166
• 167
• 168
• 169
• »