23994_sqlsaturday_395_mongodb_intro_20150508.pptx

MongoDB for SQL Developers

Ben Galluzzo www.BenGalluzzo.com @BenGalluzzo [email protected]

SQL Saturday #395 – Baltimore - BI Edition 2015

Introduction

2 |

SQL Saturday #395 – Baltimore - BI Edition 2015

Introduction

3 |

SQL Saturday #395 – Baltimore - BI Edition 2015

MongoDB Introduction

4 |

SQL Saturday #395 – Baltimore - BI Edition 2015

MongoDB for SQL Developers         5 |

MongoDB Overview MongoDB to SQL terminology MongoDB Operations Development environment overview MongoDB Operations (demo) SSIS - MongoDB to SQL Server (demo) SSIS - Disparate Documents (demo) Resources SQL Saturday #395 – Baltimore - BI Edition 2015

MongoDB Overview  Who uses MongoDB     

6 |

Weather Channel ADP Expedia SourceForge Bosch

SQL Saturday #395 – Baltimore - BI Edition 2015

MongoDB Overview  Features of MongoDB     

7 |

document-oriented database not strongly typed (structure not enforced) server-side JavaScript execution interoperates nicely with applications (JSON) offers load balancing (multiple servers)

SQL Saturday #395 – Baltimore - BI Edition 2015

MongoDB Overview  Reasons for using MongoDB (or NoSQL)  High amount of data having low value  Social networking comments  Log data

 Document Storage  Cached Data  Unstable Schema

8 |

SQL Saturday #395 – Baltimore - BI Edition 2015

MongoDB to SQL Terminology MongoDB

SQL

database

database

collection

table

document

record (row)

field

column

linking/embedded documents

join

primary key (_id field)

primary key (user designated)

index

index

9 |

SQL Saturday #395 – Baltimore - BI Edition 2015

MongoDB Operations  INSERT  db..insert( { .... } )

 SELECT  db..find()

 UPDATE  db..update( { .... } )

 DELETE  db..remove( { .... } )

10 |

SQL Saturday #395 – Baltimore - BI Edition 2015

Development Environment Overview    

11 |

MongoDB MongoDB CSharp driver Register driver dll’s Visual Studio BIDS/SSDT

SQL Saturday #395 – Baltimore - BI Edition 2015

MongoDB Operations

DEMO

12 |

SQL Saturday #395 – Baltimore - BI Edition 2015

SSIS - MongoDB to SQL Server

DEMO

13 |

SQL Saturday #395 – Baltimore - BI Edition 2015

SSIS – Disparate Documents

DEMO

14 |

SQL Saturday #395 – Baltimore - BI Edition 2015

Resources  MongoDB Utilities  MongoVue  http://simplybusiness.github.io/mongosis/

 RoboMongo  http://robomongo.org/

 MongoDB SSIS Components  Mongosis  http://simplybusiness.github.io/mongosis/

15 |

SQL Saturday #395 – Baltimore - BI Edition 2015

Additional Resources  Installing MongoDB  Installation Package  http://www.mongodb.org/downloads

 Installation Notes  http://docs.mongodb.org/manual/tutorial/install-mongodb-on-windows/

 CSharp Driver (v1.8.3)  https://github.com/mongodb/mongo-csharp-driver/releases?after=v1.9.2

 BIDS/SQL Server Data Tools (SSDT)  For Visual Studio 2012  https://www.microsoft.com/en-us/download/details.aspx?id=36843

 SSDT Notes  https://msdn.microsoft.com/en-us/data/tools.aspx 16 |

SQL Saturday #395 – Baltimore - BI Edition 2015

Thanks to our Sponsors: Platinum Sponsors:

Gold Sponsors:

Silver Sponsors:

Bronze Sponsors:

Visit Local User Groups:

17 |

SQL Saturday #395 – Baltimore - BI Edition 2015

MongoDB for SQL Developers

Ben Galluzzo www.BenGalluzzo.com @BenGalluzzo [email protected]

SQL Saturday #395 – Baltimore - BI Edition 2015