CData Software - Knowledge Base

Recent Articles

• «
• 155
• 156
• 157
• 158
• 159
• 160
• 161
• 162
• 163
• 164
• »

• Build Dashboards with ClickUp in Dundas BI

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

• Publish Reckon Accounts Hosted-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Reckon Accounts Hosted.

• How to Query Live SFTP Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live SFTP data in natural language using Python.

• Query SAP Concur as a SQL Server Database in Node.js

  Execute SQL Server queries against SAP Concur from Node.js.

• Work with ConstantContact in FoxPro

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

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

  Use CData Power BI Connectors to visualize Basecamp in Power BI.

• Access Oracle from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Oracle Database from HeidiSQL.

• Integrate EventBrite in the Pentaho Report Designer

  Publish reports based on Eventbrite in the Pentaho BI tool.

• Feed Phoenix into FineReport

  How to set Apache Phoenix as a JDBC data source in FineReport.

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

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

• Manage JDBC-ODBC Bridge in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for JDBC-ODBC Bridge.

• Create Reports with Cvent in SAP Crystal Reports

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

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

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

• Extract, Transform, and Load REST in Informatica PowerCenter

  Create a simple Workflow for REST in Informatica PowerCenter.

• Access Live Redis in Google Sheets

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

• Visualize Box in Sisense

  Create an ElastiCube in Sisense app with access to Box.

• Use the CData Software ODBC Driver for SAP HANA XS Advanced in MicroStrategy Web

  Connect to SAP HANA XS Advanced in MicroStrategy Web using the CData Software ODBC Driver for SAP HANA XS Advanced.

• How to work with Amazon DynamoDB in Apache Spark using SQL

  Access and process Amazon DynamoDB in Apache Spark using the CData Software JDBC Driver.

• Automated Continuous LinkedIn Replication to SQLite

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

• Stream Microsoft Dataverse into Apache Kafka Topics

  Access and stream Microsoft Dataverse (CDS) in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Connect to Google Calendar from Asprova with CData Software ODBC Driver for Google Calendar

  This article shows how to connect faster to Google Calendar data from Asprova.

• Use the CData Software ODBC Driver for Oracle Eloqua in MicroStrategy

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

• Create a Data Access Object for Printful using JDBI

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

• Build Visualizations of Live Zenefits in Power BI (through CData Connect)

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

• DataBind Controls to Amazon Athena in Delphi

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

• Replicate Redis to Multiple Databases

  Replicate Redis to disparate databases with a single configuration.

• Build Office 365-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for Office 365 and create custom apps in Mendix.

• PowerShell Scripting to Replicate NetSuite to MySQL

  Write a simple PowerShell script to replicate NetSuite CRM & ERP to a MySQL database.

• Automated Continuous GraphQL Replication to Apache Cassandra

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

• Build Printful Visualizations in Tableau Cloud

  Use CData Software Connect Server to create a virtual SQL Server Database for Printful and build visualizations in Tableau Cloud.

• Connect to EventBrite in Jaspersoft Studio

  Execute SQL to remote Eventbrite in Jaspersoft Studio.

• How to create Google Calendar federated tables in MySQL

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

• Add SuiteCRM to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for SuiteCRM with the Informatica Enterprise Data Catalog to classify and organize data.

• Build a Simple VCL Application for XML

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

• Automated Continuous REST Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable REST replication to Google Cloud SQL.

• Using AngularJS to Build Dynamic Web Pages with Teradata

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

• Bridge Sage Cloud Accounting Connectivity with Apache NiFi

  Access and process Sage Business Cloud Accounting in Apache NiFi using the CData JDBC Driver.

• Automated Continuous Google Analytics Replication to Vertica

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

• Box Reporting and Star Schemas in OBIEE

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

• How to Access Live RSS Feeds in Power Automate Desktop via ODBC

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

• PowerShell Scripting to Replicate Kintone to MySQL

  Write a simple PowerShell script to replicate Kintone to a MySQL database.

• How to import Zoho Inventory into Apache Solr

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

• Automated Continuous Stripe Replication to SQLite

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

• Connect to Active Directory in JRuby

  Create a simple JRuby app with access to live Active Directory.

• How to connect to MarkLogic from Spring Boot

  Connect to MarkLogic in a Spring Boot Application using CData JDBC MarkLogic Driver

• Explore Geographical Relationships in Oracle SCM with Power Map

  Create data visualizations with Oracle SCM in Power Map.

• Integrate Shippo into Automated Tasks with Power Automate

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

• Create Dynamic Jira Assets Grids Using the Infragistics XamDataGrid

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

• How to Import Salesforce Pardot into SQL Server using SSIS

  Easily back up Salesforce Pardot to SQL Server using the SSIS components for Salesforce Pardot.

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

  Create an ODBC connection to WordPress in Informatica and browse and transfer WordPress.

• Create Reports from PostgreSQL in Looker Studio

  Use CData Connect Cloud to gain access to live PostgreSQL and create custom reports in Looker Studio.

