Connection examples for new drivers about db.rstudio.com HOT 8 CLOSED

con <- DBI::dbConnect(odbc::odbc(),
                      Driver   = "[your driver's name]",
                      Server   = "[your server's path]",
                      Database = "[your database's name]",
                      UID      = rstudioapi::askForPassword("Database user"),
                      PWD      = rstudioapi::askForPassword("Database password"),
                      Port     = 1433)

con <- DBI::dbConnect(
  odbc::odbc(),
  Driver = "netezza",
  Server = "[Server IP]",
  Port = "5480",
  Database = "[DB Name]",
  UID = rstudioapi::askForPassword("Database user"),
  PWD = rstudioapi::askForPassword("Database password")
)

# no auth
con <- DBI::dbConnect(odbc::odbc(),
        Driver   = "Cassandra",
        Host     = "cassandra",
        Port     = 9042,
        Keyspace = "rstudio",
        AuthMech = 0)

# user auth
con <- DBI::dbConnect(odbc::odbc(),
        Driver   = "Cassandra",
        Host     = "cassandra",
        Port     = 9042,
        Keyspace = "rstudio",
        AuthMech = 1,
        UID      = rstudioapi::askForPassword("Database user"),
        PWD      = rstudioapi::askForPassword("Database password"))

con <- DBI::dbConnect(odbc::odbc(),
        Driver   = "MongoDB",
        Server   = "mongodb",
        Port     = 27017,
        Database = "rstudiodb",
        AuthMechanism = "SCRAM-SHA-1",
        UID      = "rstudioadmin",
        PWD      = "asdf")

con <- DBI::dbConnect(odbc::odbc(),
        Driver   = "Athena",
        S3OutputLocation = "[S3 bucket for athena output]",
        AwsRegion = "us-east-2",
        AuthenticationType = "IAM Credentials",
        Schema = "[Athena Table Name]",
        UID      = rstudioapi::askForPassword("AWS Access Key"),
        PWD      = rstudioapi::askForPassword("AWS Secret Access Key"))

con <- DBI::dbConnect(odbc::odbc(),
        Driver   = "Bigquery",
        Catalog  = "[Bigquery catalog]",
        DefaultDataset = "[BigQuery Dataset]",
        OAuthMechanism = 0,
        Email = rstudioapi::askForPassword("Google Cloud service account email"),
        KeyFilePath = "[Path to Google Cloud credentials JSON file]")