CData Software - Knowledge Base

Recent Articles

• «
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• »

• Bidirectional Access to Shippo from FileMaker Pro

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

• Connect to Elasticsearch from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Elasticsearch to connect to Elasticsearch from Web applications running on WebLogic.

• Connect to SAP Business One in RazorSQL

  Connect to SAP Business One from wizards and query SAP Business One from the GUI in the RazorSQL database management tool.

• How to Connect DBeaver to SuiteCRM via a JDBC Driver

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

• How to create SAP Ariba Procurement federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP Ariba Procurement in MySQL .

• A PostgreSQL Interface for SendGrid

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

• Use the CData ODBC Driver for SAP Concur in Microsoft Power Query

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

• Connect to PayPal in HULFT Integrate

  Connect to PayPal as a JDBC data source in HULFT Integrate

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

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

• Automated Continuous Sage Cloud Accounting Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to MongoDB.

• Export Data from SQL Server to Elasticsearch through SSIS

  Easily push SQL Server data to Elasticsearch using the CData SSIS Tasks for Elasticsearch.

• Build Semantic Layer Views for Facebook Ads in APOS Live Data Gateway

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

• Connect to Neo4J in Jaspersoft Studio

  Execute SQL to remote Neo4J in Jaspersoft Studio.

• Perform Batch Operations with SAS Data Sets in Apache NiFi

  Connect to SAS Data Sets and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Connect to Amazon Marketplace from Asprova with CData Software ODBC Driver for Amazon Marketplace

  This article shows how to connect faster to Amazon Marketplace data from Asprova.

• Manage Phoenix in DBArtisan as a JDBC Source

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

• Enable the Sage 50 UK JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Sage 50 UK.

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

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

• Connect to Smartsheet from a Connection Pool in JBoss

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

• Automated Continuous SAP Business One Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable SAP Business One replication to Amazon S3.

• Connect to Monday.com in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Monday.com in Airbyte.

• Create AlloyDB-Connected Visualizations in Klipfolio

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

• Build BambooHR-Connected Dashboards in Redash

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

• Automated Continuous LDAP Replication to Amazon S3

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

• Use the CData Software JDBC Driver for Wave Financial in MicroStrategy Desktop

  Connect to Wave Financial in MicroStrategy Desktop using the CData Software JDBC Driver for Wave Financial.

• Build MVC Applications with Connectivity to QuickBooks

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• Use the CData Software ODBC Driver for FHIR in MicroStrategy

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

• Integrate with Oracle in JReport Designer

  Create charts and reports based on Oracle Database in JReport Designer.

• Design BIRT Reports on Certinia

  Provide current Certinia to your embedded analytics.

• Connect to Square from AWS Glue

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

• How to connect to Zoho Books from IntelliJ

  Integrate connectivity to Zoho Books with wizards in IntelliJ.

• Connect to DB2 as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for IBM DB2.

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

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

• Bidirectional Access to Quickbase from FileMaker Pro

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

• Access Pipedrive from MySQL in Amazon QuickSight

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

• Connect to SFTP from Blazor Apps

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

• Visualize Live Bing Ads in the Power BI Service

  Use CData Connect Cloud to connect to live Bing Ads and create custom reports in the Power BI Service through the On-Premises Gateway.

• Author and Share Power BI Reports on Real-Time Azure Table

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

• Publish Crystal Reports on Snapchat Ads

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

• Connect to SQL Analysis Services in HULFT Integrate

  Connect to SQL Analysis Services as a JDBC data source in HULFT Integrate

• Access Live SAP Netweaver Gateway in Coginiti Pro

  Connect to and query live SAP Netweaver Gateway from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Use JayDeBeApi to access MarkLogic in Python

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

• Connect to Veeva in DBeaver

  Use the CData ODBC Driver to connect to Veeva Vault in DBeaver.

• Connect to Twitter Ads in Ruby

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

• DataBind Controls to Microsoft Teams in Delphi

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

• Using AngularJS to Build Dynamic Web Pages with Facebook

  Use the CData Connect Server to create Facebook OData feeds and build single-page applications with live Facebook.

• How to Work with Avalara AvaTax in AWS Glue Jobs Using JDBC

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

• Automate Excel Online Integration Tasks from PowerShell

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

• Create Apps from FTP in Qlik Sense Cloud

  Use the CData Connect Server to create an OData API for FTP Servers and build apps from live FTP Servers in Qlik Sense Cloud.

