Forum Discussion

pavan44's avatar
pavan44
New Contributor III
8 years ago

SnapLogic Integration with Microsoft Azure

Hi, After creating the SQL database in MS Azure, In SnapLogic when we actually provide the “Schema” and “Table” name for the AZURE SQL BULK EXTRACT Snap, it is providing me the error “Failure: BCP ...
pkona's avatar
pkona
Former Employee
7 years ago

The snap requires a field " BCP absolute path" that needs the

Absolute path of the BCP utility program in JCC’s file system. If empty, the Snap will look for it in JCC’s environment variable PATH.

  • srivera's avatar
    srivera
    New Contributor II
    7 years ago

    More specifically one needs to include the full path to the executable not just the containing directory. So for CentOS 7 ground plexes pleas enter,

    /opt/mssql-tools/bin/bcp

    This only works on groundplex(s). Which is odd, it could be pre-loaded on the cloudplex(s) as well.
    There does not appear to be such good documentation on installing MS SQL Tools on CentOS and configuring the groundplex to ensure that the the JCC runtime can see it.

    • srivera's avatar
      srivera
      New Contributor II
      7 years ago

      BTW, I did get this resolved but there appears to be an issue with the Snap. It fails if you use BigInt types in your SQLServer tables. See the ticket number 27858

    • pkona's avatar
      pkona
      Former Employee
      7 years ago

      Here is the link to the current documentation on Microsoft on installing the sqltools on linux. Its pretty straight forward

      This can be installed on any SnapLogic Groundplex

      • srivera's avatar
        srivera
        New Contributor II
        7 years ago

        Thanks. I believe that SnapLogic does itself a big disservice when it does not provide processes and procedures for installation and configuration. The point here is

        1. Snaplex(s) are your specific runtime and configuration on a specific OS (Windows, CentOS 7, etc)
        2. The specific commands , permissions, and configuration are specific to your environment and can be easily communicated to your customers.
        1. Sending customers to 3rd party sites for configuration is a bad customer experience. Your customer expect you to be the experts on the product that you sell and provide.

        Just my opinion.