CData Software - Knowledge Base

Recent Articles

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

• Automated Continuous Zoho Projects Replication to SQLite

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

• How to Connect DBeaver to Printful via a JDBC Driver

  Manage Printful with visual tools in DBeaver like the query browser.

• Work with Live PostgreSQL in Power Query

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

• Build Charts with SAP Netweaver Gateway in Clear Analytics

  Create dynamic charts and perform analytics based on SAP Netweaver Gateway in Clear Analytics.

• A PostgreSQL Interface for Impala

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

• Connect to Google Campaign Manager 360 in JRuby

  Create a simple JRuby app with access to live Google Campaign Manager 360.

• Build Visualizations of Veeva in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Veeva Vault in Birst.

• How to Access Parquet Using Entity Framework

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

• Analyze Live OData Services in SAS Viya

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

• Connect to Azure Active Directory from AWS Glue

  Use CData Connect Cloud to gain access to live Azure Active Directory from your AWS Glue jobs.

• Connect to Zoho Creator from a Connection Pool in JBoss

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

• DataBind Controls to DocuSign in Delphi

  DataBind to DocuSign in Delphi with standard data access components and controls.

• Use the CData ODBC Driver for Facebook Ads in SAS JMP

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

• Create a Data Access Object for Microsoft Project using JDBI

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

• Natively Connect to Acumatica in PHP

  Create PHP applications on Linux/UNIX machines with connectivity to Acumatica ERP. Leverage the native support for ODBC in PHP.

• Import Amazon S3 into the Power BI Service for Visualizations

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

• How to Work with Bing Search Results in ETL Validator JDBC

  Connect to Bing Search from ETL Validator jobs using the CData Software JDBC Driver.

• Build ShipStation-Connected Apps in Choreo

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

• Build Charts with Marketo in Clear Analytics

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

• How to Connect to & Open TigerGraph in Microsoft Excel

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

• Replicate ActiveCampaign to Multiple Databases

  Replicate ActiveCampaign to disparate databases with a single configuration.

• Automated Continuous Google Calendar Replication to SQLite

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

• Automated Continuous HDFS Replication to Apache Kafka

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

• Automated Continuous Shippo Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Shippo replication to Amazon Redshift.

• Query Amazon DynamoDB through ODBC in Node.js

  Use node-odbc to execute SQL queries against Amazon DynamoDB from Node.js.

• Deploy the ADO.NET Provider for Power BI XMLA on an SSRS Report Server

  Connect to Power BI XMLA from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Automate Klaviyo Integration Tasks from PowerShell

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

• Connect to Microsoft Project in Google Apps Script

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

• Automated Continuous SAP Hybris C4C Replication to MySQL

  Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to MySQL.

• Connect to Gmail from a Connection Pool in JBoss

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

• Automated Continuous LinkedIn Ads Replication to SingleStore

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

• How to Use CData Connect to Access Live RSS Feeds in Power Automate

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

• Create IBM Cloud Object Storage-Connected Nintex Workflows

  Use CData Software Connect Server to connect to IBM Cloud Object Storage from Nintex Workflow Cloud and build custom workflows using live IBM Cloud Object Storage.

• Access Live Oracle SCM in TIBCO Data Virtualization

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

• Automated Continuous ServiceNow Replication to Oracle

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

• Connect to FHIR from Filemaker Pro (Mac)

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

• Visualize Basecamp in Tableau

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

• Integrate Azure Analysis Services into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Azure Analysis Services and integrate live Azure Analysis Services into your Power Automate tasks.

• Build Amazon Athena-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Amazon Athena from Choreo and build custom apps using live Amazon Athena.

• Create HubDB Dataflows on PowerBI.com

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

• Connect to SAS Data Sets from a Connection Pool in Jetty

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

• Access Live Zoho Projects in Google Sheets

  Use CData Connect Cloud to gain access to live Zoho Projects from your Google Sheets.

• Automate Google Calendar Replication to Azure Synapse

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

• Connect to ADP in Jaspersoft Studio

  Execute SQL to remote ADP in Jaspersoft Studio.

• Working with SAP Ariba Procurement in LINQPad

  Execute LINQ queries to SAP Ariba Procurement in LINQPad.

• Connect to Pinterest in HULFT Integrate

  Connect to Pinterest as a JDBC data source in HULFT Integrate

• Visualize Veeva in Tableau

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

• Automated Continuous MarkLogic Replication to Snowflake

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

• Use the CData Software ODBC Driver for DocuSign in MicroStrategy Desktop

  Connect to DocuSign in MicroStrategy Desktop using the CData Software ODBC Driver for DocuSign.

