Skip to main content

Profile connection parameters reference guide

Database Name Connection Type Bring Your Own Driver Required Parameters
MSSQL Non-JDBC No
  • Data Source = E.g.: 192.168.0.1
  • Initial Catalog = E.g., Northwind
  • User Id = username
  • Password = password
MSSQL JDBC No
  • Connection String = jdbc:sqlserver://localhost:1433;databaseName=db;
  • User Name = username
  • Password: password
  • Driver Class = com.microsoft.sqlserver.jdbc.SQLServerDriver
  • Default Enclosure Character = Double Quote (“)
MySql Non-JDBC No
  • Server = hostname
  • Database = E.g., Northwind
  • User Id = username
  • Password = password
MySql JDBC No
  • Connection String = jdbc:mysql://hostname:3306
  • User Name = username
  • Password: password
  • Driver Class = com.mysql.jdbc.Driver
  • Default Enclosure Character = Double Quote (“)
Oracle JDBC No
  • Connection String = jdbc:oracle:thin:@hostname:port/servicename
  • User Name = username
  • Password: password
  • Driver Class = oracle.jdbc.driver.OracleDriver
  • Default Enclosure Character = Double Quote (“)
Oracle JDBC with SSH No • Connection String = jdbc:oracle:thin:@hostname:port/servicename
• User Name = username
• Password: password
• Driver Class = oracle.jdbc.driver.OracleDriver
• Default Enclosure Character = Double Quote (“)
• SSH Host = SSH hostname
• SSH Username = SSH username
• SSH PEM File = pem file full location in the server
SAP BW Application Server No • Application Server = application hostname
• System No = E.g.: 10
• System ID = E.g.: BW5
• Client = E.g.: 400
• User = username
• Password = password
• Load Balancing = True/False
SAP BW Group/Server No • System No = E.g.: 10
• System ID = E.g.: BW5
• Client = E.g.: 400
• User = username
• Password = password
• Message Server Host = E.g.: mshost
• Logon Group = E.g.:26317
• Load Balancing = True/False
• Message Server Service = E.g.: 857596
SAP HANA  JDBC No • Connection String = jdbc:sap://hostname:30015/databaseName
• User Name = username
• Password: password
• Driver Class = com.sap.db.jdbc.Driver
• Default Enclosure Character = Double Quote (“)
SAP ECC Application server No • Application Server = E.g.: 192.168.0.1
• System No = E.g.: 10
• System ID = E.g.: BW5
• Client = E.g.: 400
• User = username
• Password = password
• SNC = False
SAP ECC Application server with SNC No • Application Server = E.g.: 192.168.0.1
• System No = E.g.: 10
• System ID = E.g.: BW5
• Client = E.g.: 400
• User = username
• Password = password
• SNC = True
• SNC My Name = E.g.: p:CN=Test, O=ORG, C=US, OU=SAPPACK
• SNC Partner Name = E.g.: p:CN=EC7, O=SAP, C=US, OU=SAP
SAP ECC Group/Server without SNC No • System No = E.g.: 10
• System ID = E.g.: BW5
• Client = E.g.: 400
• User = username
• Password = password
• Message Server Host = E.g.: R3NAME
• Logon Group = E.g.:26317
• Load Balancing = True/False
• SNC = False
SAP ECC Group/Server with SNC No • System No = E.g.: 10
• System ID = E.g.: BW5
• Client = E.g.: 400
• User = username
• Password = password
• Message Server Host = E.g.: R3NAME
• Logon Group = E.g.:26317
• Load Balancing = True/False
• SNC = True
• SNC My Name = E.g.: p:CN=Test, O=IBM, C=US, OU=SAPPACK
• SNC Partner Name = E.g.: p:CN=EC7, O=SAP, C=US, OU=SAP
SAP BOBJ - No • System = E.g.: 192.168.0.1
• user name = username
• Password: password
• Authentication = E.g.: secEnterprise
Redshift Non-JDBC No • Server = jdbc:redshift://endpoint:port/database
• Database = E.g., Northwind
• Port = E.g.: 5439
• User Id = username
• Password = My Password
Redshift JDBC No • Connection String =jdbc:redshift://examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439/dev
• User Name = username
• Password = password
• Driver Class = com.amazon.redshift.jdbc.Driver
• Default Enclosure Character = Double Quote (“)
PostgreSQL Non-JDBC No • Server = E.g.: Host name
• Database = E.g., postgres
• Port = E.g.: 5439
• User Id = username
• Password = password
PostgreSQL JDBC No • Connection String = jdbc:postgresql://192.168.1.170:5432/sample?ssl=true
• User Name = username
• Password: password
• Driver Class = org.postgresql.Driver
• Default Enclosure Character = Double Quote (“)
Tableau - No • Server = E.g.: serverhost
• PersonalAccessTokenName = My Tableau personal access token name
• PersonalAccessTokenSecret = My Tableau personal access token secret
• Site = E.g.: DataTrust
• Api Version = E.g.: 30
SSRS Non-JDBC No

