Status codes in MySQL - Execute snap
Hello Team, Need your help in understanding the meaning of different status codes received in the MySQL - Execute snap’s output. We had a scenario where we were trying to insert multiple records into MySQL DB and we have noticed a strange response related to status codes received in the output. Though all the records were successfully added, we received different status codes for different records. Please find below screenshot of the response from MySQL - Execute snap response. We don’t see anything related to the status code information of SQL snaps in the snaplogic documentation. Can you please help us in understanding the meaning of different status codes in SQL snaps. Thanks, Ravi SRabbitMQ Consumer to MySQL
Created by Chris Ward, SnapLogic This pipeline consumes messages from a RabbitMQ queue and writes them to a MySQL Database and acknowledges or rejects the message dependent on the delivery. It could be used for a use case where theres need to stream messages in real time and to write the content to a relational database for further consumption. Configuration Sources: RabbitMQ message Targets: MySQL Table Snaps used: RabbitMQ Consumer, Binary to Document, MySQL Insert, Mapper, RMQ Message Reject, RMQ, JSON Formatter, File Writer Downloads RabbitMQ_to_MySQL.slp (17.6 KB)
Creating File in NetSuite File Cabinet using NetSuite Create Snap
I have various types of binary files such as word document, Excel, PDF, images etc. stored in MySQL DB as blob storage. I am transferring this files to NetSuite File Cabinet using NetSuite Create snap and selecting File as record type. The problem is that when I run the snap, it is only creating partial files on NetSuite. For e.g. I have one PDF file of 21KB but on NetSuite it is only creating PDF file with size of 6Bytes hence it is a corrupted file. How do I make sure the file is getting transferred correctly from MySQL blob to NetSuite File cabinet?Unable to connect to SnapLogic MySQL to AWS MySQL instance but able to connect to that instance in AWS environment
Hi Team, When tried to connect to mySQL select in Snaplogic with instance in AWS account getting below mentioned error. Failed to validate account: Failed to retrieve a database connection. Cause: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. (Reason: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.; Resolution: Address the reported issue.) Screenshot attached here for the reference. Any immediate help here will be appreciable.
MySQL to Snowflake
Created by @pavan Moving relational data (order) in MySQL to Snowflake data warehouse, and later can run analytics on how many orders were fulfilled. Configuration Sources: MySQL Order Targets: Snowflake Snaps used: MySQL, Mapper, Snowflake Bulk Load Downloads MySQL to Snowflake.slp (5.8 KB)
MS SQL Bulk Insert
is there a way to perform a bulk insert operation to insert data into MS SQL? currently we have a pipeline that has about 3.5M records / documents. It takes a long time to insert all of these into SQL using the execute snap b/c I believe its performing an insert document by document. Any help is appreciated.Using the Salesforce Attachment Snap to download and insert into MySQL
Attached is a sample pipeline that connects to a Salesforce Object, downloads an attachment and inserts it into MySQL. Since the object already exists in Salesforce there is no need for a create script, but there is a script to create a sample table in MySQL. To use: Use the attached script to create a table in MySQL set a salesforce account to the Salesforce SOQL Snap set a MySQL account to the MySQL - Insert Snap and select the schema and table preview the pipeline to confirm all setting are correct, minor adjustments to the fields in the Salesforce SOQL may be required, but it should work as is in most cases. run the pipeineCreate_sf_attachment_table_in_Msql.csv.zip (861 Bytes) get sf attachments and insert into mysql_2017_02_28.slp (6.0 KB)
Connect to local database to test Snaplogic pipelines
This example uses MySQL installed on developer’s laptop Install MySql DB on you local machine Login to you ISP’s router Enable port forwarding fro the specific port - (the default for MySQL is 3306) Login to Snaplogic Create a MySQL account and Fill in the account properties. for hostname, type in you local machine’s IP address (Google what’s my IP) . Choose the default port number 3306 for MySQL or the same port number you specified on step 3. Click Validate. If the accounts validates, they you can proceed and create you pipeline. If not make sure the port forwarding is enabled and the local MySQL DB is started.
