SnapLogic - Integration Nation

anivtk · 09-29-2020

Hi, I am reading some table data from a SQL Server (‘SQL Server - Execute’ snap) and writing the output to a text file (‘File Writer’ snap) (using a ‘CSV formatter’ between he above snaps) ‘SQL Server - Execute’ → ‘CSV formatter’ → ‘File Writer’ Req...

anivtk · 12-09-2019

I have a requirement to move/copy many files (1000s of files) to Google Storage. I did some reading in SnapLogic documentation and saw that we might have to use “Google BigQuery Bulk Load (Cloud Storage)” for this. Is this correct understanding? Any...

anivtk · 09-30-2020

This is great, met my requirements, thanks for your quick response!

anivtk · 02-22-2020

Check this link too… Converting Varchar data into Datetime - #11 by anivtk

anivtk · 02-21-2020

Awesome, this worked! Thanks for your quick help. Note: Inorder to insert that into SQL server I have changed the output to a format SQL server supporst. So the parse function I used is Date.parse($create_time).toLocaleDateTimeString({“format”:“yyyy-...

anivtk · 02-21-2020

I am calling the snapLogic Activity API and its returning the date in the format as “2020-02-21T17:44:19.996000+00:00” I am trying to store this data into SQL server and SQL server doesn’t accept this data in DateTime data type. I tried to use some s...

anivtk · 12-20-2019

Thanks rohithmadhavan, this worked. 

SnapLogic - Integration Nation

User Statistics

Re: How to add a custom Header in a file?

How to add a custom Header in a file?

Re: SnapLogic DateTime Conversion Guidelines

Re: Converting Varchar data into Datetime

Re: Converting Varchar data into Datetime

User Activity

How to add a custom Header in a file?

Snaps to copy data to Google Storage

Re: How to add a custom Header in a file?

Re: SnapLogic DateTime Conversion Guidelines

Re: Converting Varchar data into Datetime

Re: Converting Varchar data into Datetime

Re: Snaps to copy data to Google Storage