CData Software - Knowledge Base

Recent Articles

• «
• 148
• 149
• 150
• 151
• 152
• 153
• 154
• 155
• 156
• 157
• »

• Automated Continuous Elasticsearch Replication to Oracle

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

• Automate Google Ads Replication to Azure Synapse

  Use CData Sync to customize and automate Google Ads replication to Azure Synapse.

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

  Create ETL applications and real-time data pipelines for Atlassian Confluence in Python with petl.

• Access Jira Service Management in PHP through Connect Server

  Connect to Jira Service Management through the standard SQL Server libraries in PHP.

• Connect to Asana in as an External Source in Dremio

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

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

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

• Connect to SAS xpt from Asprova with CData Software ODBC Driver for SAS xpt

  This article shows how to connect faster to SAS xpt data from Asprova.

• Connect to LinkedIn Ads from AWS Glue

  Use CData Connect Cloud to gain access to live LinkedIn Ads from your AWS Glue jobs.

• Query Avalara AvaTax as a SQL Server in Node.js

  Execute SQL Server queries against Avalara AvaTax from Node.js.

• Use the CData ODBC Driver for ADP in SAS JMP

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

• Connect to xBase in Google Apps Script

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

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

  Provide connectivity to Facebook through an SAP BusinessObjects universe.

• Automated Continuous Google Directory Replication to IBM DB2

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

• Create Datasets from Sage Intacct in Domo Workbench and Build Visualizations of Sage Intacct in Domo

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

• Access Access as a Remote Oracle Database

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

• How to use SQLAlchemy ORM to access HubSpot in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of HubSpot.

• Google Directory Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Directory through CData Connect Cloud using different applications and tools.

• Use the CData Software ODBC Driver for SQL Analysis Services in MicroStrategy Desktop

  Connect to SQL Analysis Services in MicroStrategy Desktop using the CData Software ODBC Driver for SQL Analysis Services.

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

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

• How to create Jira Assets federated tables in MySQL

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

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

  Create an ODBC connection to Jira Assets in Informatica and browse and transfer Jira Assets.

• How to Access MailChimp Using Entity Framework

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

• Choosing the Best Method to Connect SAP Ariba Procurement to SQL Server: 5 Options Explained

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

• Analyze Confluence in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of Atlassian Confluence and visualize live Atlassian Confluence in Infragistics Reveal.

• Automated Continuous Zenefits Replication to Amazon S3

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

• Connect to SQL Analysis Services in RunMyProcess through Connect Server

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

• View Reports on Real-Time Avro in Power BI Report Server

  Use the CData ODBC Driver for Avro to visualize Apache Avro in Power BI Desktop and then publish them to Power BI Report Server.

• A PostgreSQL Interface for PayPal

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

• Feed Zoom into FineReport

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

• Connect to SAP Hybris C4C in Google Apps Script

  Use the ODBC Driver for SAP Hybris C4C and the SQL Gateway to access SAP Hybris C4C from Google Apps Script.

• Visualize Live Salesloft in the Power BI Service

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

• Connect to OneNote in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for OneNote and connect to Microsoft OneNote in Akorbi Digital RunMyProcess.

• Access PayPal from MySQL in Amazon QuickSight

  Connect to PayPal and build visualizations of PayPal using a MySQL Connection in Amazon QuickSight.

• Analyze Dynamics GP with Power Pivot

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

• Build Marketo-Connected Visualizations in datapine

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

• Working with ClickUp in LINQPad

  Execute LINQ queries to ClickUp in LINQPad.

• Publish Crystal Reports on Highrise

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

• DataBind Controls to Bullhorn CRM in C++Builder

  DataBind to Bullhorn CRM in C++Builder with standard components and controls.

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

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

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

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

• Sage 300 Reporting in OBIEE with the Sage 300 JDBC Driver

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

• DataBind SuiteCRM to the DevExpress Data Grid

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

