Connect via Python
| Code Block | ||
|---|---|---|
| ||
import pyodbc
import pandas as pd
driver = '{ODBC Driver 18 for SQL Server}'
server = 'something.camh.ca'
user_id = 'myusername'
password = 'mypassword'
database = 'databasename'
conn = pyodbc.connect(
DRIVER = driver,
SERVER = server,
UID = user_id,
PWD = password,
DATABASE = database,
TrustServerCertificate = 'Yes',
MARS_Connection = 'Yes'
)
data = pd.read_sql("select * from databasename.dbo.tablename", conn)
|
Connect via RStudio
| Code Block | ||
|---|---|---|
| ||
library(odbc)
con <- dbConnect(odbc(),
Driver = "/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.0.so.1.1",
Server = "something.camh.ca",
Database = "MyDatabaseName",
UID = "MyUserId",
PWD = "MyPassword",
TrustServerCertificate='Yes',
MARS_Connection='Yes'
)
#Setup the query:
Query = "SELECT * FROM MyDatabaseName.dbo.TableName"
#Send the query to the database
res <- dbSendQuery(con, Query)
#Fetch data coming out from that query in R Dataframe format
df = dbFetch(res)
|