odbc.resourcer
Open Database Connectivity Resource Resolver
A database resource that is accessible through the Open Database Connectivity ('ODBC') API. This package uses the Resource model, with URL "resolver" and "client", to dynamically discover and make accessible tables stored in a 'MS SQL Server' database. For more details see Marcon (2021) <doi:10.1371/journal.pcbi.1008880>.
README
# MS SQL Server Usage Example
This directory contains an example of how to use the `odbc.resourcer` package to connect to a Microsoft SQL Server database and retrieve table values.
## Prerequisites
- Run an instance of Microsoft SQL Server.
```
# get the docker image
make pull
# start the container
make up
```
- Add some initial data in the database. You can use the provided `init-scripts/init.sql` script to create a sample database and table.
```
# initialize the database with sample data
make init
# list databases
make databases
```
- Install the `odbc.resourcer` R package.
```
remote::install_github("obiba/odbc.resourcer")
```
- You may need to install some system dependencies:
```
sudo make ubuntu-deps
```
## Usage
See provided `mssql-client.R` script for an example of how to connect to the database and retrieve data.
Versions across snapshots
| Version | Repository | File | Size |
|---|---|---|---|
1.0.0 |
rolling linux/jammy R-4.5 | odbc.resourcer_1.0.0.tar.gz |
92.2 KiB |
1.0.0 |
rolling linux/noble R-4.5 | odbc.resourcer_1.0.0.tar.gz |
92.1 KiB |
1.0.0 |
rolling source/ R- | odbc.resourcer_1.0.0.tar.gz |
12.2 KiB |
1.0.0 |
latest linux/jammy R-4.5 | odbc.resourcer_1.0.0.tar.gz |
92.2 KiB |
1.0.0 |
latest linux/noble R-4.5 | odbc.resourcer_1.0.0.tar.gz |
92.1 KiB |
1.0.0 |
latest source/ R- | odbc.resourcer_1.0.0.tar.gz |
12.2 KiB |
1.0.0 |
2026-04-26 source/ R- | odbc.resourcer_1.0.0.tar.gz |
12.2 KiB |
1.0.0 |
2026-04-23 source/ R- | odbc.resourcer_1.0.0.tar.gz |
12.2 KiB |
1.0.0 |
2026-04-09 windows/windows R-4.5 | odbc.resourcer_1.0.0.zip |
98.5 KiB |