CData Software - Knowledge Base

Recent Articles

• «
• 312
• 313
• 314
• 315
• 316
• 317
• 318
• 319
• 320
• 321
• »

• Build Charts with JotForm in Clear Analytics

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

• Use the CData Software JDBC Driver for QuickBooks Time in MicroStrategy

  Connect to QuickBooks Time in MicroStrategy Developer using the CData Software JDBC Driver for QuickBooks Time.

• Query Sage 300 as a MySQL Database in Node.js

  Execute MySQL queries against Sage 300 from Node.js.

• Integrate LDAP with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate LDAP with External Services.

• Use the CData Software ODBC Driver for Snowflake in MicroStrategy

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

• Connect to Zoho Inventory from Filemaker Pro (Mac)

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

• A PostgreSQL Interface for Pipedrive (MySQL Remoting via JDBC)

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

• Visualize xBase from Tableau

  Use the Tableau Desktop business intelligence tool to connect to xBase.

• Validate Microsoft Planner with QuerySurge

  Access and validate Microsoft Planner in QuerySurge using the CData JDBC Driver.

• Automated Continuous eBay Replication to Vertica

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

• Create Data Visualizations in Cognos BI with Snowflake

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

• Working with Google Sheets in LINQPad

  Execute LINQ queries to Google Sheets in LINQPad.

• Build Data Flows from SQL Server to Microsoft Dataverse through SSIS

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

• Teradata Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Teradata facts in real time.

• Connect to and Visualize Live Slack in Tableau Prep

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

• Connect to Monday.com as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Monday.com.

• Replicate Sage Intacct from PowerShell

  Write a quick PowerShell script to query Sage Intacct. Use connectivity to the live data to replicate Sage Intacct to SQL Server.

• A PostgreSQL Interface for Drip using the CData ODBC Driver

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

• Query SharePoint Excel Services in DataGrip

  Create a Data Source for SharePoint Excel Services in DataGrip and use SQL to query live SharePoint Excel Services.

• Natively Connect to Klipfolio in PHP

  The CData ODBC driver for Klipfolio enables you to create PHP applications with connectivity to Klipfolio. Leverage the native support for ODBC in PHP.

• How to connect to Splunk with Squirrel SQL client

  Connect to Splunk and execute queries in the Squirrel SQL Client.

• Visualize HubDB from Tableau

  Use the Tableau Desktop business intelligence tool to connect to HubDB.

• How to Build Dynamic React Apps with Office 365

  Use the CData Connect and React to Build Dynamic Web Apps with Live Office 365 .

• Connect to Instagram in Aqua Data Studio

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

• Automated Continuous OData Replication to Local Delimited Files

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

• Analyze Bullhorn CRM in Looker

  Use CData Connect Cloud to connect to Bullhorn CRM from Looker and build custom apps using live Bullhorn CRM.

• Automate Redshift Integration Tasks from PowerShell

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

• Integrate Invoiced in Your Informatica Cloud Instance

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

• Connect to MarkLogic as a Linked Server via SQL Gateway

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

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

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

• How to use SQLAlchemy ORM to access Cassandra in Python

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

• Query Veeva Vault in DataGrip

  Create a Data Source for Veeva Vault in DataGrip and use SQL to query live Veeva Vault & Vault CRM.

• Visualize Microsoft Teams in Tableau

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

• Visualize Live BigQuery in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Google BigQuery.

• Connect to CSV in CloverDX (formerly CloverETL)

  Transfer CSV/TSV Files using the visual workflow in the CloverDX data integration tool.

• Create Dashboards and Visualize Live Facebook Ads in Geckoboard

  Use CData Connect Cloud to connect to live Facebook Ads and create dashboards for real-time monitoring and visualization in Geckoboard.

• Access Zoho Projects in PHP through Connect Server

  Connect to Zoho Projects through the standard SQL Server libraries in PHP.

• Use Dash to Build to Web Apps on Klaviyo

  Create Python applications that use pandas and Dash to build Klaviyo-connected web apps.

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

  Provide connectivity to EnterpriseDB through an SAP BusinessObjects universe.

• Manage SAP Ariba Procurement in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for SAP Ariba Procurement.

• How to connect to Sage 200 from Spring Boot

  Connect to Sage 200 in a Spring Boot Application using CData JDBC Sage 200 Driver

• Manage SharePoint in DBArtisan as a JDBC Source

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

• Automated Continuous EnterpriseDB Replication to Microsoft Access

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

• Connect to and Visualize Live Airtable in Tableau Prep

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

• Query Raisers Edge NXT through ODBC in Node.js

  Use node-odbc to execute SQL queries against Raisers Edge NXT from Node.js.

• Create Cloudant-Connected Enterprise Applications in OutSystems

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

• Publish Crystal Reports on ADP

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

• Automated Continuous IBM Cloud Data Engine Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable IBM Cloud Data Engine replication to Microsoft Access.