• Automated Continuous SAS xpt Replication to Apache Cassandra

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

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

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

• Analyze QuickBooks Time in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of QuickBooks Time and visualize live QuickBooks Time in Infragistics Reveal.

• How to Access SFTP Using Entity Framework

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

• Publish ClickUp-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live ClickUp.

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

  Connect to Atlassian Jira from a connection pool in Tomcat.

• LINQ to Drift

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

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

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

• How to Connect DBeaver to Cloudant via a JDBC Driver

  Manage IBM Cloudant with visual tools in DBeaver like the query browser.

• DataBind Charts to eBay

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to eBay from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Create Data Visualizations Based On Twitter Ads in Mode

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

• Access Azure Data Lake Storage from MySQL in PHP

  Connect to Azure Data Lake Storage through the standard MySQL libraries in PHP.

• How to connect PolyBase to Drift

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Drift.

• Visualize XML in TIBCO Spotfire through OData

  Integrate XML Files into dashboards in TIBCO Spotfire.

• Build Interactive Dashboards from MarkLogic in Amazon QuickSight

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

• Connect to Blackbaud FE NXT from AWS Glue

  Use CData Connect Cloud to gain access to live Blackbaud FE NXT from your AWS Glue jobs.

• Analyze SAS xpt in Infragistics Reveal

  Use the CData Connect Server to create an OData API on top of SAS XPORT and visualize live SAS XPORT in Ingragistics Reveal.

• Automated Continuous Exact Online Replication to PostgreSQL

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

• How to connect Amazon QuickSight to Dynamics CRM

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

• Automated Continuous Avro Replication to SQLite

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

• Integrate with Dynamics 365 using Apache Camel2

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

• How to Connect to & Open Printify in Microsoft Excel

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

• Replicate Multiple Databricks Accounts

  Replicate multiple Databricks accounts to one or many databases.

• Access Live Amazon Marketplace in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for Amazon Marketplace to create a Amazon Marketplace source in TIBCO Data Virtualization Studio and gain access to live Amazon Marketplace from your TDV Server.

• Query Printful as a SQL Server in Node.js

  Execute SQL Server queries against Printful from Node.js.

• How to connect to Cosmos DB from IntelliJ

  Integrate connectivity to Azure Cosmos DB with wizards in IntelliJ.

• How to connect and process Instagram from Azure Databricks

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

• Build MVC Applications with Connectivity to Excel

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

• Build Google Campaign Manager 360-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Google Campaign Manager 360 from Choreo and build custom apps using live Google Campaign Manager 360.

• Automated Continuous eBay Replication to MySQL

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

• Access Live MongoDB in Excel (Desktop)

  Use CData Connect Cloud to gain access to live MongoDB from your Excel spreadsheets.

• Replicate Google Ad Manager from PowerShell

  Write a quick PowerShell script to query Google Ad Manager. Use connectivity to the live data to replicate Google Ad Manager to SQL Server.

• Integrate Live Dynamics 365 Business Central into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Dynamics 365 Business Central and integrate live Dynamics 365 Business Central into apps built in Microsoft Power Apps.

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

  Provide connectivity to Zoho Books through an SAP BusinessObjects universe.

• Use the CData ODBC Driver for Excel Online in Microsoft Power Query

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• Access Parquet from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Apache Parquet from HeidiSQL.

• Integrate ClickUp into Automated Tasks with Power Automate

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

• Replicate Multiple Zoho Projects Accounts

  Replicate multiple Zoho Projects accounts to one or many databases.

• Build a Simple VCL Application for HDFS

  How to build a simple VCL Application to view Apache HDFS in RAD Studio using the CData ODBC Driver for HDFS.

• Use CData Connect Cloud to Access Presto in Microsoft Power Pivot

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

• Integrating Elasticsearch in Talend Cloud Data Management Platform

• «
• 148
• 149
• 150
• 151
• 152
• 153
• 154
• 155
• 156
• 157
• »