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).

Enter 1433 as the dynamic port for 10.200.2.9 and 127.0.0.1, and nothing in TCP port.
If there are other IPs, enter 0 as the dynamic port.
In IPAll, enter 1433 as TCP Port.
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	jdbcPort=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	jdbcurl=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