CData Software - Knowledge Base

Recent Articles

• «
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• »

• Connect to Zoom in DBArtisan

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

• Connect to AlloyDB in Jaspersoft Studio

  Execute SQL to remote Google AlloyDB in Jaspersoft Studio.

• SQL Gateway: Superior SQL Linked Server Integration through SQL TDS

  Using a TDS remoting service is superior to the OLE DB Provider when working with ODBC data in SQL Server.

• Automated Continuous Act CRM Replication to SQLite

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

• Import Hive Using Azure Data Factory

  Use CData Connect Cloud to connect to Hive from Azure Data Factory and import live Apache Hive.

• Automated Continuous Microsoft Teams Replication to MySQL

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

• Build MVC Applications with Connectivity to Dynamics NAV

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

• Analyze Sage 300 with Power Pivot

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

• How to work with Google Calendar in Apache Spark using SQL

  Access and process Google Calendar in Apache Spark using the CData Software JDBC Driver.

• Analyze Microsoft Project in Cognos Analytics

  Use CData Connect Cloud to connect to Microsoft Project from Cognos Analytics and analyze live Microsoft Project.

• Connect to Google Drive in RapidMiner

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

• Create a Data Access Object for Square using JDBI

  A brief overview of creating a SQL Object API for Square in JDBI.

• Automated Continuous Aha Replication to Amazon S3

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

• Use Biml to Build SSIS Tasks to Replicate DocuSign to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate DocuSign to SQL Server.

• Build Visualizations of Live Reckon Accounts Hosted in Power BI (through CData Connect)

  Use CData Connect to create a virtual database for Reckon Accounts Hosted and build custom reports in Power BI.

• Integrate Shopify into Power Automate Desktop using CData Connect

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

• Use CData Connect Cloud to Access Salesforce Pardot in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Salesforce Pardot in the Power Pivot business intelligence tool.

• Feed Exact Online into FineReport

  How to set Exact Online as a JDBC data source in FineReport.

• Automated Continuous Sage 200 Replication to Apache Cassandra

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

• Build Active Directory-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Active Directory from Choreo and build custom apps using live Active Directory.

• Build Dashboards with Trello in Dundas BI

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

• Author and Share Power BI Reports on Real-Time Twilio

  Use the CData ODBC Driver for Twilio to visualize Twilio in Power BI Desktop and then upload to the Power BI service.

• How to connect to Facebook Ads in DBVisualizer

  Integrate Facebook Ads with visual data analysis tools and data connection wizards in DBVisualizer

• Create Data Visualizations in Cognos BI with Microsoft OneDrive

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

• Bidirectional Access to Google Campaign Manager 360 from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Google Campaign Manager 360 in Filemaker Pro for Mac or Windows.

• DataBind EventBrite to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for EventBrite with the DevExpress Windows Forms and Web controls to provide Eventbrite to a chart.

• Connect to eBay Analytics from a Connection Pool in Jetty

  The eBay Analytics JDBC Driver supports connection pooling: This article shows how to connect faster to eBay Analytics from Web apps in Jetty.

• Establish a Live Connection with Confluence using Tableau Bridge

  The CData ODBC Driver for Confluence enables you to integrate live Atlassian Confluence into Tableau Cloud dashboards using the Tableau Bridge.

• Enable the AlloyDB JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Google AlloyDB.

• Creating Twitter Ads-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Twitter Ads to Unqork and build custom business apps.

• Create Reports with Google Cloud Storage in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Google Cloud Storage.

• A PostgreSQL Interface for Confluence

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

• How to connect to Blackbaud FE NXT in DBVisualizer

  Integrate Blackbaud FE NXT with visual data analysis tools and data connection wizards in DBVisualizer

• How to connect to SAS xpt with Squirrel SQL client

  Connect to SAS XPORT and execute queries in the Squirrel SQL Client.

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

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

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

• How to Query ActiveCampaign in MySQL Workbench

  Execute MySQL queries against live ActiveCampaign from MySQL Workbench.

• Connect to Veeva as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Veeva Vault.

• Connect to Calendly in Ruby

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

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

  Use CData Power BI Connectors to visualize Aha! in Power BI.

• Analyze Zoho Projects in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Zoho Projects and visualize Zoho Projects in SAP Analytics Cloud.

• How to connect Amazon QuickSight to Microsoft Project

  Create a connection to Microsoft Project in CData Connect Cloud and insert Microsoft Project into Amazon QuickSight SPICE to build interactive dashboards.

• Connect to ClickUp in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for ClickUp and connect to ClickUp in Akorbi Digital RunMyProcess.

• Visualize MariaDB in TIBCO Spotfire through ADO.NET

  Integrate MariaDB into dashboards in TIBCO Spotfire.

• How to Create Power BI Visual Reports with Real-Time Azure Active Directory

  Use CData Power BI Connectors to visualize Azure Active Directory in Power BI.

• A PostgreSQL Interface for Slack

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

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

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

• Connect to SAP Fieldglass in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for SAP Fieldglass and connect to SAP Fieldglass in Akorbi Digital RunMyProcess.

