title: How Can I connect to this OData Feed in SSIS
body: <p>I have access to a corporate OData feed, but I can only to connect to it from specific applications. (PowerBI, Excel and LinqPad)</p>
  
  <p>The connection details I have, are a URL and Basic Auth Username and Password. However, I know the feed is stored in Azure (not sure which part...) and I think I need some other kind of Authentication to connect. </p>
  
  <p>I am using the latest version of SQL Data Tools and Visual Studio 2015 U2. I have tried using the built in OData connection manager with all of the possible Auth Types and the user/pass i was given with no luck. (Windows Auth, Basic Auth, Microsoft Dynamics AX Online, Microsoft Dynamics CRM Online, Microsoft Online Services)</p>
  
  <p>What confuses me, is why it works fine in LinqPad, Excel and PowerBI but i can't get SSIS to connect. Which i need for data automation!</p>
  
  <p>I have attempted to get the connection string from LinqPad using <a href="https://stackoverflow.com/questions/25360921/how-can-i-get-the-connection-string-for-an-sql-express-database-listed-in-linqpa/" title="here">this</a> but I get an error about UserQuery not having a property Connection. Which may be something to do with Entity Framework?</p>
  
  <p>Does anyone know any tips or tricks to get this working?</p>