locked
SAP BW no table in connection tab RRS feed

  • Question

  • Happy New Year all. I have successfully connected to a SAP BW environment via the data Factory.  However when I go to import a schema I get an error that I need to first select a table in the connections tab.  Do I need to edit the connection details in the JSOn format to specify a table?  So it would need a table name included somwwhere here:

    {
        "name": "SAP_SalesData",
        "properties": {
            "linkedServiceName": {
                "referenceName": "SapBw",
                "type": "LinkedServiceReference"
            },
            "folder": {
                "name": "SAP"
            },
            "type": "RelationalTable",
            "structure": [
                {
                    "name": "[0FISCYEAR].[LEVEL01].[MEMBER_CAPTION]",
                    "type": "Unsupported Type"
                },
                {
                    "name": "[0PROFIT_CTR].[LEVEL01].[MEMBER_CAPTION]",
                    "type": "Unsupported Type"
                },
                {
                    "name": "[0FISCPER].[LEVEL01].[MEMBER_CAPTION]",
                    "type": "Unsupported Type"
                },
                {
                    "name": "[Measures].[0COPAREVEN]",
                    "type": "Unsupported Type"
                },
                {
                    "name": "[Measures].[0G_QABSMG]",
                    "type": "Unsupported Type"
                }
            ]
        },
        "type": "Microsoft.DataFactory/factories/datasets"
    }

    Previously I had set up a connection to SAP BW using the SSIS SAP BW connector which had options to include Process Chain and OHS Destinations that is run in an Execution Mode of "Wait".  Is this still doable using the datafactory SAP BW connection?

    Thanks in Advance

    Binway


    Binway

    Tuesday, January 8, 2019 1:04 AM

Answers

  • Should in coming week.  I put some information here, you can have a quick look. 

    You can also reach me via wenbof@microsoft.com


    • Edited by wenbof Wednesday, January 9, 2019 9:01 AM Add more information
    • Marked as answer by Binway Wednesday, January 9, 2019 9:27 PM
    Wednesday, January 9, 2019 5:11 AM

All replies

  • Hi Binway.

    SAP BW doesn't support table name directly. You could write a query in copy activity source tab and then click "import schemas" in mapping tab if you want to do column mapping. Otherwise you don't need import schema in schema tab. 

    We will disable "import schema" button for SAP BW as it is not support. 

    Tuesday, January 8, 2019 3:14 AM
  • Thanks for that information.  Unfortunately I don't have much experience with SAP connections via the Data Factory - works fine with SSIS.

    Now that I have a succesful connection to SAP can you tell me what is the process to allow data to flow using the SAP Process Chain and OHS Destination parameters.  As an example do I change the value for "Type" in the example code below to "Process Chain" ?

    {
        "name": "SAPBWDataset",
        "properties": {
            "type": "RelationalTable",
            "linkedServiceName": {
                "referenceName": "<SAP BW linked service name>",
                "type": "LinkedServiceReference"
            },
            "typeProperties": {}
        }
    

    regards

    Binway


    Binway

    Tuesday, January 8, 2019 4:51 AM
  • We have a new connector for SAP Open Hub which is targeting to copy data out from Open Hub destination (Table) which looks to be align with what you need.  Full document is on the way, please stay tuned. 
    Tuesday, January 8, 2019 7:20 AM
  • The existing SAP BW connector you are using can only accept MDX query at present.
    Tuesday, January 8, 2019 7:24 AM
  • The new connector for Open Hub sounds good - do we know how long before it is available eg Days, Weeks.  Where would I find the documentation for this as well please.

    Binway

    Tuesday, January 8, 2019 9:53 PM
  • Should in coming week.  I put some information here, you can have a quick look. 

    You can also reach me via wenbof@microsoft.com


    • Edited by wenbof Wednesday, January 9, 2019 9:01 AM Add more information
    • Marked as answer by Binway Wednesday, January 9, 2019 9:27 PM
    Wednesday, January 9, 2019 5:11 AM
  • Thanks for the link.  I sent an email so you can connect if required.  I also had some questions about the values for ProcessChain etc that were in the SSIS SAP BW connector not being visible in the table in your document.  Are they no longer required?

    Binway

    Thursday, January 10, 2019 10:33 PM