Five steps to build a semantic integration framework to support a federated query environment through two working illustrations. First, Dean outlines a project to integrate several large datasets in service of drug discovery from both internal and public sources (e.g., bio2rdf). The result is a "linked data cloud", where adding new datasets is as easy as describing them. Secondly, Dean details the building of an RDF-based reporting hub for the Oil and Gas Industry to provide semantic-based reporting on day-to-day oil production activities in the North Sea. These reports require scalable data integration capabilities, which are delivered in a standards-based way with Semantic Web technology.