Recent Discussions
SFTP: Worked ok then settings changed not not working
We have set up a new SFTP site and we had access to it via Snap – read, write, delete. All was good. We had to change some settings for our client to access it and now SnapLogic cannot connect. I’m getting “Unable to create filesystem object for sftp://xxxxxxx/xxxx/xxx”. I’m using a directory browser to test the connections. I’m able to connect with the same user and password via command line. I made sure the connection string is accurate. Any thoughts? Thanks, Bob
SQS Consumer snap is ready all message at pipeline startup
Hi, I have certain observations while running a pipeline with SQS snap as trigger. 1. On startup, pipeline reads all available messages from sqs and hold them in buffer and process them as per concurrency 2. There is no mechanism to control the speed at which we poll messages from queue. If you have used sqs consumer snap in your pipelines, how did you tackle above issues. Any throttling mechanism did you implement to control this. Thanks, Vishal.
Using Windows Authentication with SQL Server Accounts
The topic of "providing windows ID / Password to SQL Server has come up a few different times so below is a solution that I found to work in most instances. Scenario: Service accounts with Native SQL Server authentication is NOT supported (internal security rules, regulatory compliance etc.) Running SnapLogic using “IntegratedSecurity = true” would require every database to grant access to an individual robot / service account and didn’t allow specific user tracking Solution: 3rd party JDBC driver called jtds (http://jtds.sourceforge.net/) allows you to specify URL Properties and pass in account credentials. You will need to upload this jar file into the SLDB and reference that within the account settings (see screen caps below). On the SQL Server, you can see Windows Authentication selection for ID “SQLSvr_TESTING” Account settings within SnapLogic for “SQL Server Account” type: Account settings that need to be defined Referencing the JAR files uploaded to the SLDB The JDBC Driver Class should be set to net.sourceforge.jtds.jdbc.Driver URL Properties Defined: useNTLMv2 = true domain = [YourDomain] instance = [InstanceName-OPTIONAL] NOTE : It’s important to stipulate that if the users windows password changes, they will need to come into SnapLogic and adjust the password in the account as well. By default, the SQL Server snaps will attempt to reconnect 3 times so you may get into a situation where the ID becomes locked out.
SFTP errors
FYI I was getting errors with pipelines using a directory browser with a basic auth account for SFTP. After doing some testing and verifying the authentication details I ended up rolling back the Binary Snap Pack version to Main19844. Problem was resolved - must be a bug in new version. The error I was getting is Failure: Unable to create filesystem object for sftp://sftp.accorplus.com:2222/, Reason: Failed to get SFTP session connected, Resolution: Please check all properties and credentialsDownload Multiple files/ or view in the browser
how can i download multiple files using a rest get where by in the url i passed split values of different files, the response shows there are four files however when executing the pipeline as triggered task , only the first file gets downloaded this is the final out put of the mapperDifference among SAP, SAP S/4hana and SAP S/4hana cloud snap packs
Hello, We are working on collating some information on SAP snap packs and related ones. Can anyone from snaplogic community help explaining the differences among SAP, SAP S/4hana and SAP S/4hana cloud snap packs ? Any kind of help is appreciated. Thank you!PostgreSQL Bulk Upload
Is there a way to remove the PRIMARY_KEY from insert query getting triggered from PostgreSQL Bulk Load Snap. Issue is when the Snaplogic trying to insert data into postgreSQL the PRIMARY_COLUMN is going as NULL which is causing while inserting record into postgreSQL database. NOTE: If we remove the ID column which is the primary from been serialized than it will be auto generated as it is set as AUTO INCREMENT. I tried mapper as well to remove the ID column to not included in INSERT query but it didn't worked out. Any suggestions from anyone.
