SearchBlox

SearchBlox Developer Documentation

Welcome to the SearchBlox developer documentation. Here you will find comprehensive technical documentation to help you start working with SearchBlox as quickly as possible, as well as support if you get stuck. Let's jump right in!

Guides

Database Connection Settings

For successful connection and indexing, valid Database Collection settings must be provided along with valid query for Database collection.
To index databases like MySQL, SQL Server, Oracle, and PostgreSQL, the required database collections settings are:

  • Database Type
  • Host IP/Name
  • Host Port No.
  • Database Name
  • Database Username
  • Database Password

Other database connectors require the Database URL String.

Database Connection Settings for Databases

MySQL Settings

SQL Server Settings

📘

SearchBlox supports MS SQL Server versions later than 2012.

SQL Server Configuration

SQL Server has a dynamic port. In order to set the listening port (the host port in the image), follow the steps shown here: http://msdn.microsoft.com/en-us/library/ms177440.aspx.

Enter the port number in the dynamic port (see screenshots).

  1. Enter 1433 as the dynamic port for 10.200.2.9 and 127.0.0.1, and nothing in TCP port.
  2. If there are other IPs, enter 0 as the dynamic port.
  3. In IPAll, enter 1433 as TCP Port.
  4. Restart SQL Server and test the connection in SearchBlox.
    (ref: https://www.spdockit.com/support/help/faq/troubleshooting-sql-server/configure-sql-server-listen-specific-port/)

Oracle Settings

Postgre SQL

Database Connection Settings for Other Database Connectors

Database URL String has to be provided as shown in the screenshot for other database connectors listed in the section Database Connectors

Database Connectors

Database Collection supports an array of connectors. Please find the list of connectors, Database URL strings, sample query and reference link in the following table

Database Name

Database URL String

Sample Query

Active Directory

jdbc:activedirectory:User=MyUserName;Password=MyPassword;Server=MyServer;Port=MyPort;

SELECT * FROM User
http://cdn.cdata.com/help/CDE/jdbc/pg_select.htm

Adobe Analytics

jdbc:adobeanalytics:GlobalCompanyId=myGlobalCompanyId;RSID=myRSID;OAuthClientId=myOauthClientId;OauthClientSecret=myOAuthClientSecret;CallbackURL=myCallbackURL;

SELECT * FROM SampleTable_1 http://cdn.cdata.com/help/SCE/jdbc/pg_select.htm

Alfresco

jdbc:alfresco:ConnectionProperty1=Value1;ConnectionProperty2=Value2

"SELECT DBID, Column1 AS My_Column1, GETDATE() FROM Alfresco WHERE Column2 = 'Bob'
http://cdn.cdata.com/help/SJE/jdbc/pg_resultsetmetadatajdbc.htm"

Amazon Athena

jdbc:amazonathena:AccessKey='a123';SecretKey='s123';Region='IRELAND';Database='sampledb';S3StagingDirectory='s3://bucket/staging/';

SELECT * FROM Customers http://cdn.cdata.com/help/FKE/jdbc/pg_select.htm

Amazon DynamoDB

jdbc:amazondynamodb:Access Key=xxx;Secret Key=xxx;Domain=amazonaws.com;Region=OREGON;

SELECT * FROM Account http://cdn.cdata.com/help/DDE/jdbc/pg_select.htm

Amazon Marketplace

jdbc:amazonmarketplace:AWS Access Key Id=myAWSAccessKeyId;AWS Secret Key=myAWSSecretKey;MWS Auth Token=myMWSAuthToken;Seller Id=mySellerId;Marketplace=United States;

SELECT * FROM SampleTable_1 http://cdn.cdata.com/help/ONE/jdbc/pg_select.htm

Amazon RedShift

jdbc:redshift:User=admin;Password=admin;Database=dev;Server=examplecluster.my.us-west-2.redshift.amazonaws.com;Port=5439;

SELECT ShipName, ShipCity AS My_ShipCity, GETDATE() FROM Orders WHERE ShipCountry = 'USA'
http://cdn.cdata.com/help/FRE/jdbc/pg_resultsetmetadatajdbc.htm

Amazon S3

jdbc:amazons3:AccessKey=a123;SecretKey=s123;

SELECT * FROM Buckets http://cdn.cdata.com/help/SXE/jdbc/pg_select.htm

Apache HBase

jdbc:apachehbase:Server=127.0.0.1;Port=8080;

SELECT * FROM Account
http://cdn.cdata.com/help/RHE/jdbc/pg_select.htm

Apache Hive

jdbc:apachehive:Server=127.0.0.1;Port=10000;TransportMode=BINARY

SELECT * FROM Customers
http://cdn.cdata.com/help/FIE/jdbc/pg_select.htm

Apache Phoenix

jdbc:apachephoenix:Server=localhost;Port=8765;

SELECT Id, Name AS My_Name, GETDATE() FROM Account WHERE Industry = 'Floppy Disks'
http://cdn.cdata.com/help/UAE/jdbc/pg_resultsetmetadatajdbc.htm

Authorize.Net

jdbc:authorizenet:LoginID=myLoginID;TransactionKey=myTransactionKey

SELECT * FROM SettledBatchList
http://cdn.cdata.com/help/CWE/jdbc/pg_select.htm

Azure Table Storage

jdbc:azuretables:AccessKey=myAccessKey;Account=myAccountName;

SELECT * FROM NorthwindProducts
http://cdn.cdata.com/help/CAE/jdbc/pg_select.htm

BaseCamp

jdbc:basecamp:InitiateOAuth=GETANDREFRESH;AccountId=1234567;Schema=V3;ProjectId=abcd1234

SELECT * FROM Projects http://cdn.cdata.com/help/BCE/jdbc/pg_select.htm

Box

jdbc:box:InitiateOAuth=GETANDREFRESH;

SELECT * FROM Files http://cdn.cdata.com/help/BBE/jdbc/pg_select.htm

Bugzilla

jdbc:bugzilla: Url=http:///Bugzilla;APIKey=abc123;

SELECT * FROM SampleTable_1
http://cdn.cdata.com/help/SBE/jdbc/pg_select.htm

Cassandra

jdbc:cassandra:Database=MyCassandraDB;Port=9042;Server=127.0.0.1;

SELECT * FROM Account
http://cdn.cdata.com/help/RCE/jdbc/pg_select.htm

CosmosDB

jdbc:cosmosdb:AccountEndpoint=myAccountEndpoint;AccountKey=myAccountKey;

SELECT * FROM Customers http://cdn.cdata.com/help/EHE/jdbc/pg_select.htm

Couchbase

jdbc:couchbase:User='myusername';Password='mypassword';Server='http://couchbase40'

SELECT * FROM Customer
http://cdn.cdata.com/help/CKE/jdbc/pg_select.htm

CSV

jdbc:csv:GenerateSchemaFiles=OnStart;URI=https://MyAPI;Location=C:\\MySchemaFolder;

SELECT * FROM NorthwindOData http://cdn.cdata.com/help/RVE/jdbc/pg_select.htm

DocuSign

jdbc:docusign:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyClientId;OAuthClientSecret=MyClientSecret;CallbackURL=http://localhost:33333

SELECT * FROM Account http://cdn.cdata.com/help/UCE/jdbc/pg_select.htm

DropBox

jdbc:dropbox:InitiateOAuth=GETANDREFRESH;

SELECT * FROM Files http://cdn.cdata.com/help/OFE/jdbc/pg_select.htm

Dynamics 365 Business Central

jdbc:d365businesscentral:OrganizationUrl=https://businesscentral.dynamics.com/myAccount/;User=myUser;Access Key=myAccessKey;

SELECT * FROM Accounts http://cdn.cdata.com/help/FBE/jdbc/pg_select.htm

Dynamics 365 Finance And Operations

jdbc:d365finop:InitiateOAuth=GETANDREFRESH;OrganizationUrl=https://myaccount.operations.dynamics.com/;

SELECT * FROM Accounts http://cdn.cdata.com/help/FFE/jdbc/pg_select.htm

Dynamics 365 Sales

jdbc:d365sales:InitiateOAuth=GETANDREFRESH;OrganizationUrl=https://myaccount.crm.dynamics.com/;

SELECT * FROM Accounts http://cdn.cdata.com/help/ERE/jdbc/pg_select.htm

Dynamics CRM

dbc:dynamicscrm:User=myuseraccount;Password=mypassword;
URL=https://myOrg.crm.dynamics.com/;CRM Version=CRM Online;

SELECT * FROM Lead
http://cdn.cdata.com/help/RMA/jdbc/pg_select.htm

Dynamics GP

jdbc:dynamicsgp:CompanyId=-1;user=myuser;password=mypassword;
URL= http://{servername}:{port}/Dynamics/GPService

SELECT * FROM Customer
http://cdn.cdata.com/help/DPA/jdbc/pg_select.htm

Dynamics NAV

jdbc:dynamicsnav:URL=http://myserver:7048;
User=myserver\Administrator;Password=admin;
ServerInstance=DYNAMICSNAV71;

SELECT * FROM Customer
http://cdn.cdata.com/help/CNA/jdbc/pg_select.htm

Elasticsearch

jdbc:elasticsearch:Server=127.0.0.1;Port=9200;

SELECT * FROM Account
http://cdn.cdata.com/help/EEE/jdbc/pg_select.htm

Eloqua

jdbc:oracleeloqua:User=user;Password=password;Company=MyCompany

SELECT * FROM Contact
http://cdn.cdata.com/help/DUE/jdbc/pg_select.htm

Email

jdbc:email:Port=993;Server=imap.gmail.com;Password=password;User=user;Protocol=IMAP;SMTP Port=587;SMTP Server=smtp.gmail.com;

SELECT * FROM [INBOX]
http://cdn.cdata.com/help/REE/jdbc/pg_select.htm

Exact Online

jdbc:exactonline:InitiateOAuth=GETANDREFRESH;Region='United States';Division=5512;

SELECT * FROM Accounts
http://cdn.cdata.com/help/DYE/jdbc/pg_select.htm

Excel

jdbc:excel:Excel File=C:\MyExcelWorkbooks\SampleWorkbook.xlsx;

SELECT * FROM Sheet
http://cdn.cdata.com/help/RXE/jdbc/pg_select.htm

Excel Online

jdbc:excelonline:InitiateOAuth=GETANDREFRESH;

SELECT * FROM Test_xlsx_Sheet1 http://cdn.cdata.com/help/FXE/jdbc/pg_select.htm

Excel Services

jdbc:excelservices:Url=https://myorg.sharepoint.com;[email protected];Password=password;File=Book1.xlsx;

SELECT * FROM Account
http://cdn.cdata.com/help/DTE/jdbc/pg_select.htm

Facebook

jdbc:facebook:InitiateOAuth=GETANDREFRESH;

SELECT * FROM Statuses
http://cdn.cdata.com/help/RBE/jdbc/pg_select.htm

Gmail

jdbc:gmail:user=myuseraccount;password=mypassword;

SELECT * FROM Inbox
http://cdn.cdata.com/help/DLE/jdbc/pg_select.htm

Google Ads

jdbc:googleads:InitiateOAuth=GETANDREFRESH;DeveloperToken=myDeveloperToken;ClientCustomerId=myClientCustomerId;

SELECT * FROM CampaignPerformance :: http://cdn.cdata.com/help/DZE/jdbc/pg_select.htm

Google Ads Manager

jdbc:googleadsmanager:InitiateOAuth=GETANDREFRESH

SELECT * FROM Orders http://cdn.cdata.com/help/BDE/jdbc/pg_select.htm

Google Analytics

jdbc:googleanalytics:InitiateOAuth=GETANDREFRESH;Profile=myProfile;

SELECT * FROM Traffic
http://cdn.cdata.com/help/DAE/jdbc/pg_select.htm

Google BigQuery

jdbc:googlebigquery:InitiateOAuth=GETANDREFRESH;ProjectId=NameOfProject;DatasetId=NameOfDataset;

SELECT * FROM publicdata.samples.github_nested
http://cdn.cdata.com/help/DBE/jdbc/pg_select.htm

Google Campaign Manager

jdbc:googlecm:InitiateOAuth=GETANDREFRESH;ProfileID=MyUserProfileID;

SELECT * FROM CampaignPerformance http://cdn.cdata.com/help/EPE/jdbc/pg_select.htm

Google Directory

jdbc:googledirectory:InitiateOAuth=GETANDREFRESH;

SELECT * FROM Group http://cdn.cdata.com/help/EUE/jdbc/pg_select.htm

Google Drive

jdbc:googledrive:InitiateOAuth=GETANDREFRESH;

SELECT * FROM Files :: http://cdn.cdata.com/help/RGE/jdbc/pg_select.htm

Google Search

jdbc:googlesearch:ApiKey=abc123; CustomSearchID=def456;

"SELECT * FROM WebSearch WHERE SearchTerms = 'Fantastic Four'
http://cdn.cdata.com/help/BLE/jdbc/pg_select.htm"

Google Spanner

jdbc:GoogleSpanner:ProjectId='project1';InstanceId='instance1';Database='db1';OAuthClientId='757060765381';OauthClientSecret='abc';

SELECT * FROM Customer http://cdn.cdata.com/help/OGE/jdbc/pg_select.htm

Google SpreadSheets

jdbc:googlesheets:InitiateOAuth=GETANDREFRESH;Spreadsheet=NorthwindOrders

SELECT * FROM Spreadsheet1_Sheet1
http://cdn.cdata.com/help/RLE/jdbc/pg_select.htm

HPCC

jdbc:hpcc:URL=http://127.0.0.1:8510;User=test;Password=xA123456;Version=1;Cluster=hthor;

SELECT * FROM hpcc::test::person
http://cdn.cdata.com/help/CHE/jdbc/pg_select.htm

HubSpot

jdbc:hubspot:InitiateOAuth=GETANDREFRESH;

"SELECT * FROM Contacts
http://cdn.cdata.com/help/DHE/jdbc/pg_select.htm"

LDAP

jdbc:ldap:user=myuseraccount;password=mypassword;

SELECT * FROM User
http://cdn.cdata.com/help/RJA/jdbc/pg_select.htm

Instagram

jdbc:instagram:InitiateOAuth=GETANDREFRESH;BusinessAccountId=3218475

SELECT * FROM Users http://cdn.cdata.com/help/ENE/jdbc/pg_select.htm

JDBC-ODBC Bridge

jdbc:jdbcodbc:Driver={SQL Server};Server=localhost;Database=AdventureWorks

SELECT Id, Name AS My_Name, GETDATE() FROM Account WHERE Industry = 'Floppy Disks' http://cdn.cdata.com/help/EJE/jdbc/pg_resultsetmetadatajdbc.htm

JIRA

jdbc:jira:User=admin;APIToken=myApiToken;Url=https://yoursitename.atlassian.net

SELECT * FROM Projects http://cdn.cdata.com/help/BJE/jdbc/pg_select.htm

JSON

jdbc:json:DataModel=Relational;URI=C:\people.json

SELECT * FROM NorthwindOData http://cdn.cdata.com/help/DJE/jdbc/pg_select.htm

Kintone

jdbc:kintone:User=myuseraccount;Password=mypassword;Url=http://subdomain.domain.com;GuestSpaceId=myspaceid

SELECT * FROM Comments http://cdn.cdata.com/help/EKE/jdbc/pg_select.htm

LDAP

jdbc:ldap:user=MyUserName;password=MyPassword;Server=MyServer;Port=MyPort;

SELECT * FROM User
http://cdn.cdata.com/help/RJE/jdbc/pg_select.htm

LinkedIn

jdbc:linkedin:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:portNumber;CompanyId=XXXXXXX

SELECT * FROM CompanyStatusUpdates http://cdn.cdata.com/help/CLE/jdbc/pg_select.htm

Magento

jdbc:magento:Schema=magento2;User=admin;Password=admin;Url=https://mymagentohost/magento2

SELECT * FROM Products
http://cdn.cdata.com/help/BZE/jdbc/pg_select.htm

MailChimp

jdbc:mailchimp:APIKey=myAPIKey;

SELECT * FROM Lists http://cdn.cdata.com/help/CME/jdbc/pg_select.htm

MariaDB

jdbc:mariadb:User=myUser;Password=myPassword;Database=NorthWind;Server=myServer;Port=3306;

SELECT ShipName, ShipCity AS My_ShipCity, GETDATE() FROM Orders WHERE ShipCountry = 'USA'
http://cdn.cdata.com/help/SRE/jdbc/pg_resultsetmetadatajdbc.htm

Marketo

jdbc:marketo:Schema=REST;RESTEndpoint=https://MyMarketoUrl/rest;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;

SELECT * FROM Leads
http://cdn.cdata.com/help/DKE/jdbc/pg_select.htm

MarkLogic

jdbc:marklogic:User='myusername';Password='mypassword';Server='marklogic'

SELECT * FROM Customer http://cdn.cdata.com/help/OME/jdbc/pg_select.htm

Microsoft Exchange

jdbc:exchange:User='[email protected]';Password='myPassword';Server='https://outlook.office365.com/EWS/Exchange.asmx';Platform='Exchange_Online';Schema='EWS';

SELECT * FROM Contacts
http://cdn.cdata.com/help/CEE/jdbc/pg_select.htm

Microsoft Planner

jdbc:microsoftplanner:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyApplicationId;OAuthClientSecret=MySecretKey;CallbackURL=http://localhost:33333;

SELECT * FROM Tasks
http://cdn.cdata.com/help/UIE/jdbc/pg_select.htm

Microsoft Project

jdbc:microsoftproject:user=myuseraccount;password=mypassword;URL=http://myserver/myOrgRoot;

SELECT * FROM Projects http://cdn.cdata.com/help/COE/jdbc/pg_select.htm

Microsoft Teams

jdbc:msteams:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyApplicationId;OAuthClientSecret=MySecretKey;CallbackURL=http://localhost:33333;

SELECT * FROM Teams http://cdn.cdata.com/help/GSE/jdbc/pg_select.htm

MongoDB

jdbc:mongodb:Server=127.0.0.1;Port=27017;Database=test;User=test;Password=test;

SELECT * FROM Customers
http://cdn.cdata.com/help/DGE/jdbc/pg_select.htm

MYOB

jdbc:myob: If using an online instance: InitiateOAuth=GETANDREFRESH;OAuthClientId=YourClientId;OAuthClientSecret=YourClientSecret;CompanyFileId=yourCompanyFileId;CallbackURL=http://localhost:33333;User=companyFileUser;Password=companyFilePassword; If using an on premise instance: InitiateOAuth=OFF;URL=http://localhost:8080/accountright;CompanyFileId=327eed10-9615-4e5e-bd9e-ae2cc00e2c70;User=companyFileUser;Password=companyFilePassword;

SELECT * FROM Accounts
http://cdn.cdata.com/help/UME/jdbc/pg_select.htm

MySQL

jdbc:mysql:User=myUser;Password=myPassword;Database=NorthWind;Server=myServer;Port=3306;

SELECT ShipName, ShipCity AS My_ShipCity, GETDATE() FROM Orders WHERE ShipCountry = 'USA'
http://cdn.cdata.com/help/DME/jdbc/pg_resultsetmetadatajdbc.htm

OData

jdbc:odata:User=myuseraccount;Password=mypassword;URL=http://myserver/myOrgRoot;

SELECT * FROM Lead
http://cdn.cdata.com/help/RDE/jdbc/pg_select.htm

Office 365

jdbc:office365:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyApplicationId;OAuthClientSecret=MySecretKey;CallbackURL=http://localhost:33333;

SELECT * FROM Events
http://cdn.cdata.com/help/CXE/jdbc/pg_select.htm

Oracle Database

jdbc:oracleoci:User=scott;Password=tiger;Server=127.0.0.1;Port=1521;

SELECT CompanyName, City AS My_City, GETDATE() FROM Customers WHERE Country = 'US' http://cdn.cdata.com/help/SOE/jdbc/pg_resultsetmetadatajdbc.htm

Oracle Sales Cloud

jdbc:oraclesalescloud:HostURL=https://my.host.oraclecloud.com; Username=abc123; Password=abcdef;

SELECT * FROM Opportunities
http://cdn.cdata.com/help/EOE/jdbc/pg_select.htm

Pinterest

jdbc:pinterest:InitiateOAuth=GETANDREFRESH;OAuthClientId=YourClientId;OAuthClientSecret=YourClientSecret;CallbackURL='https://localhost:33333'

SELECT * FROM USERS http://cdn.cdata.com/help/UPE/jdbc/pg_select.htm

PostgreSQL

jdbc:postgresql:User=postgres;Password=admin;Database=postgres;Server=127.0.0.1;Port=5432

SELECT ShipName, ShipCity AS My_ShipCity, GETDATE() FROM Orders WHERE ShipCountry = 'USA'
http://cdn.cdata.com/help/FPE/jdbc/pg_resultsetmetadatajdbc.htm

Quandl

jdbc:quandl:ApiKey=abc123;DatabaseCode=WIKI;

SELECT * FROM AAPL
http://cdn.cdata.com/help/BRE/jdbc/pg_select.htm

QuickBooks

jdbc:quickbooks:User=test;Password=test;URL=http://localhost:8166;

SELECT * FROM Customers
http://cdn.cdata.com/help/RQE/jdbc/pg_select.htm

QuickBooks Online

jdbc:quickbooksonline:InitiateOAuth=GETANDREFRESH;

SELECT * FROM Customers
http://cdn.cdata.com/help/RNE/jdbc/pg_select.htm

QuickBooks POS

jdbc:quickbookspos:user=myuseraccount;password=mypassword;URL=http://localhost:2080;qbxmlversion=3.0;

SELECT * FROM Customers
http://cdn.cdata.com/help/DRE/jdbc/pg_select.htm

Redis

jdbc:redis:Server=127.0.0.1;Password=myPassword;

SELECT * FROM Customers http://cdn.cdata.com/help/EIE/jdbc/pg_select.htm

REST

jdbc:rest:DataModel=Relational;URI=C:\people.xml;Format=XML

SELECT * FROM NorthwindOData http://cdn.cdata.com/help/DWE/jdbc/pg_select.htm

RSS

jdbc:rss:URI=http://myservice/myfeed/;

SELECT * FROM RSSFeed
http://cdn.cdata.com/help/RRE/jdbc/pg_select.htm

Sage 50 UK

jdbc:sage50uk:URL=http://localhost:5493/sdata/accounts50/GCRM/{C4C863BE-B098-4A7D-A78B-D7A92B8ADB59};User=Manager;Password=xxxxxx;

SELECT * FROM TradingAccounts
http://cdn.cdata.com/help/CSE/jdbc/pg_select.htm

Sage Business Cloud Accounting

jdbc:sagebcaccounting:InitiateOAuth=GETANDREFRESH;

SELECT * FROM SampleTable_1 http://cdn.cdata.com/help/GAE/jdbc/pg_select.htm

Sage Intacct

jdbc:sageintacct:User='myusername';CompanyID='TestCompany';Password='mypassword';SenderID='Test';SenderPassword='abcde123';

SELECT * FROM Customer http://cdn.cdata.com/help/CTE/jdbc/pg_select.htm

Salesforce

jdbc:salesforce:User=myUser;Password=myPassword;Security Token=myToken;

SELECT * FROM Account
http://cdn.cdata.com/help/RFE/jdbc/pg_select.htm

Salesforce Chatter

jdbc:salesforcechatter:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=https://localhost:34343;

SELECT * FROM Users http://cdn.cdata.com/help/BFE/jdbc/pg_select.htm

Salesforce Einstein Analytics

jdbc:sfeinsteinanalytics:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyConsumerKey;OAuthClientSecret=MyConsumerSecret;CallbackURL=http://localhost:portNumber

SELECT * FROM Dataset_Opportunity http://cdn.cdata.com/help/FSE/jdbc/pg_select.htm

Salesforce Marketing Cloud

jdbc:sfmarketingcloud:User=myUser;Password=myPassword;

SELECT * FROM Subscriber http://cdn.cdata.com/help/FEE/jdbc/pg_select.htm

Salesforce Pardot

jdbc:salesforcepardot: ApiVersion=4;User=YourUsername;Password=YourPassword;UserKey=YourUserKey;

SELECT * FROM Prospects http://cdn.cdata.com/help/GPE/jdbc/pg_select.htm

SAP Business One

jdbc:sapbusinessone:Url=http://localhost:50000/b1s/v1;User=username;Password=password;CompanyDB=dbname;

SELECT * FROM Orders
http://cdn.cdata.com/help/FVE/jdbc/pg_select.htm

SAP Business One DI

jdbc:sapbusinessonedi:Server=ServerName;DBServerType=MSSQL_2016;CompanyDB=SBODemoCA;User=manager;Password=manager;

SELECT AcctCode, AcctName AS My_AcctName, GETDATE() FROM OACT WHERE AcctName = 'account_name'
http://cdn.cdata.com/help/GDE/jdbc/pg_resultsetmetadatajdbc.htm

SAP ByDesign

jdbc:sapbydesign:URL=https://my999999.sapbydesign.com;User=username;Password=password;CustomService=servicename;

SELECT * FROM Account http://cdn.cdata.com/help/UYE/jdbc/pg_select.htm

SAP Concur

jdbc:sapconcur:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;

SELECT * FROM Departments http://cdn.cdata.com/help/FNE/jdbc/pg_select.htm

SAP ERP

jdbc:saperp:Host=sap.mydomain.com;User=EXT90033;Password=xxx;Client=800;System Number=09;ConnectionType=Classic;

SELECT * FROM MARA http://cdn.cdata.com/help/RYE/jdbc/pg_select.htm

SAP HANA

jdbc:saphana:User=system;Password=mypassword;Server=localhost;Database=systemdb;

"SELECT Id, ProductName AS My_ProductName, GETDATE() FROM Products WHERE ProductName = 'Konbu'
http://cdn.cdata.com/help/SNE/jdbc/pg_resultsetmetadatajdbc.htm"

SAP Hybris Cloud for Customer

jdbc:saphybrisc4c:User=user;Password=password;

SELECT * FROM AccountCollection
http://cdn.cdata.com/help/OHE/jdbc/pg_select.htm

SAP SuccessFactors

jdbc:sapsuccessfactors:User=username;Password=password;CompanyId=CompanyId;Url=https://api4.successfactors.com

SELECT * FROM SampleTable_1 http://cdn.cdata.com/help/GBE/jdbc/pg_select.htm

SAP Sybase ASE

jdbc:sybase:user=myuser;password=mypassword;Server=localhost;Database=Northwind

"SELECT Id, ProductName AS My_ProductName, GETDATE() FROM Products WHERE ProductName = 'Konbu'
http://cdn.cdata.com/help/OYE/jdbc/pg_resultsetmetadatajdbc.htm"

SAP Sybase IQ

jdbc:sybaseiq:user=myuser;password=mypassword;Server=localhost;Database=Northwind

SELECT Id, ProductName AS My_ProductName, GETDATE() FROM Products WHERE ProductName = 'Konbu'
http://cdn.cdata.com/help/GYE/jdbc/pg_resultsetmetadatajdbc.htm

ServiceNow

jdbc:servicenow:OAuthAccessToken=MyOAuthAccessToken;Instance=MyInstance;

SELECT * FROM incident
http://cdn.cdata.com/help/BNB/jdbc/pg_select.htm

SharePoint

jdbc:sharepoint:User=MyUserAccount;Password=MyPassword;Auth Scheme=NTLM;URL=http://sharepointserver/mysite;

SELECT * FROM Calendar
http://cdn.cdata.com/help/RSE/jdbc/pg_select.htm

Shopify

jdbc:shopify:AppId=MyAppId;Password=MyPassword;ShopUrl=https://yourshopname.myshopify.com;

SELECT * FROM Customers http://cdn.cdata.com/help/FOE/jdbc/pg_select.htm

Slack

jdbc:slack:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:33333;

SELECT * FROM Channels http://cdn.cdata.com/help/FCE/jdbc/pg_select.htm

Smartsheet

jdbc:smartsheet:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:33333;

SELECT * FROM Sheet_Test_Sheet http://cdn.cdata.com/help/BSE/jdbc/pg_select.htm

Snowflake

jdbc:snowflake:url=https://myaccount.region.snowflakecomputing.com;user=Admin;password=test123;Database=Northwind;Warehouse=TestWarehouse;Account=Tester1;

SELECT * FROM Products http://cdn.cdata.com/help/OWE/jdbc/pg_select.htm

Spark SQL

jdbc:sparksql:Server=127.0.0.1;

SELECT * FROM Customers
http://cdn.cdata.com/help/ESE/jdbc/pg_select.htm

Splunk

jdbc:splunk:user=MyUserName;password=MyPassword;URL=MyURL;

SELECT * FROM DataModels http://cdn.cdata.com/help/FUE/jdbc/pg_select.htm

SQL Server

jdbc:sql:user=myuser;password=mypassword;Server=localhost;Database=Northwind;

SELECT Id, ProductName AS My_ProductName, GETDATE() FROM Products WHERE ProductName = 'Konbu'
http://cdn.cdata.com/help/RUE/jdbc/pg_resultsetmetadatajdbc.htm

SugarCRM

jdbc:sugarcrm:URL=http://mySugarCRM.com;User=myUser;Password=myPassword;

SELECT * FROM Accounts
http://cdn.cdata.com/help/CCE/jdbc/pg_select.htm

SurveyMonkey

jdbc:surveymonkey:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:portNumber;

SELECT * FROM MySurvey_Responses http://cdn.cdata.com/help/FME/jdbc/pg_select.htm

Teradata

jdbc:teradata:User=Admin;Password=test123;Database=Northwind;DataSource=127.0.0.1

SELECT ProductId, ProductName AS My_ProductName, GETDATE() FROM NorthwindProducts WHERE CategoryId = '5'
http://cdn.cdata.com/help/OTE/jdbc/pg_resultsetmetadatajdbc.htm

Twilio

jdbc:twilio:AccountSid=MyAccountSid;AuthToken=MyAuthToken;

SELECT * FROM Applications
http://cdn.cdata.com/help/BTE/jdbc/pg_select.htm

Twitter

jdbc:twitter:InitiateOAuth=GETANDREFRESH;

SELECT * FROM Tweets
http://cdn.cdata.com/help/RTE/jdbc/pg_select.htm

Veeva Vault

jdbc:veevavault:Url=myURL;User=myUser;Password=myPassword;

SELECT * FROM Documents http://cdn.cdata.com/help/SVE/jdbc/pg_select.htm

Wasabi

jdbc:wasabi:AccessKey=a123;SecretKey=s123;

SELECT * FROM Buckets http://cdn.cdata.com/help/UWE/jdbc/pg_select.htm

WordPress

jdbc:wordpress:Url=http://www.yourwordpresshost.com;User=yourUsername;Password=yourPassword;

SELECT * FROM Categories http://cdn.cdata.com/help/FWE/jdbc/pg_select.htm

Xero

jdbc:xero:InitiateOAuth=GETANDREFRESH;

SELECT * FROM Contacts
http://cdn.cdata.com/help/DXE/jdbc/pg_select.htm

Xero Workflow Max

jdbc:xeroworkflowmax:APIKey=myApiKey;AccountKey=myAccountKey;

SELECT * FROM Clients
http://cdn.cdata.com/help/GXE/jdbc/pg_select.htm

XML

jdbc:xml:DataModel=Relational;URI=C:\people.xml;

SELECT * FROM NorthwindOData http://cdn.cdata.com/help/DVE/jdbc/pg_select.htm

YouTube Analytics

jdbc:youtubeanalytics:InitiateOAuth=GETANDREFRESH;ContentOwnerId=MyContentOwnerId;ChannelId=ChannelId;

SELECT * FROM Groups http://cdn.cdata.com/help/BYE/jdbc/pg_select.htm

YouTube Data

jdbc:youtube:InitiateOAuth=GETANDREFRESH;

SELECT * FROM Videos http://cdn.cdata.com/help/CGE/jdbc/pg_select.htm

Zendesk

jdbc:zendesk:URL=https://subdomain.zendesk.com;[email protected];Password=test123;

SELECT * FROM Tickets http://cdn.cdata.com/help/FZE/jdbc/pg_select.htm

ZohoCRM

jdbc:zohocrm:User='[email protected]';Password='myPassword';
AuthToken='1a2b3c4d5e6f...';

SELECT * FROM Accounts
http://cdn.cdata.com/help/CZA/jdbc/pg_select.htm

Microsoft Exchange

jdbc:zohocrm:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:33333

SELECT * FROM Accounts
http://cdn.cdata.com/help/CZE/jdbc/pg_select.htm

Updated about a month ago



Database Connection Settings


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.