---
title: "Source Connection Details"
canonical: "https://docs.vaultspeed.com/space/VPD/3012722714/Source%20Connection%20Details"
format: markdown
---
When using the standard agent, the following data sources are supported. Note: Username and password can also be configured separately if needed.

| **Source type** | **URL format** |
| --- | --- |
| Oracle | `jdbc:oracle:thin:<username>/<password>@<server>:<port>:<SID>` |
| Oracle | `jdbc:oracle:thin:<username>/<password>@<server>:<port>/<service_name>` |
| SQL Server | `jdbc:sqlserver://<server>:<port>;databaseName=<database name>;user=<username>;password=<password>` |
| PostgreSQL | `jdbc:postgresql://<server>:<port>/<database>?user=<user>&password=<password>` |
| Greenplum | `jdbc:postgresql://<server>:<port>/<database>?user=<user>&password=<password>` |
| Apache Hive | `jdbc:hive2://<host>:<port>/<dbName>;<configuration parameters for the JDBC driver>?<configuration parameters for Hive on the server>#<configuration parameters for Hive variables>` |
| Apache Spark (Databricks) & Databricks Delta Lake | `jdbc:databricks://<host>:<port>;<configuration parameters>` |
| Informix | `jdbc:informix-sqli://<host>:<port>/<database_name>:user=<userid>;password=<password>;INFORMIXSERVER=<servername>;` |
| Snowflake | `jdbc:snowflake://<account_name>.snowflakecomputing.com/?user=<login_name>&password=<string>&warehouse=<string>&database=<database>&CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX=TRUE&JDBC_TREAT_DECIMAL_AS_INT=FALSE&<other connection_params>`<br>> 📝 The `warehouse `parameter is required in the connection string to specify the compute warehouse to use for executing queries. Ensure that the warehouse is pre-configured in your Snowflake account. |
| Confluent Cloud (kafka) | `https://<key>:<secret>@ccloud_url ` (make sure to convert everything to a web safe URL, especially the special characters from the api key) |
| SingleStore | `jdbc:singlestore://<server>:<port>/<database>?user=<user>&password=<password>&allowMultiQueries=true`<br>> 📝 **Note**: 
> 📝 
> 📝 Always include the `allowMultiQueries=true` option in the connection string to enable support for multiple queries in a single statement. |
| Google BigQuery | To connect to Google BigQuery using JDBC, use the following connection string format:<br>`jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=<your_project_id>;OAuthType=0;OAuthServiceAcctEmail=<your_service_account_mail>;OAuthPvtKeyPath=<keyPath_json_file_full_location>;`<br>> 📝 #### Notes:
> 📝 
> 📝 - Replace all placeholders (`<your_project_id>`, `<your_service_account_mail>`, `<keyPath_json_file_full_location>`) with the actual values specific to your environment.
> 📝 - Ensure the private key file is securely stored and accessible to the application using this connection.<br>#### Additional Resources:<br>For detailed setup instructions, refer to the [Google BigQuery Connection Setup](https://docs.vaultspeed.com/space/VPD/3780935696/Google+BigQuery+Connection+Setup) page. |

> 📝 ### Handling Special Characters in JDBC Connection Strings
> 📝 
> 📝 If your JDBC connection string contains special characters (e.g., `&`, `§`, etc.), you must enclose the entire string in double quotes (`"`). This ensures the string is parsed correctly by the application.
> 📝 
> 📝 **Example:**  
> 📝 `"jdbc:postgresql://myserver:123/mydb?user=me&password=str&ng§pwd"`
> 📝 
> 📝 **Notes**:
> 📝 
> 📝 - Double quotes are required to avoid issues with special characters being misinterpreted by the application or shell.
> 📝 - Verify that all special characters are supported by your JDBC driver and database before use.

> 📝 ### Using Oracle Service Names
> 📝 
> 📝 If you are using Oracle Service Names, configure your connection details in the VaultSpeed agent. The internal VaultSpeed form defaults to using the SID syntax. If you need to use a Service Name, ensure it is explicitly configured.

> 📝 ### Snowflake Private Connection
> 📝 
> 📝 If you are using a private connection with Snowflake, ensure that **SnowSQL** is installed on the server where the VaultSpeed agent is running. SnowSQL is required to facilitate the connection.