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).
- 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 |
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' |
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' |
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 |
Apache Hive | jdbc:apachehive:Server=127.0.0.1;Port=10000;TransportMode=BINARY | SELECT * FROM Customers |
Apache Phoenix | jdbc:apachephoenix:Server=localhost;Port=8765; | SELECT Id, Name AS My_Name, GETDATE() FROM Account WHERE Industry = 'Floppy Disks' |
Authorize.Net | jdbc:authorizenet:LoginID=myLoginID;TransactionKey=myTransactionKey | SELECT * FROM SettledBatchList |
Azure Table Storage | jdbc:azuretables:AccessKey=myAccessKey;Account=myAccountName; | SELECT * FROM NorthwindProducts |
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 |
Cassandra | jdbc:cassandra:Database=MyCassandraDB;Port=9042;Server=127.0.0.1; | SELECT * FROM Account |
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 |
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; | SELECT * FROM Lead |
Dynamics GP | jdbc:dynamicsgp:CompanyId=-1;user=myuser;password=mypassword; | SELECT * FROM Customer |
Dynamics NAV | jdbc:dynamicsnav:URL=http://myserver:7048; | SELECT * FROM Customer |
Elasticsearch | jdbc:elasticsearch:Server=127.0.0.1;Port=9200; | SELECT * FROM Account |
Eloqua | jdbc:oracleeloqua:User=user;Password=password;Company=MyCompany | SELECT * FROM Contact |
jdbc | SELECT * FROM [INBOX] | |
Exact Online | jdbc:exactonline:InitiateOAuth=GETANDREFRESH;Region='United States';Division=5512; | SELECT * FROM Accounts |
Excel | jdbc:excel:Excel File=C:\MyExcelWorkbooks\SampleWorkbook.xlsx; | SELECT * FROM Sheet |
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 |
jdbc:facebook:InitiateOAuth=GETANDREFRESH; | SELECT * FROM Statuses | |
Gmail | jdbc:gmail:user=myuseraccount;password=mypassword; | SELECT * FROM Inbox |
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 |
Google BigQuery | jdbc:googlebigquery:InitiateOAuth=GETANDREFRESH;ProjectId=NameOfProject;DatasetId=NameOfDataset; | SELECT * FROM publicdata.samples.github_nested |
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' |
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 |
HPCC | jdbc:hpcc:URL=http://127.0.0.1:8510;User=test;Password=xA123456;Version=1;Cluster=hthor; | SELECT * FROM hpcc::test::person |
HubSpot | jdbc:hubspot:InitiateOAuth=GETANDREFRESH; | "SELECT * FROM Contacts |
LDAP | jdbc:ldap:user=myuseraccount;password=mypassword; | SELECT * FROM User |
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 |
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 |
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' |
Marketo | jdbc:marketo:Schema=REST;RESTEndpoint=https://MyMarketoUrl/rest;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret; | SELECT * FROM Leads |
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=' | SELECT * FROM Contacts |
Microsoft Planner | jdbc:microsoftplanner:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyApplicationId;OAuthClientSecret=MySecretKey;CallbackURL=http://localhost:33333; | SELECT * FROM Tasks |
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 |
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 |
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' |
OData | jdbc:odata:User=myuseraccount;Password=mypassword;URL=http://myserver/myOrgRoot; | SELECT * FROM Lead |
Office 365 | jdbc:office365:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyApplicationId;OAuthClientSecret=MySecretKey;CallbackURL=http://localhost:33333; | SELECT * FROM Events |
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 |
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' |
Quandl | jdbc:quandl:ApiKey=abc123;DatabaseCode=WIKI; | SELECT * FROM AAPL |
QuickBooks | jdbc:quickbooks:User=test;Password=test;URL=http://localhost:8166; | SELECT * FROM Customers |
QuickBooks Online | jdbc:quickbooksonline:InitiateOAuth=GETANDREFRESH; | SELECT * FROM Customers |
QuickBooks POS | jdbc:quickbookspos:user=myuseraccount;password=mypassword;URL=http://localhost:2080;qbxmlversion=3.0; | SELECT * FROM Customers |
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 |
Sage 50 UK | jdbc:sage50uk:URL=http://localhost:5493/sdata/accounts50/GCRM/{C4C863BE-B098-4A7D-A78B-D7A92B8ADB59};User=Manager;Password=xxxxxx; | SELECT * FROM TradingAccounts |
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 |
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 |
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' |
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' |
SAP Hybris Cloud for Customer | jdbc:saphybrisc4c:User=user;Password=password; | SELECT * FROM AccountCollection |
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' |
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' |
ServiceNow | jdbc:servicenow:OAuthAccessToken=MyOAuthAccessToken;Instance=MyInstance; | SELECT * FROM incident |
SharePoint | jdbc:sharepoint:User=MyUserAccount;Password=MyPassword;Auth Scheme=NTLM;URL=http://sharepointserver/mysite; | SELECT * FROM Calendar |
Shopify | jdbc:shopify:AppId=MyAppId;Password=MyPassword;ShopUrl= | 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 | 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 |
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' |
SugarCRM | jdbc:sugarcrm:URL=http://mySugarCRM.com;User=myUser;Password=myPassword; | SELECT * FROM Accounts |
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' |
Twilio | jdbc:twilio:AccountSid=MyAccountSid;AuthToken=MyAuthToken; | SELECT * FROM Applications |
jdbc:twitter:InitiateOAuth=GETANDREFRESH; | SELECT * FROM Tweets | |
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 |
Xero Workflow Max | jdbc:xeroworkflowmax:APIKey=myApiKey;AccountKey=myAccountKey; | SELECT * FROM Clients |
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'; | SELECT * FROM Accounts |
Microsoft Exchange | jdbc:zohocrm:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:33333 | SELECT * FROM Accounts |
Port=993;Server=imap.gmail.com;Password=password;User=user;Protocol=IMAP;SMTP Port=587;SMTP Server=smtp.gmail.com;
url=Updated 5 months ago