• Visualize MarkLogic in TIBCO Spotfire through ADO.NET

  Integrate MarkLogic into dashboards in TIBCO Spotfire.

• Integrate QuickBooks Time in the Pentaho Report Designer

  Publish reports based on QuickBooks Time in the Pentaho BI tool.

• Access Asana from MySQL in PHP

  Connect to Asana through the standard MySQL libraries in PHP.

• Access Access as a Remote Oracle Database

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

• Replicate Multiple QuickBooks Online Accounts

  Replicate multiple QuickBooks Online accounts to one or many databases.

• How to Work with Dynamics 365 in AWS Glue Jobs Using JDBC

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

• Visualize Live Sugar CRM in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Sugar CRM into custom reports in Power BI.

• How to connect Amazon QuickSight to Freshdesk

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

• Connect to Zoho Books in RazorSQL

  Connect to Zoho Books from wizards and query Zoho Books from the GUI in the RazorSQL database management tool.

• Create SSAS Tabular Models from Sage Cloud Accounting

  How to build a SQL Server Analysis Service Tabular Model from Sage Business Cloud Accounting using CData drivers.

• How to import Sage 50 UK into Apache Solr

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

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

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

• Automated Continuous IBM Informix Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable IBM Informix replication to AlloyDB.

• Process & Analyze SingleStore in Databricks (AWS)

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

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

  Provide connectivity to Stripe through an SAP BusinessObjects universe.

• Create Dropbox-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to Dropbox from AppSheet and build custom business apps using live Dropbox.

• SQL Gateway Overview

  A detailed overview of the SQL Gateway, its function, and its features.

• Automate IBM Informix Replication to Couchbase

  Use CData Sync to Customize and automate IBM Informix replication to Couchbase.

• Integrate with live Jira Service Management in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Atlassian Jira Service Management in Jitterbit.

• Prepare, Blend, and Analyze Bitbucket in Alteryx Designer

  Build workflows to access live Bitbucket for self-service data analytics.

• DataBind Charts to Phoenix

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache Phoenix 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.

• Build Charts with OneNote in Clear Analytics

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

• Automated Continuous ActiveCampaign Replication to Apache Kafka

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

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

  Connect to Microsoft OneDrive from a connection pool in Tomcat.

• Access Live Google Search Results in AWS Lambda (with IntelliJ IDEA)

  Connect to live Google Search in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• How to Work with Zendesk in ETL Validator JDBC

  Connect to Zendesk from ETL Validator jobs using the CData Software JDBC Driver.

• Automated Continuous YouTube Analytics Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Azure SQL.

• Connect to and Visualize Live Procore in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Procore.

• Integrate with Hive in JReport Designer

  Create charts and reports based on Apache Hive in JReport Designer.

• Use JayDeBeApi to access Sugar CRM in Python

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

• Access Azure Data Lake Storage as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Azure Data Lake Storage from your Oracle system.

• Automated Continuous QuickBooks Time Replication to Microsoft Access

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

• Build a Simple VCL Application for Act CRM

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

• Create Reports with Salesforce in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Salesforce & Force.com.

• Use the CData Software ODBC Driver for SAS Data Sets in MicroStrategy Web

  Connect to SAS Data Sets in MicroStrategy Web using the CData Software ODBC Driver for SAS Data Sets.

• How to use SQLAlchemy ORM to access SharePoint in Python

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

• Working with Drip in LINQPad

  Execute LINQ queries to Drip in LINQPad.

• Replicate Multiple Tally Accounts

  Replicate multiple Tally accounts to one or many databases.

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

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

• Create MYOB AccountRight-Connected Business Apps in AppSheet

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

• Explore Geographical Relationships in LinkedIn Ads with Power Map

  Create data visualizations with LinkedIn Ads in Power Map.

• Access Live Google Calendar in Google Sheets

  Use CData Connect Cloud to gain access to live Google Calendar from your Google Sheets.

• How to create an RPA flow for Google Contacts in UiPath Studio

  Use the Google Contacts ODBC Driver to create workflows that access real-time Google Contacts without any coding.

• Connect to Google Directory in Google Apps Script

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

• Automated Continuous Cloudant Replication to Local Delimited Files

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

• Query ShipStation in ColdFusion

  Write standard ColdFusion data access code to connect to ShipStation.

• Connect to SAP Netweaver Gateway in NetBeans

  Connect to SAP Netweaver Gateway in NetBeans with the data source configuration wizard.

• Connect to Microsoft Teams in CloverDX (formerly CloverETL)

  Transfer Microsoft Teams using the visual workflow in the CloverDX data integration tool.

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

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

• Connect to Redshift as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Amazon Redshift.

• How to connect to Slack in DBVisualizer

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

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