RSSBus JDBC Driver for SalesForce V3
The connection string properties describe the various options that can be used to establish a connection.
Jar
rssbus.salesforce.jar
Remarks
The ConnectionString property of the SalesForceConnection object can be set to a series of "option=value" pairs, separated by semicolons. If a connection string property value has special characters like semicolon, single-quote, or space etc., then you must quote the value using either single or double quotes.
Connection options are case insensitive.
To specify a location to the database where the table, view and stored procedures are located, set the Location property. In addition you must also set User and Password. Caching Data can be enabled by using the appropriate options.
Connection String Options
The following is the full list of the options you can configure in the connection string for this provider. Click on the links for further details.
| Access Token | The access token of the Salesforce account used to authenticate. |
| Auto Cache | Controls automatic caching of data returned by the provider. |
| Cache Location | Specifies the path and file name of the cache database. |
| Firewall Password | A password, if authentication is required to connect through a firewall. |
| Firewall Port | The TCP port for the firewall FirewallServer . See the description of the FirewallServer option for details. |
| Firewall Server | Specify a firewall name or IP address to authenticate requested connections, if necessary. |
| Firewall Type | The type of firewall to connect through. |
| Firewall User | A user name, if authenticating a connection to a firewall. |
| Location | A path to the directory that contains the schema files defining tables, views, and stored procedures for the data provider. |
| Logfile | A path to the log file. |
| Login URL | URL to the Salesforce server used for logging in. |
| Offline | Forces the provider to work in offline mode. |
| Other | The other parameters necessary to connect to a data source, e.g. username and password when applicable. |
| Password | The password of the SalesForce account used to authenticate. |
| Proxy Auth Scheme | The proxy server authorization scheme (default: BASIC). |
| Proxy Auto Detect | Whether to use the default system proxy settings or not. Set ProxyAutoDetect to FALSE to use custom proxy settings. This takes precedence over other proxy settings. |
| Proxy Password | A password, if authenticating with a proxy server. |
| Proxy Port | The TCP port for the proxy ProxyServer (default: 80). |
| Proxy Server | If a proxy server is given, then the HTTP request is sent to the proxy instead of the server otherwise specified. |
| Proxy SSL Type | The SSL type to use when connecting to the proxy server (default: AUTO). |
| Proxy User | A user name, if authentication is to be used for the proxy. |
| Pseudo Columns | Indicates whether or not to include pseudo-columns as columns to the table. |
| Query Passthrough | Controls how queries in Offline mode execute. |
| RTK | The runtime key for the data provider. |
| Tables | Comma separated list of tables to be listed by the data provider. E.g., Tables=TableA,TableB,TableC;. |
| Timeout | A timeout for the adapter. |
| User | The user of the SalesForce account used to authenticate. |
| Verbosity | The verbosity level for the logging. |