CData Software - Knowledge Base

Recent Articles

• «
• 81
• 82
• 83
• 84
• 85
• 86
• 87
• 88
• 89
• 90
• »

• Replicate Multiple Sage 200 Accounts via the CData Sync CLI

  Replicate multiple Sage 200 accounts to one or many databases.

• Access Xero as a Remote Oracle Database

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

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

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

• Automated Continuous Amazon S3 Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Amazon S3 replication to OneLake in Microsoft Fabric.

• Visualize Live Invoiced in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Invoiced.

• Connect to Oracle Sales from Filemaker Pro (Mac)

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

• How to import TaxJar into Apache Solr

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Trello

  Provide connectivity to Trello through an SAP BusinessObjects universe.

• Create a Private/Public Key Pair with Certificate Generator

  Information on how to use the Certificate Generator application to create public and private keypairs.

• Connect to Drift in JRuby

  Create a simple JRuby app with access to live Drift.

• Publish Sugar CRM-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Sugar CRM.

• Publish Sage 200-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Sage 200.

• Connect to Microsoft OneDrive in Aqua Data Studio

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

• Automated Continuous SAP ByDesign Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Microsoft Access.

• Build MVC Applications with Connectivity to Klipfolio

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Klipfolio from an ASP.NET MVC application.

• Integrate with ShipStation in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live ShipStation in SnapLogic.

• Create Data Visualizations in Cognos BI with PingOne

  Access PingOne as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Build eBay-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live eBay.

• Build Drip-Connected Dashboards in Redash

  Use CData Software Connect Server to create a virtual SQL Server Database for Drip and build visualizations and dashbaords from Drip in Redash.

• Automated Continuous Reckon Replication to Snowflake

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

• Integrate Klipfolio into Automated Tasks with Power Automate

  Use CData Software Connect Server to create a virtual SQL Server database for Klipfolio and integrate live Klipfolio into your Power Automate (Microsoft Flow) tasks.

• Build Dashboards with Act-On in DBxtra

  Create dynamic dashboards and perform analytics based on Act-On in DBxtra.

• DataBind Controls to SAP BusinessObjects BI in C++Builder

  DataBind to SAP BusinessObjects BI in C++Builder with standard components and controls.

• Connect to and Visualize Live Raisers Edge NXT in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Raisers Edge NXT.

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

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

• Build Google Drive Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Google Drive and build visualizations in Tableau.

• Connect to Google Contacts in Google Apps Script via SQL Gateway

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

• Feed Zoho Books into FineReport

  How to set Zoho Books as a JDBC data source in FineReport.

• Analyze LinkedIn Ads with Power Pivot

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

• How to connect to PingOne from IntelliJ

  Integrate connectivity to PingOne with wizards in IntelliJ.

• Enable the Adobe Commerce JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Adobe Commerce.

• Create Reports from SAP Business One in Looker Studio

  Use CData Connect Cloud to gain access to live SAP Business One and create custom reports in Looker Studio.

• Replicate Adobe Analytics from PowerShell

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

• Connect to Shopify in CloverDX (formerly CloverETL)

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

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

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

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

  Use CData JDBC drivers to import and use JDBC-ODBC Bridge in ColdFusion.

• How to connect to Power BI XMLA from Spring Boot

  Connect to Power BI XMLA in a Spring Boot Application using CData JDBC Power BI XMLA Driver

• How to Visualize HubSpot Data in Python with pandas

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

• Create Data Visualizations Based On HubSpot in Mode

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

• Query Google Search Results through ODBC in Node.js

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

• Connect and Visualize Live Microsoft Teams Data in Databricks Lakehouse Federation with CData Connect Cloud

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

• Create Reports from Snowflake in Looker Studio

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for SuiteCRM

  Provide connectivity to SuiteCRM through an SAP BusinessObjects universe.

• Visualize Live Highrise in the Power BI Service

  Use CData Software Connect Server to create a virtual SQL Server database for Highrise CRM and create custom reports in the Power BI Service.

• Load HCL Domino to a Database Using Embulk

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

• Seamlessly Bring Jira Service Management into Retool Using CData Connect Cloud

  Integrate Jira Service Management data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

• How to connect to Zoho Books with Squirrel SQL client

  Connect to Zoho Books and execute queries in the Squirrel SQL Client.

• Excel Spreadsheet Automation on Zuora with the QUERY Formula

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

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

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

• Automated Continuous Google Calendar Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Google Calendar replication to Apache Cassandra.

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

  Connect to Microsoft Project from a connection pool in Tomcat.

• Analyze ShipStation in R via JDBC

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

• Extract, Transform, and Load IBM Informix in Informatica PowerCenter

  Create a simple Workflow for IBM Informix in Informatica PowerCenter.

• Connect to Email in HULFT Integrate

  Connect to Email as a JDBC data source in HULFT Integrate

• Create API-Connected Visualizations in Klipfolio

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

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

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

• Connect to Redis in NetBeans

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

• Build Data Flows from Salesforce Data Cloud to SQL Server using SSIS

  Easily back up Salesforce Data Cloud to SQL Server using the SSIS components for Salesforce Data Cloud.

• Automated Continuous MYOB AccountRight Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Google Cloud SQL.

• Automated Continuous Aha Replication to Microsoft Access

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

• Create PCA Sales-Connected Applications in Appsmith

  Connect to PCA Sales via CData Connect Cloud in Appsmith and create custom business applications with real-time access to PCA Sales.

• Automated Continuous Slack Replication to MySQL

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

• How to Easily Query YouTube Analytics in OpenOffice Base

• «
• 81
• 82
• 83
• 84
• 85
• 86
• 87
• 88
• 89
• 90
• »