• Build Jira Service Management-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Jira Service Management from Choreo and build custom apps using live Atlassian Jira Service Management.

• How to Build Dynamic React Apps with Authorize.Net

  Use the CData Connect and React to Build Dynamic Web Apps with Live Authorize.Net .

• Create Dashboards and Visualize Live Jira Service Management in Geckoboard

  Use CData Connect Cloud to connect to live Atlassian Jira Service Management and create dashboards for real-time monitoring and visualization in Geckoboard.

• Create Dynamic WordPress Grids Using the Infragistics XamDataGrid

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

• Build Zoho Inventory-Connected Apps in Choreo

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

• Automated Continuous Microsoft Teams Replication to Amazon Redshift

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

• A PostgreSQL Interface for Zoho Creator (MySQL Remoting via JDBC)

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

• Create CSV Reports on JasperReports Server

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

• Natively Connect to Google Contacts in PHP via ODBC (Linux)

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

• Build a Simple VCL Application for Basecamp

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

• Visualize SAP HANA XS Advanced in Tableau

  The CData ODBC driver for SAP HANA XS Advanced enables you integrate SAP HANA XS Advanced into Tableau dashboards.

• Use Dash to Build to Web Apps on Google Drive

  Create Python applications that use pandas and Dash to build Google Drive-connected web apps.

• How to connect to ConstantContact from Google Apps Script

  Use CData Software Connect Server to access ConstantContact in Google Apps Script.

• Provide OData Services of Cloudant from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for IBM Cloudant by developing a WCF Service Application.

• How to Visualize SAP BusinessObjects BI Data in Python with pandas

  Use pandas and other modules to analyze and visualize live SAP BusinessObjects BI in Python.

• Import SAS xpt into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for SAS xpt and create custom reports in the Power BI Service.

• Query Greenplum in DataGrip

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

• A PostgreSQL Interface for Twilio using the CData ODBC Driver

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

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

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

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

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

• Connect to Jira in HULFT Integrate

  Connect to Jira as a JDBC data source in HULFT Integrate

• How to connect to Highrise with Squirrel SQL client

  Connect to Highrise CRM and execute queries in the Squirrel SQL Client.

• Connect to Xero in DBArtisan

  Use wizards in DBArtisan to configure Xero Accounting as a data source.

• Automated Continuous IBM Informix Replication to Azure SQL

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

• Build Data Flows from SQL Server to Access through SSIS

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

• Excel Spreadsheet Automation on Salesforce Pardot with the QUERY Formula

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

• Access Live Elasticsearch in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Elasticsearch from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Create Microsoft Project-Connected Business Apps in AppSheet

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

• Automated Continuous JotForm Replication to MySQL

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

• Author and Share Power BI Reports on Real-Time Microsoft Exchange

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

• DataBind Controls to Tally in Delphi

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

• Build SAP BusinessObjects BI-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to SAP BusinessObjects BI and build web apps with connectivity to live SAP BusinessObjects BI.

• Create a Data Access Object for FHIR using JDBI

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

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

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

• Build Amazon Athena-Connected Visualizations in datapine

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

• How to integrate Dynamics NAV with Apache Airflow

  Access and process Microsoft Dynamics NAV in Apache Airflow using the CData JDBC Driver.

• Create IBM Informix Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for IBM Informix to build custom dashboards in Bold BI.

• How to connect PolyBase to Azure Synapse

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

• Connect to TigerGraph in Ruby

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

• How to Work with Dynamics 365 in ETL Validator JDBC

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

• Integrate with live LinkedIn in Jitterbit

  Use CData Connect Cloud to connect to and integrate live LinkedIn in Jitterbit.

• Import Printful into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for Printful and create custom reports in the Power BI Service.

• Integrate Office 365 into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Microsoft Office 365 and integrate live Microsoft Office 365 into your Power Automate tasks.

• Using AngularJS to Build Dynamic Web Pages with Basecamp

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

• Automated Continuous Typeform Replication to OneLake in Microsoft Fabric

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

• Use the CData Software JDBC Driver for Amazon Marketplace in MicroStrategy Web

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

• Edit and Search External Xero Objects in Salesforce Connect

  Use CData Connect Cloud to securely provide OData feeds of Xero Accounting to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Xero objects that you can access from apps and the dashboard.

• Replicate Multiple Wave Financial Accounts

  Replicate multiple Wave Financial accounts to one or many databases.

• Connect to SAP Business One from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live SAP Business One from Filemaker Pro on Mac.

• Build Apps with Live Google Contacts in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live Google Contacts into the Adalo platform and build custom mobile and web applications with real-time Google Contacts.

• Build NetSuite Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live NetSuite CRM & ERP and build visualizations in Tableau.

• Integrate with Azure Active Directory in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Azure Active Directory in SnapLogic.

• «
• 312
• 313
• 314
• 315
• 316
• 317
• 318
• 319
• 320
• 321
• »