RSSBus JDBC Driver for MSCRM
The connection string properties describe the various options that can be used to establish a connection.
Jar
rssbus.mscrm.jar
Remarks
The ConnectionString property of the MSCRMConnection object can be set to a series of option=value strings 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.
The Url, User and Password can be used to specify the credentials and the MSCRM Organization to. In addition, specifying the CacheLocation will tell the RSSBus JDBC Driver for MSCRM to cache metadata to the specified file, ensuring that queries execute more quickly.
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.
| 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. |
| 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 used to authenticate to the MSCRM site. |
| 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. |
| 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. |
| Url | Url to the Organization root or the OData services file. For example, http://MySite/MyOrganization. |
| User | The user that is authenticating to the MSCRM site. |
| Verbosity | The verbosity level for the logging. |