public void create_new_azure_key_vault_linked_service_using_key_vault_to_store_account_key()
{
const string expectedData =
"{\"name\":\"ls_kv_groupdwh_test_001\",\"type\":\"Microsoft.DataFactory/factories/linkedservices\",\"properties\":{\"description\":\"Azure Key Vault kv-groupdwh-test-001\",\"annotations\":[],\"type\":\"AzureKeyVault\",\"typeProperties\":{\"baseUrl\":\"https://kv-groupdwh-test-001.vault.azure.net/\"}}}";
var linkedService = AzureLinkedService
.As(AzureServiceType.AzureKeyVault, "ls_kv_groupdwh_test_001", "Azure Key Vault kv-groupdwh-test-001")
.BaseUrl("https://kv-groupdwh-test-001.vault.azure.net/")
.ToJson(JsonSerializer.MinifiedSettings)
.ToString();
Console.WriteLine("Expected \n\n{0}\n", JsonSerializer.FormatJson(expectedData));
Console.WriteLine("Actual \n\n{0}\n", JsonSerializer.FormatJson(linkedService));
StringAssert.AreEqualIgnoringCase(expectedData, linkedService);
}
public void create_new_sql_server_linked_service_with_encrypted_credentials()
{
const string expectedData =
"{\"name\":\"ls_sqldb_groupdwh_test_001\",\"type\":\"Microsoft.DataFactory/factories/linkedservices\",\"properties\":{\"description\":\"Test SQL Service\",\"annotations\":[],\"type\":\"SqlServer\",\"typeProperties\":" +
"{\"connectionString\":\"integrated Security=False;Encrypt=True;Connection Timeout=30;Data Source=mydbserver.database.windows.net;Initial Catalog=mydbname;User ID=mydbusername\",\"encryptedCredential\":\"my.encrypted.credentials\"}}}";
var linkedService = AzureLinkedService
.As(AzureServiceType.SqlServer, "ls_sqldb_groupdwh_test_001", "Test SQL Service")
.ConnectionString("integrated Security=False;Encrypt=True;Connection Timeout=30;Data Source=mydbserver.database.windows.net;Initial Catalog=mydbname;User ID=mydbusername")
.EncryptedCredentials("my.encrypted.credentials")
.ToJson(JsonSerializer.MinifiedSettings)
.ToString();
Console.WriteLine("Expected \n\n{0}\n", JsonSerializer.FormatJson(expectedData));
Console.WriteLine("Actual \n\n{0}\n", JsonSerializer.FormatJson(linkedService));
StringAssert.AreEqualIgnoringCase(expectedData, linkedService);
}
public void create_new_azure_blob_store_linked_service_using_key_vault_to_store_account_key()
{
const string expectedData = "{\"name\":\"ls_dlsgroupdwhtest001\",\"type\":\"Microsoft.DataFactory/factories/linkedservices\",\"properties\":{\"description\":\"Azure Blob Service dlsgroupdwhtest001\",\"annotations\":[],\"type\":\"AzureBlobStorage\",\"typeProperties\":" +
"{\"connectionString\":\"DefaultEndpointsProtocol=https;AccountName=dlsgroupdwhtest001;\",\"accountKey\":{\"type\":\"AzureKeyVaultSecret\",\"store\":" +
"{\"referenceName\":\"ls_kv_groupdwh_test_001\",\"type\":\"LinkedServiceReference\"},\"secretName\":\"dlsgroupdwhtest001\"}}}}";
var linkedService = AzureLinkedService
.As(AzureServiceType.AzureBlobStorage, "ls_dlsgroupdwhtest001", "Azure Blob Service dlsgroupdwhtest001")
.ConnectionString("DefaultEndpointsProtocol=https;AccountName=dlsgroupdwhtest001;")
.UsingSecret("dlsgroupdwhtest001")
.AccountKeyFromKeyVault("ls_kv_groupdwh_test_001")
.ToJson(JsonSerializer.MinifiedSettings)
.ToString();
Console.WriteLine("Expected \n\n{0}\n", JsonSerializer.FormatJson(expectedData));
Console.WriteLine("Actual \n\n{0}\n", JsonSerializer.FormatJson(linkedService));
StringAssert.AreEqualIgnoringCase(expectedData, linkedService);
}
public void create_new_sql_server_linked_service_with_integration_runtime_and_key_vault_password()
{
const string expectedData =
"{\"name\":\"ls_sqldb_groupdwh_test_001\",\"type\":\"Microsoft.DataFactory/factories/linkedservices\",\"properties\":{\"description\":\"Test SQL Service\",\"annotations\":[],\"type\":\"SqlServer\",\"typeProperties\":" +
"{\"connectionString\":\"integrated Security=False;Encrypt=True;Connection Timeout=30;Data Source=mydbserver.database.windows.net;Initial Catalog=mydbname;User ID=mydbusername\",\"password\":" +
"{\"type\":\"AzureKeyVaultSecret\",\"store\":{\"referenceName\":\"ls_kv_groupdwh_test_001\",\"type\":\"LinkedServiceReference\"},\"secretName\":\"TheDataCrewbi\"}},\"connectVia\":{\"referenceName\":\"df-ir-dev-hgbwm222-001\",\"type\":\"IntegrationRuntimeReference\"}}}";
var linkedService = AzureLinkedService
.As(AzureServiceType.SqlServer, "ls_sqldb_groupdwh_test_001", "Test SQL Service")
.ConnectionString("integrated Security=False;Encrypt=True;Connection Timeout=30;Data Source=mydbserver.database.windows.net;Initial Catalog=mydbname;User ID=mydbusername")
.UsingSecret("TheDataCrewbi")
.PasswordFromKeyVault("ls_kv_groupdwh_test_001")
.ConnectVia("df-ir-dev-hgbwm222-001")
.ToJson(JsonSerializer.MinifiedSettings)
.ToString();
Console.WriteLine("Expected \n\n{0}\n", JsonSerializer.FormatJson(expectedData));
Console.WriteLine("Actual \n\n{0}\n", JsonSerializer.FormatJson(linkedService));
StringAssert.AreEqualIgnoringCase(expectedData, linkedService);
}
