locked
Getting error Linked service MySQLAzureDB is not of a type that contains a connection string. while creating HDInsightOnDemandCluster RRS feed

  • Question

  • I am trying to generate HDInsightOnDemandCluster using below json.

    {
        "name": "HDInsightOnDemandCluster",
        "properties":
        {
            "type": "HDInsightOnDemandLinkedService",
            "clusterSize": 4,
            "timeToLive": "00:05:00",
            "linkedServiceName": "MySQLAzureDB"
        }
    }

    and i am getting below error

    "Linked service MySQLAzureDB is not of a type that contains a connection string."

    Scenario- I want to read table data from Azure Sql db process it using C# custom activity and then store it back to another Azure sql table.

    Wednesday, January 7, 2015 6:34 AM

Answers

  • Hi,

    The linkedServiceName you are pointing to must be of type Azure Blob Storage. It will be used to copy all the logs and supporting files for your on demand Hadoop cluster.

    Later inside your custom activity you will be able to refer to the SQL DB linked service as you will define it as an input to your activity.

    Hope it helps.

    Thanks, Tomer [MSFT].

    • Proposed as answer by TomerW Monday, January 12, 2015 4:39 PM
    • Marked as answer by TomerW Friday, February 6, 2015 9:44 PM
    Monday, January 12, 2015 4:39 PM