Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://github.com/OHDSI/DatabaseConnector below:

OHDSI/DatabaseConnector: An R package for connecting to databases using JDBC.

DatabaseConnector is part of HADES.

This R package provides function for connecting to various DBMSs. Together with the SqlRender package, the main goal of DatabaseConnector is to provide a uniform interface across database platforms: the same code should run and produce equivalent results, regardless of the database back end.

• Create connections to the various database platforms:
  • MicrosoftSQL Server
  • Oracle
  • PostgresSql
  • Microsoft Parallel Data Warehouse (a.k.a. Analytics Platform System)
  • Amazon Redshift
  • Apache Impala
  • Google BigQuery
  • IBM Netezza
  • SQLite
  • Spark
  • InterSystems IRIS
• Statements for executing queries with
  • Error reporting to file
  • Progress reporting
  • Multiple statements per query
• Support for fetching data to Andromeda objects
• Insert data frame to a database table
• Supports the DBI interface, with SQL statements automatically translated to the appropriate dialect.
• Supports the dbplyr interface.
• Integrates with RStudio's Connections tab

connectionDetails <- createConnectionDetails(dbms="postgresql", 
                                             server="localhost",
                                             user="root",
                                             password="blah")
conn <- connect(connectionDetails)
querySql(conn,"SELECT COUNT(*) FROM person")
disconnect(conn)

DatabaseConnector is an R package using Java's JDBC drivers and other DBI drivers.

Running the package requires R with the package rJava installed. Also requires Java 1.8 or higher.

1. See the instructions here for configuring your R environment, including Java.

2. To install the latest stable version, install from CRAN:

install.packages("DatabaseConnector")

1. Download the database drivers as described here.

2. (Optionally) To use Windows Authentication for SQL Server, download the authentication DDL file as described here.

Documentation can be found on the package website.

PDF versions of the documentation are also available:

• Vignette: Connecting to a database
• Vignette: Querying a database
• Vignette: Using DatabaseConnector through DBI and dbplyr
• Package manual: DatabaseConnector manual

• Developer questions/comments/feedback: OHDSI Forum
• We use the GitHub issue tracker for all bugs/issues/enhancements

Read here how you can contribute to this package.

DatabaseConnector is licensed under Apache License 2.0. The JDBC drivers fall under their own respective licenses.

DatabaseConnector is being developed in R Studio.

Stable. The code is actively being used in several projects.

• This project is supported in part through the National Science Foundation grant IIS 1251151.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4