• Process & Analyze Sage Cloud Accounting in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Sage Cloud Accounting .

• Creating xBase-Connected Applications in Unqork

  You can use CData Connect to feed xBase to Unqork and build custom business apps.

• DataBind Controls to Impala in Delphi

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

• Build Charts with JSON Services in Clear Analytics

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

• Replicate Microsoft Dataverse for Use in Salesforce Connect

  Replicate Microsoft Dataverse (CDS) to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Use the CData Software JDBC Driver for Tally in MicroStrategy

  Connect to Tally ERP in MicroStrategy Developer using the CData Software JDBC Driver for Tally.

• Build Charts with QuickBooks Online in Clear Analytics

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

• Build Visualizations of Typeform in Birst

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

• How to Connect DBeaver to Google Ads via a JDBC Driver

  Manage Google Ads with visual tools in DBeaver like the query browser.

• Integrate with Azure Active Directory using Apache Camel2

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

• Automate xBase Replication to Azure Data Lake

  Use CData Sync to customize and automate xBase replication to Azure Data Lake.

• How to create EventBrite federated tables in MySQL

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

• Connect to MailChimp in NetBeans

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

• Access Live SurveyMonkey in AWS Lambda

  Connect to live SurveyMonkey in AWS Lambda using the CData JDBC Driver.

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

• Access Procore from MySQL in Amazon QuickSight

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

• Creating Salesforce Marketing-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Salesforce Marketing Cloud to Unqork and build custom business apps.

• Connect to Microsoft Project from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Microsoft Project from Crystal Reports.

• Integrate Real-Time Access to Drift in SAPUI5 MVC Apps

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

• Build Exact Online Visualizations in Tableau Desktop

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

• Build Charts with HubSpot in Clear Analytics

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

• Create a Data Access Object for Jira Service Management using JDBI

  A brief overview of creating a SQL Object API for Atlassian Jira Service Management in JDBI.

• Integrate with SQL Server using Apache Camel2

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

• Validate Greenhouse with QuerySurge

  Access and validate Greenhouse in QuerySurge using the CData JDBC Driver.

• Publish Crystal Reports on WooCommerce

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

• Connect to Oracle Service Cloud in CloverDX (formerly CloverETL)

  Transfer Oracle Service Cloud using the visual workflow in the CloverDX data integration tool.

• Access Microsoft Dataverse from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Dataverse (CDS) from HeidiSQL.

• Manage Google Contacts in DBArtisan as a JDBC Source

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

• Connect to Microsoft Planner in Aqua Data Studio

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

• How to import Azure Synapse into Apache Solr

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

• How to create Raisers Edge NXT federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Raisers Edge NXT in MySQL .

• Visualize Google Cloud Storage from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Google Cloud Storage.

• Build Pipelines with Live Active Directory in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Active Directory from Google Cloud Data Fusion, enabling the integration of live Active Directory into the building and management of effective data pipelines.

• How to Connect to & Open SQL Server in Microsoft Excel

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

• Access Bing Ads in PHP through Connect Server

  Connect to Bing Ads through the standard SQL Server libraries in PHP.

• How to Query IBM Cloud Object Storage in MySQL Workbench

  Execute MySQL queries against live IBM Cloud Object Storage from MySQL Workbench.

• Automated Continuous MYOB AccountRight Replication to Azure SQL

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

• Automated Continuous SAP ByDesign Replication to SQL Server

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

• Query Asana in MySQL Workbench

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

• Publish Reports with BigCommerce in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date BigCommerce.

• Visualize AlloyDB in TIBCO Spotfire through ODBC

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

• Access Harvest from MySQL in PHP

  Connect to Harvest through the standard MySQL libraries in PHP.

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

  Provide connectivity to Zoho Projects through an SAP BusinessObjects universe.

• Natively Connect to HCL Domino in PHP

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

• Automated Continuous Printify Replication to PostgreSQL

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

• Visualize CockroachDB in Tableau

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

• Create SSAS Tabular Models from Calendly

  How to build a SQL Server Analysis Service Tabular Model from Calendly using CData drivers.

• Create Drift Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Drift data access from reports, embedded analytics, and more.

• Connect to Monday.com from Asprova with CData Software ODBC Driver for Monday.com

  This article shows how to connect faster to Monday.com data from Asprova.

• Work with LinkedIn Ads in FoxPro

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

• «
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• »