SnapLogic Integration with Microsoft Azure

[pavan44]

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 program not found, Reason: Could not find BCP program in system path”.

Can you please help me to set or resolve the BCP Path here. Is there any path that I can get it from MS Azure SQL DB?.

Thanks

[pkona]

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

docs.microsoft.com

Install SQL Server command-line tools on Linux - SQL Server

Learn how to install the SQL Server command-line tools, Microsoft ODBC drivers, and their dependencies on Linux.

This can be installed on any SnapLogic Groundplex

[srivera]

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.

3. 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.