CData Software - Knowledge Base

Recent Articles

• «
• 505
• 506
• 507
• 508
• 509
• 510
• 511
• 512
• 513
• 514
• »

• Use the CData Software ODBC Driver for Sage 200 in MicroStrategy

  Connect to Sage 200 in MicroStrategy Developer using the CData Software ODBC Driver for Sage 200.

• Build Kintone Visualizations in Tableau Cloud

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

• Import Sage Intacct into Microsoft Power Query

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

• Use the CData API Server to Access Salesforce Pardot in Microsoft PowerPivot

  Use the CData API Server to connect to live Salesforce Pardot in the Power Pivot business intelligence tool.

• Back Up Salesloft to SQL Server through SSIS

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

• Add RSS Feeds to Informatica Enterprise Data Catalog

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

• DataBind Controls to Act-On in Delphi

  DataBind to Act-On in Delphi with standard data access components and controls.

• Query HCL Domino in DataGrip

  Create a Data Source for HCL Domino in DataGrip and use SQL to query live HCL Domino.

• Seamlessly Bring Microsoft Teams into Retool Using CData Connect Cloud

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

• Manage Highrise in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Highrise.

• Replicate Reckon to Multiple Databases via the CData Sync CLI

  Replicate Reckon to disparate databases with a single configuration.

• Connect to Sugar CRM in DBeaver

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

• Using the CData Software ODBC Driver for Act-On in PyCharm

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

• Build Semantic Layer Views for Microsoft Project in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Project.

• Easily Integrate Google Sheets in Lazarus Pascal IDE

  Learn how to easily integrate live Google Sheets in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

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

  Connect to Active Directory from a connection pool in Tomcat.

• Natively Connect to SAP ByDesign in PHP via ODBC (Linux)

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

• Connect to Microsoft Planner in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Use the CData API Server to Access Clio in Microsoft PowerPivot

  Use the CData API Server to connect to live Clio in the Power Pivot business intelligence tool.

• Connect to Google Drive from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Google Drive from Crystal Reports.

• Query Sage 50 UK in ColdFusion

  Write standard ColdFusion data access code to connect to Sage 50 UK.

• Visualize SAP Netweaver Gateway in Tableau

  The CData ODBC driver for SAP Netweaver Gateway enables you integrate SAP Netweaver Gateway into Tableau dashboards.

• Build Dashboards with ClickUp in Dundas BI

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

• Automated Continuous Printify Replication to Apache Kafka

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

• Connect to Shopify from PowerBuilder via JDBC

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

• Visualize Sybase IQ in TIBCO Spotfire through OData

  Integrate Sybase IQ into dashboards in TIBCO Spotfire.

• Building Dynamic Web Pages with Google Calendar Using AngularJS

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

• ETL Azure Data Catalog in Oracle Data Integrator

  This article shows how to transfer Azure Data Catalog into a data warehouse using Oracle Data Integrator.

• Publish Crystal Reports on Sybase

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

• Connect to LinkedIn Ads from HeidiSQL

  Use CData Connect Cloud to connect to and query live LinkedIn Ads from HeidiSQL.

• Model Sage Cloud Accounting Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Sage Cloud Accounting, enabling the direct import of real-time Sage Business Cloud Accounting.

• Automated Continuous Salesloft Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Salesloft replication to SingleStore.

• Build MVC Applications with Connectivity to PingOne

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

• Use the CData API Server to Access Google Campaign Manager 360 in Microsoft PowerPivot

  Use the CData API Server to connect to live Google Campaign Manager 360 in the Power Pivot business intelligence tool.

• Replicate Multiple Outreach.io Accounts via the CData Sync CLI

  Replicate multiple Outreach.io accounts to one or many databases.

• Design BIRT Reports on Shippo

  Provide current Shippo to your embedded analytics.

• Connect to Xero 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 Xero Accounting.

• Explore Geographical Relationships in Oracle Financials Cloud with Power Map

  Create data visualizations with Oracle Financials Cloud in Power Map.

• Automate Tasks in Power Automate Using the CData API Server

  Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.

• Create SAP Business One Dataflows on PowerBI.com

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

• Access Coinbase 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 Coinbase.

• Build Data Flows from JSON to SQL Server using SSIS

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

• Connect to WooCommerce in Jaspersoft Studio

  Execute SQL to remote WooCommerce in Jaspersoft Studio.

• Automated Continuous MYOB AccountRight Replication to Google BigQuery

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

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

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

• Analyze Adobe Target with Power Pivot

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

• How to Connect DBeaver to Oracle Eloqua via a JDBC Driver

  Manage Oracle Eloqua with visual tools in DBeaver like the query browser.

• Back Up DocuSign to SQL Server through SSIS

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

• Automated Continuous Google Search Replication to PostgreSQL

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

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

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

• Automated Continuous Power BI XMLA Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Power BI XMLA replication to delimited files (CSV/TSV).