• Server = Ex: http://192.168.0.1/ReportServer/reportservice2005.asmx

Host = http://192.168.0.1/

Report server name = /ReportServer/

Note: Report Server name can be found under Report Server Configuration Manager                          

web service name = /reportservice2005.asmx

Note: It will be installed by default while installing Report Server) 

Path to check web services = C:\Program Files\Microsoft SQL                            Server\MSRS12.SQL14\Reporting Services\ReportServer

• User Name = username
• Password = password
Power BI Cloud server No • Server Type = CloudServerURL
• User Name = username
• Password = password
• Client_id = xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
• client_secret = <Power BI client secret>
Power BI Cloud server with Tenant id No • Server Type = CloudServerURL
• Client_id = xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
• client_secret = <Power BI client secret>
• Tenant id = x0xx10-00x0-0x01-0xxx-x0x0x01xx100
Power BI On-Premise server No • User Name = username
• Password = password
• Server = ServerURL
Snowflake Non-JDBC No • Scheme = https
• Host = E.G.: dq44313.us-east-1.snowflakecomputing.com
• Port = My Port number
• user = username
• Password = password
• account = xy12345
• db = Snowflake
• Schema = Schema_Name
• role = role_name
• warehouse = warehouse_name
Snowflake JDBC No • Connection String = jdbc:snowflake://xy12345.snowflakecomputing.com/?user=peter&warehouse=mywarehhouse&db=mydb&schema=public
• User Name = username
• Password: password
• Driver Class = net.snowflake.client.jdbc.SnowflakeDriver
• Default Enclosure Character = Double Quote (“)
Snowflake JDBC with Private Key No • Connection String = jdbc:snowflake://xy12345.snowflakecomputing.com/?user=peter&warehouse=mywh&db=mydb&schema=public
• User Name = username
• Password: password
• Driver Class = net.myprofile.client.jdbc.myprofileDriver
• Default Enclosure Character = Double Quote (“)
• Private Key Path = <full path of the private key location>
• Passphrase: Passphrase
Salesforce JDBC No • Server = login.salesforce.com
• UserName = user name
• Password = password
• Sandbox = True/False
• Security Token = E.g.: <Token>
Google Big Query JDBC No • Connection String = DRIVER={Devart ODBC Driver for BigQuery}
• UserName = username
• Password = password
• Driver Class = E.g.: com.simba.googlebigquery.jdbc42.Driver
• Tenant = E.g.: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

Amazon S3

 - No
  • S3 bucket name.
  • AWS Client ID.
  • AWS Client Secret.

Amazon S3/ Azure ADLS/ Google GCS

 - No • Driver = {MapRDrill ODBC Driver}
• connection type = Direct
• host = localhost
• Port = E.g.: 31010
• Authentication type = E.g.: No Authentication
• Schema = myschema
MongoDB JDBC No • Connection String = jdbc:cdata:mongodb:Server=serverhostname
• User Name = username
• Password = password
• Driver Class = cdata.jdbc.mongodb.MongoDBDriver
• Default Enclosure Character = Double Quote (“)
Databricks JDBC No • Connection String = jdbc:databricks://<server-hostname>:443;httpPath=<http-path>
• User Name = token
• Password= <token>
• Driver Class = com.databricks.client.jdbc.Driver
• Default Enclosure Character = Double Quote (“)

 

Was this article helpful?