Enhances Interaction with 'ODBC' Databases
Simple and Powerful ODBC Interfaces
Broadcast a Command to All Data Sources
Configuration Files
Creates Data Source Interfaces
Close Connections and Deactivate the Package
Control and Communication Parameters
Hybrid Script Syntax
Define New Data Sources
List Data Sources and their Interfaces
How to Use the Interface Functions
Provides simple and powerful interfaces that facilitate interaction with 'ODBC' data sources. Each data source gets its own unique and dedicated interface, wrapped around 'RODBC'. Communication settings are remembered between queries, and are managed silently in the background. The interfaces support multi-statement 'SQL' scripts, which can be parameterised via metaprogramming structures and embedded 'R' expressions.