将数据从SQL Server导入到R

本文介绍了将数据从SQL Server导入到R的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我正在尝试将数据从SQL Server导入R.为我提供了SQL Server数据库的服务器名称，用户名和密码.我已经在R中安装了RODBC.但是我不知道如何编写odbcConnect搜索，因为我的计算机上没有数据库，而且我只知道服务器名称.在这种情况下我该怎么办?谢谢！

I'm trying to import data from SQL Server to R. I was given the server name, user name and password to the SQL Server database. I've installed RODBC in R. But I don't know how to write the odbcConnect search as I don't have the database on my computer and I only know the server name. What should I do in such a situation? Thanks!

推荐答案

这是使用 DBI + odbc 包的典型SQL Server连接:

This is a typical SQL Server connection using DBI+odbc packages :

library(DBI)
conn <- DBI::dbConnect(
    odbc::odbc(),
    Driver = "SQL Server",
    Server = "ServerName",
    Database = "DatabaseName",
    uid = "UserName",
    pwd = "Password",
    options(connectionObserver = NULL)
  )

data <- dbGetQuery(conn, "SELECT * FROM ...")

DBI 是 R Studio推荐的和比RODBC快.为对此进行检查.

这篇关于将数据从SQL Server导入到R的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！