CData Software - Knowledge Base

Recent Articles

• «
• 309
• 310
• 311
• 312
• 313
• 314
• 315
• 316
• 317
• 318
• »

• Model ShipStation Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and ShipStation, enabling the direct import of real-time ShipStation.

• Use Biml to Build SSIS Tasks to Replicate Google Directory to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Directory to SQL Server.

• How to Query Live Azure Active Directory Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Azure Active Directory data in natural language using Python.

• Analyze SAP SuccessFactors in Looker

  Use CData Connect Cloud to connect to SAP SuccessFactors from Looker and build custom apps using live SAP SuccessFactors.

• Use the CData ODBC Driver for Okta in SAS JMP

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

• Build Presto-Connected Visualizations in datapine

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

• Replicate OneNote to Multiple Databases

  Replicate Microsoft OneNote to disparate databases with a single configuration.

• Connect to BambooHR in JRuby

  Create a simple JRuby app with access to live BambooHR.

• SendGrid Reporting and Star Schemas in OBIEE

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

• Connect to Snapchat Ads in Google Apps Script

  Use CData Connect Cloud to access Snapchat Ads in Google Apps Script.

• How to create QuickBooks Time federated tables in MySQL

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

• Using the CData Software ODBC Driver for Instagram in PyCharm

  Connect to Instagram as an ODBC data source in PyCharm using the CData Software ODBC Driver for Instagram.

• Integrate LinkedIn in Your Informatica Cloud Instance

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

• Import Dynamics CRM Using Azure Data Factory

  Use CData Connect Cloud to connect to Dynamics CRM from Azure Data Factory and import live Microsoft Dynamics CRM.

• How to connect to Okta from IntelliJ

  Integrate connectivity to Okta with wizards in IntelliJ.

• How to connect to SAP Ariba Source in DBVisualizer

  Integrate SAP Ariba Source with visual data analysis tools and data connection wizards in DBVisualizer

• Connect to Microsoft Dataverse from AWS Glue

  Use CData Connect Cloud to gain access to live Microsoft Dataverse (CDS) from your AWS Glue jobs.

• How to Connect to Dynamics 365 in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Microsoft Dynamics 365. Leverage the pyodbc module for ODBC in Python.

• Create SSAS Tabular Models from Jira

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

• Explore Geographical Relationships in Box with Power Map

  Create data visualizations with Box in Power Map.

• Automate Salesloft Replication to Azure Data Lake

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

• Connect to Hive in DBeaver

  Use the CData ODBC Driver to connect to Apache Hive in DBeaver.

• Add Authorize.Net to Informatica Enterprise Data Catalog

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

• Use the CData Software JDBC Driver for Trello in MicroStrategy Desktop

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

• How to Connect to Teradata in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Teradata. Leverage the pyodbc module for ODBC in Python.

• Access Avro in PHP through Connect Server

  Connect to Avro through the standard SQL Server libraries in PHP.

• Use the CData Software ODBC Driver for Google Search in MicroStrategy Web

  Connect to Google Search in MicroStrategy Web using the CData Software ODBC Driver for Google Search.

• Create Reports with QuickBooks in SAP Crystal Reports

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

• Automated Authorize.Net Replication to Teradata

  Use CData Sync to Customize and automate Authorize.Net replication to Teradata.

• Connect to IBM Cloud Data Engine in DBArtisan

  Use wizards in DBArtisan to configure IBM Cloud Data Engine as a data source.

• Automated Snowflake Replication to Teradata

  Use CData Sync to Customize and automate Snowflake replication to Teradata.

• Replicate SharePoint Excel Services to Multiple Databases

  Replicate SharePoint Excel Services to disparate databases with a single configuration.

• DataBind Controls to SAP SuccessFactors in Delphi

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

• Connect to Google Calendar in RazorSQL

  Connect to Google Calendar from wizards and query Google Calendar from the GUI in the RazorSQL database management tool.

• Feed Power BI XMLA into FineReport

  How to set Power BI XMLA as a JDBC data source in FineReport.

• Automated Continuous HDFS Replication to Amazon Redshift

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

• Object-Relational Mapping (ORM) with Dynamics NAV Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Microsoft Dynamics NAV into a Java-based ORM framework, Hibernate.

• Visualize QuickBooks Online in Tableau

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

• Add Neo4J to Informatica Enterprise Data Catalog

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

• Use Biml to Build SSIS Tasks to Replicate Certinia to SQL Server

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

• Connect to Twitter in RazorSQL

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

• Connect to Facebook from PowerBuilder

  This article demonstrates how to access Facebook from Appeon PowerBuilder using the CData ADO.NET Provider for Facebook.

• Connect to Tally in Ruby

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

• Connect to Odoo in HULFT Integrate

  Connect to Odoo as a JDBC data source in HULFT Integrate

• Create PostgreSQL Reports on JasperReports Server

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

• Natively Connect to SharePoint in PHP

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

• View Reports on Real-Time SAP Ariba Source in Power BI Report Server

  Use the CData ODBC Driver for SAP Ariba Source to visualize SAP Ariba Source in Power BI Desktop and then publish them to Power BI Report Server.

