private void UploadReportDataSources(ReportingService2010SoapClient reportingServicesClient, TrustedUserHeader userHeader, string artifactsFolderPath)
{
foreach (var dataSourceDefinitionFile in Directory.GetFiles(artifactsFolderPath, String.Format("*{0}", DataSourceFileExtension)))
{
string itemName = Path.GetFileNameWithoutExtension(dataSourceDefinitionFile);
CatalogItem dataSetItem = null;
DataSourceDefinition definition = DataSourceDefinitionParser.Parse(File.OpenRead(dataSourceDefinitionFile));
Console.WriteLine("Uploaded report data source '{0}'", itemName);
reportingServicesClient.CreateDataSource(userHeader, itemName, "/", true, definition, null, out dataSetItem);
}
}
private void UploadReportDataSources(ReportingService2010SoapClient reportingServicesClient, TrustedUserHeader userHeader, string artifactsFolderPath)
{
foreach (var dataSourceDefinitionFile in Directory.GetFiles(artifactsFolderPath, String.Format("*{0}", DataSourceFileExtension)))
{
string itemName = Path.GetFileNameWithoutExtension(dataSourceDefinitionFile);
CatalogItem dataSetItem = null;
DataSourceDefinition definition = DataSourceDefinitionParser.Parse(File.OpenRead(dataSourceDefinitionFile));
Console.WriteLine("Uploaded report data source '{0}'", itemName);
reportingServicesClient.CreateDataSource(userHeader, itemName, "/", true, definition, null, out dataSetItem);
}
}
private void CreateDataSource(string parentFolder, string subFolder, string dataSourceName, string dataSourceConnectionString, string dataSourceUserName, string dataSourcePassWord)
{
var definition = new DataSourceDefinition
{
CredentialRetrieval = CredentialRetrievalEnum.Store,
ConnectString = dataSourceConnectionString,
Enabled = true,
EnabledSpecified = true,
Extension = "SQL",
ImpersonateUser = false,
ImpersonateUserSpecified = true,
Prompt = null,
WindowsCredentials = false,
UserName = dataSourceUserName,
Password = dataSourcePassWord
};
Log("Creating data source {0} with value: {1} in /{2}/{3}", dataSourceName, dataSourceConnectionString, parentFolder, subFolder);
reportingServicesClient.CreateDataSource(new CreateDataSourceRequest {
DataSource = dataSourceName, Parent = $"/{parentFolder}/{subFolder}", Overwrite = true, Definition = definition
});
Log("Created data source {0}", dataSourceName);
}