• Add Oracle to Informatica Enterprise Data Catalog

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

• Seamlessly Bring Elasticsearch into Retool Using CData Connect Cloud

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

• Connect to Salesforce Marketing in Ruby

  Connect to Salesforce Marketing Cloud in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Automated Continuous Microsoft Dataverse Replication to Apache Kafka

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

• Analyze Live Impala in SAS Viya

  Use CData Connect Cloud to connect to Apache Impala from SAS Viya and deploy self-service analytics using live Apache Impala.

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

  Use CData ODBC drivers to import and use Google Calendar in ColdFusion.

• Work with Live Oracle Eloqua in Power Query

  Use CData Connect Cloud to connect to Oracle Eloqua and work with live Oracle Eloqua in Microsoft Power Query.

• Import Real-Time YouTube Analytics via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use YouTube Analytics in ColdFusion.

• Rapidly Develop Calendly-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.

• Building Dynamic Web Pages with Cassandra Using AngularJS

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

• Import Avalara AvaTax into Microsoft Power Query

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

• Automated Continuous Procore Replication to Apache Cassandra

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

• Automated Continuous SAP ByDesign Replication to PostgreSQL

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

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

  Provide connectivity to Elasticsearch through an SAP BusinessObjects universe.

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

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

• How to Seamlessly Import SharePoint Data into IBM SPSS Modeler

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

• Import Dropbox into Microsoft Power Query

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

• How to Connect to Raisers Edge NXT in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Raisers Edge NXT. Leverage the pyodbc module for ODBC in Python.

• Integrate Real-Time Access to Avalara AvaTax in SAPUI5 MVC Apps

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

• Access Live Access in Coginiti Pro

  Connect to and query live Microsoft Access from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Create Power BI Reports on Real-Time Azure Synapse

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

• Feed TigerGraph into FineReport

  How to set TigerGraph as a JDBC data source in FineReport.

• Model, Search, and Visualize Live Confluence in ThoughtSpot

  Use CData Connect Cloud to connect to live Atlassian Confluence for modeling, searching, and visualizing.

• Use the CData API Server to Access Azure Data Lake Storage in Microsoft PowerPivot

  Use the CData API Server to connect to live Azure Data Lake Storage in the Power Pivot business intelligence tool.

• Visualize MYOB AccountRight in Tableau

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

• Connect to Google Directory from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Google Directory using standard SQL.

• Bidirectional Access to SAP Ariba Source from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate SAP Ariba Source in Filemaker Pro for Mac or Windows.

• Access Live Zoho Projects Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live Zoho Projects data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Connect to Google Calendar from a Connection Pool in JBoss

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

• How to Connect the Power BI Service to Sage 200: Complete Guide

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

• Trigger Azure Active Directory IFTTT Flows in Azure App Service

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

• Explore Geographical Relationships in Jira with Power Map

  Create data visualizations with Atlassian Jira in Power Map.

• 3 Ways to Integrate External Data Sources with FileMaker via CData ODBC Drivers

• How to import LinkedIn into Apache Solr

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

• Create Blackbaud FE NXT-Connected Dashboards in Grafana

  Connect to Blackbaud FE NXT via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Blackbaud FE NXT.

• How to Work with Reckon Accounts Hosted in AWS Glue Jobs Using JDBC

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

• Import and Visualize Jira Service Management in Power View

  Create data visualizations based on Atlassian Jira Service Management in Excel.

• Work with Email in FoxPro

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

• How to publish and share Excel dashboards with Tableau Server

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

• Replicate MYOB AccountRight in Heroku for Use in Salesforce Connect

  Replicate MYOB AccountRight to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Automated Continuous Dynamics 365 Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Microsoft Dynamics 365 replication to OneLake in Microsoft Fabric.

• Automated Continuous WooCommerce Replication to OneLake in Microsoft Fabric

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

• Build Semantic Layer Views for Excel in APOS Live Data Gateway

  Use the CData Connector for Excel in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Excel.

• Easily Integrate Raisers Edge NXT in Lazarus Pascal IDE

  Learn how to easily integrate live Raisers Edge NXT in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Analyze Sybase IQ in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Sybase IQ and visualize live Sybase IQ in Ingragistics Reveal.

• Create Datasets from BambooHR in Domo Workbench and Build Visualizations of BambooHR in Domo

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

• Connect to Live Cassandra in MicroStrategy through CData Connect Cloud

  Create a live connection to Cassandra in CData Connect Cloud and connect to your Apache Cassandra from MicroStrategy.

• Automate Microsoft Dataverse Integration Tasks from PowerShell

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

• Connect to Real-Time Quickbase Data in Power Apps Using Dataflows to Build Custom Applications

• «
• 505
• 506
• 507
• 508
• 509
• 510
• 511
• 512
• 513
• 514
• »