/// <summary>
/// Creates the data source.
/// </summary>
/// <param name="dataSourceName">Name of the _data source.</param>
/// <param name="dataSourceLocation">The _data source location.</param>
/// <param name="sqlServerName">Name of the _SQL server.</param>
/// <param name="dbName">Name of the _DB.</param>
/// <returns></returns>
public bool CreateDataSource(string dataSourceName, string dataSourceLocation, string sqlServerName, string dbName)
{
bool resVal;
var dataSourceDefinition = new DataSourceDefinition
{
Extension = "SQL",
ConnectString =
@"Data Source=" + sqlServerName +
@";Initial Catalog=" + dbName,
ImpersonateUserSpecified = true,
Prompt = null,
WindowsCredentials = true,
CredentialRetrieval = CredentialRetrievalEnum.Integrated,
Enabled = true
};
try
{
_reportsServerInstance2005.CreateDataSource(dataSourceName,
dataSourceLocation,
false,
dataSourceDefinition,
null);
resVal = true;
}
catch (Exception)
{
resVal = false;
}
return(resVal);
}
public void CreateDataSource(DataSource source)
{
DataSourceDefinition definition = new DataSourceDefinition();
definition.ConnectString = source.RSConnectionString;
definition.CredentialRetrieval = (CredentialRetrievalEnum)source.CredentialRetrieval;
if (source.UserName != null)
{
definition.UserName = source.UserName;
definition.Password = source.Password;
}
definition.Enabled = true;
definition.EnabledSpecified = true;
definition.Extension = "SQL";
definition.ImpersonateUser = false;
definition.ImpersonateUserSpecified = true;
definition.Prompt = null;
definition.WindowsCredentials = source.WindowsCredentials;
_proxy.CreateDataSource(
source.Name,
Util.FormatPath(source.TargetFolder),
source.Overwrite,
definition,
null);
}
private static void CreateDataSources(ReportingService2005 reportingService, string path)
{
if (reportingService == null)
{
throw new ArgumentNullException("reportingService");
}
if (string.IsNullOrEmpty(path))
{
throw new ArgumentException("path");
}
foreach (DataSourceItem dataSource in SetupDataSourceItems)
{
DataSourceDefinition def = new DataSourceDefinition();
def.ConnectString = dataSource.ConnectString;
switch (dataSource.CredentialsRetrieval)
{
case "Integrated":
def.CredentialRetrieval = CredentialRetrievalEnum.Integrated; break;
case "None":
def.CredentialRetrieval = CredentialRetrievalEnum.None; break;
case "Prompt":
def.CredentialRetrieval = CredentialRetrievalEnum.Prompt; break;
case "Store":
def.CredentialRetrieval = CredentialRetrievalEnum.Store; break;
}
def.Enabled = dataSource.Enabled;
def.EnabledSpecified = dataSource.EnabledSpecified;
def.Extension = dataSource.Extension;
def.ImpersonateUser = dataSource.ImpersonateUser;
def.ImpersonateUserSpecified = dataSource.ImpersonateUserSpecified;
def.OriginalConnectStringExpressionBased = dataSource.OriginalConnectStringExpressionBased;
def.Password = dataSource.Password;
def.Prompt = dataSource.Prompt;
def.UseOriginalConnectString = dataSource.UseOriginalConnectString;
def.UserName = dataSource.UserName;
def.WindowsCredentials = dataSource.WindowsCredentials;
string fullPath = string.Format(dataSource.Path, path);
string parent = TesterUtility.GetParentPath(fullPath);
reportingService.CreateDataSource(dataSource.Name, parent, true, def, null);
}
}
private static void CreateDataSource(ReportingService2005 reportingService, DataSourceItem dataSource)
{
if (reportingService == null)
{
throw new ArgumentNullException("reportingService");
}
if (dataSource == null)
{
throw new ArgumentNullException("dataSource");
}
DataSourceDefinition def = new DataSourceDefinition();
def.ConnectString = dataSource.ConnectString;
switch (dataSource.CredentialsRetrieval)
{
case "Integrated":
def.CredentialRetrieval = CredentialRetrievalEnum.Integrated; break;
case "None":
def.CredentialRetrieval = CredentialRetrievalEnum.None; break;
case "Prompt":
def.CredentialRetrieval = CredentialRetrievalEnum.Prompt; break;
case "Store":
def.CredentialRetrieval = CredentialRetrievalEnum.Store; break;
}
def.Enabled = dataSource.Enabled;
def.EnabledSpecified = dataSource.EnabledSpecified;
def.Extension = dataSource.Extension;
def.ImpersonateUser = dataSource.ImpersonateUser;
def.ImpersonateUserSpecified = dataSource.ImpersonateUserSpecified;
def.OriginalConnectStringExpressionBased = dataSource.OriginalConnectStringExpressionBased;
def.Password = dataSource.Password;
def.Prompt = dataSource.Prompt;
def.UseOriginalConnectString = dataSource.UseOriginalConnectString;
def.UserName = dataSource.UserName;
def.WindowsCredentials = dataSource.WindowsCredentials;
string parent = TesterUtility.GetParentPath(dataSource.Path);
ReportingService2005TestEnvironment.CreateFolderFromPath(reportingService, parent);
reportingService.CreateDataSource(dataSource.Name, parent, true, def, null);
}
public override bool Execute()
{
#if DEBUG
ReportingService2005 rs2005 = new ReportingService2005();
rs2005.Url = ReportServerUrl;
rs2005.UseDefaultCredentials = UseDefaultCredentials;
SortedList <string, string> ExistingDataSources = new SortedList <string, string>(StringComparer.InvariantCultureIgnoreCase);
if (!Overwrite)
{
foreach (CatalogItem item in rs2005.ListChildren(TargetFolder, false))
{
if (item.Type == ItemTypeEnum.DataSource)
{
ExistingDataSources[item.Name] = item.Name;
}
}
}
foreach (ITaskItem ds in DataSources ?? new ITaskItem[0])
{
XPathDocument doc = new XPathDocument(ds.ItemSpec);
XPathNavigator nav = doc.CreateNavigator();
nav.MoveToRoot();
DataSourceDefinition dsd = new DataSourceDefinition();
dsd.CredentialRetrieval = CredentialRetrievalEnum.Integrated;
dsd.Enabled = true;
dsd.EnabledSpecified = true;
dsd.Prompt = null;
dsd.WindowsCredentials = false;
foreach (XPathNavigator n in nav.Select("/RptDataSource/ConnecionProperties/*"))
{
typeof(DataSetDefinition).InvokeMember(n.LocalName, System.Reflection.BindingFlags.SetProperty, null, dsd, new object[] { n.Value }, CultureInfo.InvariantCulture);
}
rs2005.CreateDataSource(nav.SelectSingleNode("/RptDataSource/Name").Value, TargetFolder, Overwrite, dsd, null);
}
#endif
return(true);
}
public string createDataSource(string name, string parent, string conecstring, bool overWrite)
{
try
{
//check exist data source
if (CheckExist(ItemTypeEnum.DataSource, parent, name) && !overWrite)
{
return(String.Format("Datasource {0} is already exist", name));
}
//create datasource definition
DataSourceDefinition definition = createDataSourceDefinition(conecstring);
//create data source
rs.CreateDataSource(name, parent, overWrite, definition, null);
return("");
}
catch (Exception ex)
{
return(ex.Message);
}
}
private void CreateDataSource(string location)
{
Property prop = new Property();
prop.Name = "Description";
prop.Value = "Data source for SQLsecure Reports.";
// Define the data source definition.
DataSourceDefinition definition = new DataSourceDefinition();
definition.CredentialRetrieval = CredentialRetrievalEnum.Store;
definition.ConnectString = "data source=" + _drd.Repository + ";initial catalog=SQLsecure";
definition.Enabled = true;
definition.EnabledSpecified = true;
definition.Extension = "SQL";
definition.UserName = _drd.UserName;
definition.Password = _drd.Password;
definition.Prompt = null;
definition.WindowsCredentials = true;
_rs.CreateDataSource("SQLsecure Data Source", location, true, definition, new Property[] { prop });
}
public void CreateDataSource(Datasource datasource, string parent)
{
var dataSourceDefinition = new DataSourceDefinition
{
ConnectString = datasource.ConnectionString,
Enabled = datasource.Enabled,
Extension = datasource.Extension,
Password = datasource.Password,
Prompt = datasource.Prompt,
UserName = datasource.Username,
ImpersonateUser = datasource.SetExecutionContext,
WindowsCredentials =
datasource
.UsePromptedCredentialsAsWindowsCredentials ||
datasource.UseStoredCredentialsAsWindowsCredentials,
CredentialRetrieval =
GetSSRSCredentialRetrievalTypeFromEnum(
datasource.CredentialRetrievalType)
};
webserviceProxy.CreateDataSource(datasource.Name, parent, true, dataSourceDefinition, null);
}