Ready to get started?

Learn more:

AlloyDB Connectivity Solutions

AlloyDB Integration Guides and Tutorials



A list of guides and tutorials for connecting to and working with live AlloyDB data.

CData Software's connectivity tools enable users to connect directly to live AlloyDB data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on integrating with live AlloyDB data.

Integration Use-Cases

Click below to jump to articles related to specific integration use-case.

Business Intelligence & Analytics


ProductTechnologyArticle Title
Alteryx DesignerODBCPrepare, Blend, and Analyze AlloyDB in Alteryx Designer (ODBC)
Alteryx DesignerConnect CloudWork with Live AlloyDB Data in Alteryx Designer (Connect Cloud)
Amazon QuickSightConnect CloudBuild Interactive Dashboards from AlloyDB Data in Amazon QuickSight
Amazon SageMakerConnect CloudIntegrate Live AlloyDB data into Amazon SageMaker Canvas
Aqua Data StudioJDBCConnect to AlloyDB in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze AlloyDB Data in Databricks (AWS)
Azure Analysis ServicesConnect CloudModel AlloyDB Data Using Azure Analysis Services
BirstJDBCBuild Visualizations of AlloyDB in Birst
BIRTJDBCDesign BIRT Reports on AlloyDB
Clear AnalyticsODBCBuild Charts with AlloyDB in Clear Analytics
Cognos Analytics (On-Prem)Connect CloudAnalyze AlloyDB Data in Cognos Analytics
DBxtraODBCBuild Dashboards with AlloyDB in DBxtra
DomoODBCCreate Datasets from AlloyDB in Domo Workbench
Dundas BIODBCBuild Dashboards with AlloyDB in Dundas BI
Excel (on Mac OS)ODBCWork with AlloyDB Data in MS Excel on Mac OS X
FineReportJDBCFeed AlloyDB into FineReport
Google SheetsConnect CloudAccess Live AlloyDB Data in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with AlloyDB
Infragistics RevealConnect CloudAnalyze AlloyDB Data in Infragistics Reval
JasperServerJDBCCreate AlloyDB Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to AlloyDB in Jaspersoft Studio
JReport DesignerJDBCIntegrate with AlloyDB in JReport Designer
KlipfolioConnect CloudCreate AlloyDB-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the AlloyDB JDBC Driver in KNIME
LINQPadADO.NETWorking with AlloyDB in LINQPad
LookerConnect CloudAnalyze AlloyDB Data in Looker
Looker StudioConnect CloudCreate Reports from AlloyDB Data in Looker Studio
MetabaseConnect CloudCreate Interactive AlloyDB-Connected Metabase Dashboards
Microsoft ExcelConnect CloudAccess Live AlloyDB Data in Excel Desktop
Microsoft Excel for the WebConnect CloudAccess Live AlloyDB Data in Excel for the Web
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from AlloyDB
MicroStrategyConnect CloudConnect to Live AlloyDB Data in MicroStrategy through Connect Cloud
MicroStrategyJDBCUse the CData JDBC Driver for AlloyDB in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for AlloyDB in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for AlloyDB in MicroStrategy Web
Mode AnalyticsConnect CloudCreate AlloyDB-Connected Visualizations in Mode
OBIEEJDBCAlloyDB Reporting in OBIEE with the AlloyDB JDBC Driver
pandasPythonUse pandas to Visualize AlloyDB in Python
Pentaho Report DesignerJDBCIntegrate AlloyDB in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time AlloyDB
Power BI ServiceConnect CloudVisualize Live AlloyDB Data in the Power BI Service
Power PivotConnect CloudAccess AlloyDB Data in Microsoft Power Pivot
Power QueryConnect CloudAccess AlloyDB Data in Microsoft Power Query
Qlik CloudConnect CloudCreate Apps from AlloyDB Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query AlloyDB in QlikView over ODBC
RJDBCAnalyze AlloyDB in R (JDBC)
RODBCAnalyze AlloyDB in R (ODBC)
RapidMinerJDBCConnect to AlloyDB in RapidMiner
RedashConnect ServerBuild AlloyDB-Connected Dashboards in Redash
SAP Analytics CloudConnect CloudAnalyze AlloyDB Data in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for AlloyDB
SAP Crystal ReportsJDBCPublish Reports with AlloyDB in Crystal Reports
SASODBCUse the CData ODBC Driver for AlloyDB in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for AlloyDB in SAS JMP
SAS ViyaConnect CloudAnalyze Live AlloyDB Data in SAS Viya
SisenseJDBCVisualize Live AlloyDB in Sisense
Spago BIJDBCConnect to AlloyDB in SpagoBI
TableauTableauVisualize AlloyDB in Tableau Desktop
Tableau CloudConnect CloudBuild AlloyDB Visualizations in Tableau Cloud
Tableau ServerTableauPublish AlloyDB-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize AlloyDB in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize AlloyDB Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on AlloyDB from Spotfire Server
VisioODBCLink Visio Shapes to AlloyDB
Zoho AnalyticsConnect CloudCreate AlloyDB-Connected Dashboards in Zoho Analytics