• Automate ClickUp Replication to Azure Synapse

  Use CData Sync to customize and automate ClickUp replication to Azure Synapse.

• Create Data Visualizations in Cognos BI with Parquet

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

• Using the CData Software ODBC Driver for RSS in PyCharm

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

• Query Greenplum in DataGrip

  Create a Data Source for Greenplum in DataGrip and use SQL to query live Pivotal GreenPlum.

• Automated Continuous Exact Online Replication to MongoDB

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

• Automate Reckon Accounts Hosted Integration Tasks from PowerShell

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

• Visualize Twitter Ads in TIBCO Spotfire through ODBC

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

• Automated Continuous Asana Replication to SQL Server

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

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

  Connect to TigerGraph from a connection pool in Tomcat.

• Back Up Tally ERP to SQL Server through SSIS

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

• Visualize Dynamics 365 in TIBCO Spotfire through ADO.NET

  Integrate Microsoft Dynamics 365 into dashboards in TIBCO Spotfire.

• Automated Continuous SharePoint Replication to Oracle

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

• Build Interactive Dashboards from Salesloft in Amazon QuickSight

  Create a virtual SQL Server database for Salesloft in CData Software Connect Server and import Salesloft into Amazon QuickSight SPICE to build interactive dashboards.

• Query Airtable in MySQL Workbench

  Create a virtual MySQL database for Airtable in CData Software Connect (or Connect Server) and work with live Airtable in MySQL Workbench.

• Automated Continuous Excel Online Replication to SQL Server

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

• Automated Continuous Klipfolio Replication to SingleStore

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

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

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

• Automated Continuous Klaviyo Replication to IBM DB2

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

• Back Up Azure Cosmos DB to SQL Server through SSIS

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

• Create MongoDB-Connected Enterprise Applications in OutSystems

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

• How to Work with Act-On in AWS Glue Jobs Using JDBC

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

• Create Dynamic Epicor Kinetic Grids Using the Infragistics XamDataGrid

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

• Query CouchDB as a MySQL Database in Node.js

  Execute MySQL queries against Apache CouchDB from Node.js.

• Use the CData ODBC Driver for BigCommerce in SAS JMP

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

• Query GraphQL in ColdFusion

  Write standard ColdFusion data access code to connect to GraphQL.

• LINQ to SingleStore

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

• Integrate Sage 50 UK in the Pentaho Report Designer

  Publish reports based on Sage 50 UK in the Pentaho BI tool.

• Automated Continuous Basecamp Replication to Local Delimited Files

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

• How to connect to Calendly in DBVisualizer

  Integrate Calendly with visual data analysis tools and data connection wizards in DBVisualizer

• Import Confluence into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Confluence and provide access to live Atlassian Confluence for custom reports in the Power BI Service.

• Automated Continuous Splunk Replication to Apache Kafka

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

• Query Asana in ColdFusion

  Write standard ColdFusion data access code to connect to Asana.

• Replicate Multiple Jira Service Management Accounts

  Replicate multiple Jira Service Management accounts to one or many databases.

• Manage Access in DBArtisan as a JDBC Source

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

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

  Provide connectivity to Workday through an SAP BusinessObjects universe.

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

  Create ETL applications and real-time data pipelines for Zoho Books in Python with petl.

• How to connect PolyBase to IBM Cloud Data Engine

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live IBM Cloud Data Engine.

• Build Interactive Dashboards from Google Ad Manager in Amazon QuickSight

  Create a virtual SQL Server database for Google Ad Manager in CData Software Connect Server and import Google Ad Manager into Amazon QuickSight SPICE to build interactive dashboards.

• Create Datasets from Authorize.Net in Domo Workbench and Build Visualizations of Authorize.Net in Domo

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

• Use the CData ODBC Driver for Amazon Marketplace from SharePoint Excel Services

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

• Visualize Zoho CRM in TIBCO Spotfire through OData

  Integrate Zoho CRM into dashboards in TIBCO Spotfire.

• How to Create Power BI Visual Reports with Real-Time Outreach.io

  Use CData Power BI Connectors to visualize Outreach.io in Power BI.

• How to connect Amazon QuickSight to Asana

  Create a connection to Asana in CData Connect Cloud and insert Asana into Amazon QuickSight SPICE to build interactive dashboards.

• Integrate MailChimp in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MailChimp from Informatica Cloud.

• Integrate with Live Microsoft Planner in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Microsoft Planner from the MuleSoft Anypoint Platform to integrate live Microsoft Planner into custom reports and dashboards.

• Visualize Dynamics CRM in Sisense

  Create an ElastiCube in Sisense app with access to Microsoft Dynamics CRM.

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

  Provide connectivity to Asana through an SAP BusinessObjects universe.

• Automated Continuous QuickBooks Replication to Snowflake

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

• Connect to Oracle Financials Cloud as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Oracle Financials Cloud.

• Connect to Dynamics GP from PowerBuilder

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

• Connect to Confluence in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Atlassian Confluence in the Denodo Virtual DataPort Administrator.

• Integrate with HCL Domino using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy HCL Domino to a JSON file on disk.

• «
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• »