• Add Wave Financial to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Wave Financial with the Informatica Enterprise Data Catalog to classify and organize data.

• How to create an RPA flow for eBay Analytics in UiPath Studio

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

• DataBind Controls to Bullhorn CRM in Delphi

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

• Replicate Microsoft Dataverse from PowerShell

  Write a quick PowerShell script to query Microsoft Dataverse (CDS). Use connectivity to the live data to replicate Microsoft Dataverse (CDS) to SQL Server.

• Create Gmail-Connected Enterprise Applications in OutSystems

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

• Design BIRT Reports on Zoho Inventory

  Provide current Zoho Inventory to your embedded analytics.

• Connect to Gmail from a Connection Pool in WebLogic

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

• Integrate Live Wave Financial into Custom Business Apps Built in Power Apps

  Use CData Software Connect Server to create a virtual SQL Server Database for Wave Financial and integrate live Wave Financial into apps built in Microsoft Power Apps.

• Natively Connect to SAP HANA in PHP

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

• Build Interactive Dashboards from SAP BusinessObjects BI in Amazon QuickSight

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

• How to pipe SAS xpt to CSV in PowerShell

  Use standard PowerShell cmdlets to access SAS xpt tables.

• Integrate Live Act-On into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Act-On from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Act-On.

• How to Use a Microsoft Access Database to Update Dynamics 365 Business Central in Real Time

  Update Dynamics 365 Business Central data by creating a linked table in Microsoft Access with the CData Dynamics 365 Business Central ODBC Driver.

• Analyze ADP in SAP Analytics Cloud

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

• Connect to Instagram in CloverDX (formerly CloverETL)

  Transfer Instagram using the visual workflow in the CloverDX data integration tool.

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

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

• Prepare, Blend, and Analyze Access in Alteryx Designer

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

• Automate Oracle Eloqua Replication to Couchbase

  Use CData Sync to Customize and automate Oracle Eloqua replication to Couchbase.

• Connect to Jira Service Management from a Connection Pool in Jetty

  The Jira Service Management JDBC Driver supports connection pooling: This article shows how to connect faster to Atlassian Jira Service Management from Web apps in Jetty.

• Use JayDeBeApi to access Gmail in Python

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• Create Data Visualizations in Cognos BI with Bing Ads

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

• Automated Continuous MongoDB Replication to PostgreSQL

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

• Connect to Harvest from PowerBuilder

  This article demonstrates how to access Harvest from PowerBuilder using the Harvest JDBC Driver.

• Build Automated Workflows with Live Oracle SCM in Workato

  Use CData Connect Cloud to connect to live Oracle SCM and build automated workflows in Workato.

• Analyze LinkedIn Ads in Infragistics Reveal

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

• Integrate Shopify in Your Informatica Cloud Instance

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

• Analyze QuickBooks with Power Pivot

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

• Excel Spreadsheet Automation with the QUERY Formula

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

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

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

• Create Salesloft-Connected Visualizations in Klipfolio

  Use CData Software Connect Server to connect to Salesloft from Klipfolio and build custom visualizations using live Salesloft.

• Use CData Connect Cloud to Access Oracle Sales in Microsoft Power Pivot

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

• Analyze Live MailChimp in SAS Viya

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

• Query Amazon DynamoDB in ColdFusion

  Write standard ColdFusion data access code to connect to Amazon DynamoDB.

• Create Reports from Cassandra in Looker Studio

  Use CData Connect Cloud to gain access to live Apache Cassandra and create custom reports in Looker Studio.

• How to connect to SAP HANA XS Advanced from IntelliJ

  Integrate connectivity to SAP HANA XS Advanced with wizards in IntelliJ.

• Use Biml to Build SSIS Tasks to Replicate Zoho CRM to SQL Server

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

• Use the CData Software JDBC Driver for Microsoft Teams in MicroStrategy Desktop

  Connect to Microsoft Teams in MicroStrategy Desktop using the CData Software JDBC Driver for Microsoft Teams.

• Automated Continuous Oracle Sales Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Oracle Sales replication to Apache Cassandra.

• Build an OLAP Cube in SSAS from EnterpriseDB

  Establish a connection to EnterpriseDB data from SQL Server Analysis Services, and use the EnterpriseDB Data Provider to build OLAP cubes for use in analytics and reporting.

• Visualize Live Zoho Projects in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Zoho Projects.

• Create Square-Connected Visualizations in Klipfolio

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

• Process & Analyze ADP in Databricks (AWS)

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

• How to import Gmail into Apache Solr

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

• Bidirectional Access to Sage 50 UK from FileMaker Pro

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

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

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

• Automated Continuous Oracle HCM Cloud Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Amazon S3.

• How to Access Sybase IQ Using Entity Framework

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

• How to integrate ShipStation with Apache Airflow

  Access and process ShipStation in Apache Airflow using the CData JDBC Driver.

• «
• 155
• 156
• 157
• 158
• 159
• 160
• 161
• 162
• 163
• 164
• »