5 Replies Latest reply on Jul 16, 2017 10:24 PM by sankara rao

    Informatica cloud connection issue with Azure dataware house

    sankara rao New Member

      i am facing issue while trying to move the data from Azure data warehouse to another Azure data warehouse.

      I am getting the below error.

      READER_1_1_1> JAVA PLUGIN_1762 [2017-06-28 18:49:59.929] [ERROR] com.informatica.powercenter.sdk.SDKException: com.informatica.cloud.api.adapter.runtime.exception.ReadException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'HADOOP'.

      at com.informatica.cloud.adapter.azuredw.runtime.read.AzureDWRead.read(AzureDWRead.java:97)

      at com.informatica.cloud.api.adapter.reader.runtime.GenericRdrPartitionDriver.run(Unknown Source).

      can anyone please help me on this?

       

      The Azure datawarehouse connection is showing as successfu; and while configuring the source in the data sync job in informatica cloud , i am able to fetch the data.But while running the job encountering error.