title: Connect R to a SQL Server database engine
body: <p>At my work I have R-Studio (Microsoft R Open 3.2.5) installed and would like to connect to a Microsoft SQL Server database, to run scripts using the tables I have. </p>
  
  <p>Is there any chance that I can connect to a SQL Server database using Pentaho and then using the object Execute R-Script to make an OLAP Cube? 
  Do I need a package to connect SQL engine?
  What would be the steps to perform?</p>
  
  <p>I already have the snowflake arquitectura of the data base. With the fact table and the state tables. But I do not know where to start.</p>