• Visualize Live Avro in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Apache Avro.

• Automated Continuous Acumatica Replication to PostgreSQL

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

• Access Reckon in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Reckon.

• Connect to MYOB AccountRight from HeidiSQL

  Use CData Connect Cloud to connect to and query live MYOB AccountRight from HeidiSQL.

• Author and Share Power BI Reports on Real-Time Oracle

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

• Stripe Reporting and Star Schemas in OBIEE

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

• A PostgreSQL Interface for Reckon

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

• Design BIRT Reports on PayPal

  Provide current PayPal to your embedded analytics.

• Automated Continuous Zuora Replication to Amazon S3

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

• Build a Simple VCL Application for Salesforce

  How to build a simple VCL Application to view Salesforce & Force.com in RAD Studio using the CData ODBC Driver for Salesforce.

• Connect to Instagram from a Connection Pool in Jetty

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

• Write a Simple Go Application to work with Zendesk on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zendesk.

• Visualize Sybase in Tableau

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

• Visualize Live Stripe in the Power BI Service

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

• Manage Aha in DBArtisan as a JDBC Source

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

• How to Connect to Zuora in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Zuora. Leverage the pyodbc module for ODBC in Python.

• Connect to ShipStation from HeidiSQL

  Use CData Connect Cloud to connect to and query live ShipStation from HeidiSQL.

• Create a Data Access Object for Parquet using JDBI

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

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

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

• Back Up JotForm to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for JotForm. In this article, we will employ an SSIS workflow to populate a database with JotForm data.

• Automated Continuous CouchDB Replication to Microsoft Access

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

• How to Visualize Azure Data Lake Storage Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Azure Data Lake Storage in Python.

• Object-Relational Mapping (ORM) with QuickBooks Time Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to QuickBooks Time into a Java-based ORM framework, Hibernate.

• Integrate CouchDB in the Pentaho Report Designer

  Publish reports based on Apache CouchDB in the Pentaho BI tool.

• Import Real-Time Todoist in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Todoist in ColdFusion.

• Load Jira to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Atlassian Jira to a database.

• Connect to Zoho Inventory in Google Apps Script

  Use CData Connect Cloud to access Zoho Inventory in Google Apps Script.

• Replicate SAP BusinessObjects BI to Multiple Databases

  Replicate SAP BusinessObjects BI to disparate databases with a point-and-click configuration.

• Connect to SAP Business One through External Services in Salesforce

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

• Replicate Multiple Cassandra Accounts

  Replicate multiple Cassandra accounts to one or many databases.

• Integrate with Presto using Apache Camel2

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

• Use Dash to Build to Web Apps on Sugar CRM

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

• Query Oracle Financials Cloud as a SQL Server Database in Node.js

  Execute SQL Server queries against Oracle Financials Cloud from Node.js.

• Automated Continuous Certinia Replication to Amazon S3

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

• Connect to SAP Ariba Procurement from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for SAP Ariba Procurement to connect to SAP Ariba Procurement and execute queries in PowerBuilder.

• How to connect PolyBase to Printful

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

• Connect to Amazon DynamoDB from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Amazon DynamoDB from Crystal Reports.

• Query, Visualize, and Share live Tableau CRM Analytics in Redash

  Use CData Connect Cloud to connect to live Tableau CRM Analytics in Redash for querying, visualizing, and sharing.

• Analyze Azure Table in R

  Create data visualizations and use high-performance statistical functions to analyze Azure Table Storage in Microsoft R Open.

• Replicate SAP Business One from PowerShell

  Write a quick PowerShell script to query SAP Business One. Use connectivity to the live data to replicate SAP Business One to SQL Server.

• Publish Procore-Connected Dashboards in Tableau Server

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

• Automated Continuous SAP HANA XS Advanced Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Apache Kafka.

• How to connect to YouTube Analytics in DBVisualizer

  Integrate YouTube Analytics with visual data analysis tools and data connection wizards in DBVisualizer

• Author and Share Power BI Reports on Real-Time SAP

  Use the CData ODBC Driver for SAP to visualize SAP ERP/NetWeaver in Power BI Desktop and then upload to the Power BI service.

• How to connect to DocuSign from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for DocuSign and work with DocuSign in Microsoft Excel on Mac OS X.

• Use the CData JDBC Driver for Salesforce in MicroStrategy Desktop

  Connect to Salesforce data in MicroStrategy Desktop using the CData JDBC Driver for Salesforce.

• Integrate with API in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live API in SnapLogic.

• Query Oracle Sales as a SQL Server Database in Node.js

  Execute SQL Server queries against Oracle Sales from Node.js.

• Build Kintone Visualizations in Tableau Desktop

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

• Integrate Real-Time Access to Azure Analysis Services in SAPUI5 MVC Apps

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

• Access Google Sheets in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Google Sheets.

• Connect to Freshdesk in NetBeans

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

• Stream Salesforce Pardot into Apache Kafka Topics

  Access and stream Salesforce Pardot in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• «
• 309
• 310
• 311
• 312
• 313
• 314
• 315
• 316
• 317
• 318
• »