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); }