To learn details about the properties, check Lookup activity. See Schema and data type mappings to learn about how copy activity maps the source schema and data type to the sink. When copying data from SAP BW, the following mappings are used from SAP BW data types to interim data types used internally within the service. If you were using RelationalSource typed source, it is still supported as-is, while you are suggested to use the new one going forward. Specifies the MDX query to read data from the SAP BW instance. The type property of the copy activity source must be set to: SapBwSource To copy data from SAP BW, the following properties are supported in the copy activity source section: Property This section provides a list of properties supported by SAP BW source. Copy activity propertiesįor a full list of sections and properties available for defining activities, see the Pipelines article. If you were using RelationalTable typed dataset, it is still supported as-is, while you are suggested to use the new one going forward. While there are no type-specific properties supported for the SAP BW dataset of type RelationalTable. To copy data from SAP BW, set the type property of the dataset to SapBwCube. This section provides a list of properties supported by SAP BW dataset. A Self-hosted Integration Runtime is required as mentioned in Prerequisites.įor a full list of sections and properties available for defining datasets, see the datasets article. The Integration Runtime to be used to connect to the data store. Mark this field as a SecureString to store it securely, or reference a secret stored in Azure Key Vault. Name of the user who has access to the SAP server. Allowed value: three-digit decimal number represented as a string. Allowed value: two-digit decimal number represented as a string.Ĭlient ID of the client in the SAP W system. Name of the server on which the SAP BW instance resides. The following properties are supported for SAP Business Warehouse (BW) linked service: Property The following sections provide details about properties that are used to define Data Factory entities specific to SAP Business Warehouse connector. Search for SAP and select the SAP BW via MDX connector.Ĭonfigure the service details, test the connection, and create the new linked service.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |