Using an existing ODBC `con` object to connect to remote db
Open
@rich-iannone is already working on this.
Since Jan 6, 2023.
Type: ★ Enhancement
- Dominant language
- R
- Stars
- 1k
- Forks
- 59
- Avg merge
- 25m
- Merged PRs (30d)
- 4
Description
Prework
- Read and abide by pointblank's code of conduct and contributing guidelines.
- Search for duplicates among the existing issues (both open and closed).
Proposal
We've configured our Workbench to use an ODBC connection which means that the database details are configured on the system and the user really just needs to provide their username and pw credentials to connect to a database. When connecting, a con object is created. For those that are interested in using pointblank for accessing remote databases, it would be nice if the con object could be used in db_tbl rather than have to specify all the database properties.
pseudo-code
db_tbl(con, table = "schema.table", ...)
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.