public static string GetASConnectionString(ActionRequest request, JToken azureToken, string serverUrl)
{
string connectionString = $"Provider=MSOLAP;Data Source={serverUrl}";
Uri uri = new Uri(serverUrl);
string resource = "https://" + uri.Host;
var asToken = AzureTokenUtility.GetTokenForResource(request, azureToken, resource);
string asAccessToken = AzureUtility.GetAccessToken(asToken);
if (!string.IsNullOrEmpty(asAccessToken))
{
connectionString +=
$";Password={asAccessToken};UseADALCache=0";
}
try
{
Server server = new Server();
server.Connect(connectionString);
request.DataStore.AddToDataStore("ASConnectionString", connectionString, DataStoreType.Private);
return(connectionString);
}
catch (Exception ex)
{
throw ex;
}
}
public static string GetASConnectionString(ActionRequest request, JToken azureToken, string serverUrl)
{
if (string.IsNullOrEmpty(serverUrl))
{
throw new ArgumentNullException(nameof(serverUrl));
}
if (!Uri.IsWellFormedUriString(serverUrl, UriKind.Absolute))
{
throw new ArgumentException("Invalid URL specified for Analysis Services", nameof(serverUrl));
}
string connectionString = $"Provider=MSOLAP;Data Source={serverUrl}";
Uri uri = new Uri(serverUrl);
string resource = $"{Uri.UriSchemeHttps}://{uri.Host}";
var asToken = AzureTokenUtility.GetTokenForResourceFromExistingToken("as", request.Info.WebsiteRootUrl, azureToken, resource);
string asAccessToken = AzureUtility.GetAccessToken(asToken);
if (!string.IsNullOrEmpty(asAccessToken))
{
connectionString += $";Password={asAccessToken};UseADALCache=0";
}
Server server = null;
try
{
server = new Server();
server.Connect(connectionString);
server.Disconnect(true);
request.DataStore.AddToDataStore("ASConnectionString", connectionString, DataStoreType.Private);
return(connectionString);
}
catch
{
throw;
}
finally
{
if (server != null)
{
// In theory, we could end up here with a connected server object
if (server.Connected)
{
try
{
server.Disconnect(true);
}
catch { }
}
server.Dispose();
}
}
}