title: How to link data from a Firebird database with a SQL Server database?
body: <p>I'm used to using SQL Server fairly often as part of my work to produce data for reporting. A new customer has data in both SQL Server and Firebird databases. I've never interacted with Firebird in anyway so this may seem a fairly simple question but what would be the best way to link data between the two systems? I'll need to build a small datamart to hold the linked data eventually as my end goal.</p>
  
  <p>I am aware the customer has Database Workbench installed for the client side of Firebird and I believe this will allow me to use SQL Server syntax on the FB databases but will it allow me to link data between the two and create new views in the SQL Server database with it? Obviously I know I can create a linked server in SQL Server Management Studio but I've had anecdotal advice that this can be difficult to configure potentially and if there's a simpler way then I'd prefer to go that way.</p>