O'Reilly logo

Connecting the Data by Angelo R. Bobak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 9

Creating our ETL Processes with SSIS

images

Now that we have completed our schema integration analysis and created our ETL specifications we can roll up our sleeves and actually start to build the processes that extract the transactional data from our source databases and load it into our ODS.

I reference an extra database implemented with MySQL with the assumption that you have created this database and gone through all the proper steps identified in earlier chapters to integrate the data, identify the data conflicts and create the ETL specifications for the ETL processes. I did this for three reasons:

1. I wanted the reader to actually ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required