title: How to connect to GoodData ADS using Microsoft .NET
body: <p>We have an emerging need to modify the schema in our Agile Data Warehouse including adding new tables. We've been able to manually connect to the ADS database using Squirrel SQL and CloudConnect.</p>
  
  <p>However, we would like a way to automate this process so that we can ensure that the schema remains consistent between our development, test and production ADS instances.</p>
  
  <p>We're a .NET shop and most of our code is in C#. Has anyone had any success connecting directly to ADS using .NET (C# or VB)?</p>
  
  <p>I've looked at trying to use the GoodData JDBC driver but it looks like referencing a JDBC driver from .NET is not particularly straight-forward and there is not a GoodData ODBC or ADO.NET driver available.</p>
  
  <p>I'd rather use something like the Vertica driver for ADO.NET available at <a href="https://my.vertica.com/vertica-client-drivers/" rel="nofollow">https://my.vertica.com/vertica-client-drivers/</a> however, I'm not sure what to use for all of the <a href="https://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/ConnectingToHPVertica/ClientADO/ADO.NETConnectionProperties.htm" rel="nofollow">connection properties</a>.  I've attempted to connect using the Host and Port that are returned from the DW connection endpoints API but receive the following error: "SSL Startup Failed." when using the Vertica ADO.NET driver.</p>
  
  <p>Is there a way to connect to the GoodData ADS daatabase using .NET or any better approaches to modifying the ADS schema using a CloudConnect graph or REST API?</p>
  
  <p>Any advice would be appreciated.</p>