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://<yourdomainname>/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 ļ»æPort=993;Server=imap.gmail.com;Password=password;User=user;Protocol=IMAP;SMTP Port=587;SMTP Server=smtp.gmail.com; | SELECT * FROM ers] { [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 ļ»æ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](šļ»æ)ļ»æ |