R Tutorial – How to Connect to SteemSQL via RStudio?

R-studio

Last month, in my R tutorial, I showed you how to connect to SteemSQL in R script. The latest R Studio has added a connection tab, which is a Database wizard that you can easily follow to connect to STEEMSQL.

R-steemsql-connection-studio-1

And, if we click the ‘New Connection’, choose ODBC.

R-connect-to-existing-data-sources

Most likely, you will have to install the package ‘ODBC’ on the fly.

R-install-package

You can either choose ‘SQL Server’ or ‘SQL Server Native Client 11.0’ from the ‘Data Sources’

R-connecting-to-mssql

And enter the Parameters textbox as the following values:

Server=sql.steemsql.com;Database=DBSteem;Uid=steemit;Pwd=steemit

R-steemsql-parameters

You can test the connection before you proceed further.

R-testing-connection

If you connect from ‘R Console’, the DBSteem object from SteemSQL will immediately become available.

R-steemsql

R Tutorial

• R Tutorial – Map, Filter, Reduce, Lambda
• R Tutorial – Monte Carlo
• R Tutorial – Permutation
• R Tutorial – Sigmoid
• R Tutorial – Connecting to STEEMSQL via RODBC
• R Tutorial – How rich is SteemIt Wechat Group?
• R Tutorial – Knowing when a Steem Whale vote?
• R Tutorial – How to Connect to SteemSQL via RStudio?
• R Tutorial – Using R to Fit Linear Model – Predit Weight over Height

You may also like: R 教程之通过 RStudio 来快速连接SteemSQL

–EOF (The Ultimate Computing & Technology Blog) —