Back to top

ETL & Replication


ProductTechnologyArticle Title
AirbyteConnect CloudConnect to AlloyDB Data in Airbyte ELT Pipelines
Amazon RedshiftCData SyncAutomated Continuous AlloyDB Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous AlloyDB Replication to Amazon S3
Apache AirflowJDBCBridge AlloyDB Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with AlloyDB using Apache Camel
Apache CassandraCData SyncAutomated Continuous AlloyDB Replication to Apache Cassandra
Apache KafkaCData SyncAutomated Continuous AlloyDB Replication to Apache Kafka
Apache NiFiJDBCBridge AlloyDB Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with AlloyDB Data in Apache NiFi
AWS GlueConnect CloudBuild ETL Jobs with AlloyDB Data in AWS Glue Jobs
Azure Data FactoryConnect CloudImport AlloyDB Data Using Azure Data Factory
Azure Data LakeCData SyncAutomated Continuous AlloyDB Replication to Azure Data Lake
Azure SynapseCData SyncAutomated Continuous AlloyDB Replication to Azure Synapse
BIMLSSISUse Biml to Build SSIS Tasks to Replicate AlloyDB to SQL Server
CloverDXJDBCConnect to AlloyDB in CloverDX (formerly CloverETL)
CouchbaseCData SyncAutomated Continuous AlloyDB Replication to Couchbase
CSVCData SyncAutomated Continuous AlloyDB Replication to Local Delimited Files
DatabricksCData SyncAutomated Continuous AlloyDB Replication to Databricks
FoxProODBCWork with AlloyDB in FoxPro
Google BigQueryCData SyncAutomated Continuous AlloyDB Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous AlloyDB Replication to Google Cloud SQL
Google Data FusionJDBCBuild AlloyDB-Connected ETL Processes in Google Data Fusion
Heroku / Salesforce ConnectCData SyncReplicate AlloyDB for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to AlloyDB in HULFT Integrate
IBM DB2CData SyncAutomated Continuous AlloyDB Replication to IBM DB2
Informatica CloudJDBCIntegrate AlloyDB in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for AlloyDB
Jaspersoft ETLJDBCConnect to AlloyDB in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous AlloyDB Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous AlloyDB Replication to Azure SQL
Microsoft ExcelExcelTransfer Data from Excel to AlloyDB
Microsoft Power AutomateConnect CloudBuild AlloyDB-Connected Automated Tasks with Power Automate (Desktop)
MongoDBCData SyncAutomated Continuous AlloyDB Replication to MongoDB
MySQLCData SyncAutomated Continuous AlloyDB Replication to MySQL
Oracle Data IntegratorJDBCETL AlloyDB in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous AlloyDB Replication to Oracle
petlPythonExtract, Transform, and Load AlloyDB in Python
PostgreSQLCData SyncAutomated Continuous AlloyDB Replication to PostgreSQL
Replicate to MySQLPowerShellReplicate AlloyDB to MySQL with PowerShell
SAP HANACData SyncAutomated Continuous AlloyDB Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous AlloyDB Replication to SingleStore
SnapLogicJDBCIntegrate AlloyDB with External Services using SnapLogic
SnowflakeCData SyncAutomated Continuous AlloyDB Replication to Snowflake
SQL ServerCData SyncAutomated Continuous AlloyDB Replication to SQL Server
SQL Server Linked ServerConnect CloudConnect to AlloyDB Data as a SQL Server Linked Server
SQLiteCData SyncAutomated Continuous AlloyDB Replication to SQLite
TalendJDBCConnect to AlloyDB and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to AlloyDB in UiPath Studio
VerticaCData SyncAutomated Continuous AlloyDB Replication to a Vertica Database

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to AlloyDB
.NET QueryBuilderODBCRapidly Develop AlloyDB-Driven Apps with Active Query Builder
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with AlloyDB
Apache SparkJDBCWork with AlloyDB in Apache Spark Using SQL
AppSheetConnect CloudCreate AlloyDB-Connected Business Apps in AppSheet
Bubble.ioConnect CloudBuild AlloyDB-Connected Apps in Bubble
C++BuilderODBCDataBind Controls to AlloyDB Data in C++Builder
ChoreoConnect CloudBuild Custom Apps on AlloyDB Data in Choreo
ColdFusionJDBCQuery AlloyDB in ColdFusion Using JDBC
ColdFusionODBCQuery AlloyDB in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on AlloyDB
DelphiODBCDataBind Controls to AlloyDB Data in Delphi
DevExpressADO.NETDataBind AlloyDB to the DevExpress Data Grid
EF - Code FirstADO.NETAccess AlloyDB with Entity Framework 6
EF - LINQADO.NETLINQ to AlloyDB
EF - MVCADO.NETBuild MVC Applications with Connectivity to AlloyDB
Filemaker ProODBCBidirectional Access to AlloyDB from FileMaker Pro
Filemaker Pro (on Mac)JDBCBidirectional Access to AlloyDB from FileMaker Pro (on Mac)
GoODBCWrite a Simple Go Application to work with AlloyDB on Linux
Google Apps ScriptConnect CloudConnect to AlloyDB Data in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with AlloyDB Entities in Java
IntelliJJDBCConnect to AlloyDB in IntelliJ
JBossJDBCConnect to AlloyDB from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for AlloyDB using JDBI
JRubyJDBCConnect to AlloyDB in JRuby
MendixConnect CloudBuild AlloyDB-Connected Apps in Mendix
Microsoft Power AppsConnect CloudIntegrate Live AlloyDB Data into Custom Business Apps Built in Power Apps
NodeJSConnect CloudQuery AlloyDB Data in Node.js (via Connect Cloud)
NodeJSODBCQuery AlloyDB through ODBC in Node.js
OutSystemsConnect CloudCreate AlloyDB-Connected Enterprise Applications in OutSystems
PHPConnect ServerAccess AlloyDB in PHP through Connect Server
PHPODBCNatively Connect to AlloyDB in PHP
PowerBuilderADO.NETConnect to AlloyDB from PowerBuilder
PowerShellPowerShellPipe AlloyDB to CSV in PowerShell
PyCharmODBCUsing the CData ODBC Driver for AlloyDB in PyCharm
PythonODBCConnect to AlloyDB in Python on Linux/UNIX
ReactConnect ServerBuild Dynamic React Apps with AlloyDB Data
RubyODBCConnect to AlloyDB in Ruby
RunMyProcessConnect CloudConnect to AlloyDB Data in RunMyProcess
RunMyProcess DSECJDBCConnect to AlloyDB in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to AlloyDB in SAPUI5 MVC Apps
ServoyJDBCBuild AlloyDB-Connected Apps in Servoy
Spring BootJDBCAccess Live AlloyDB Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access AlloyDB in Python
TomcatJDBCConfigure the CData JDBC Driver for AlloyDB in a Connection Pool in Tomcat
UnqorkConnect CloudCreate AlloyDB-Connected Applications in Unqork
VCL App (RAD Studio)ODBCBuild a Simple VCL Application for AlloyDB
WebLogicJDBCConnect to AlloyDB from a Connection Pool in WebLogic

Back to top

Data Management



Back to top

Workflow Automation



Back to top