jervin
New Contributor III
Joined 6 years ago
User Profile
User Widgets
Contributions
Connect SnapLogic to Oracle Cloud ATP database
We are moving our ERP to Oracle Cloud and I am trying to connect SnapLogic to an Oracle Cloud ATP (Autonomous Transaction Processing) database. I’ve been trying to set up an Oracle Thin Account in SnapLogic with the settings for our ATP database but keep getting error “IO Error: Remote host terminated the handshake”. Does anyone have experience with using SnapLogic with ATP and have any suggestions?2.3KViews0likes1CommentRe: Salesforce Allow Null Updates to Target
I’ve been playing around with this. The solution seems to be that the Salesforce Upsert snap will NOT push null updates to the target. However, Salesforce Update will push null updates. So if an external ID is being used to identify a record, use a Salesforce Lookup snap to obtain the Salesforce record ID first, then use a Salesforce Update snap to update the record.1.7KViews0likes0CommentsSalesforce Allow Null Updates to Target
I am trying to convert some Informatica upsert sync tasks to SnapLogic pipelines. One useful option in Informatica is an ‘Allow Null Updates to Target’ option. That is, when a source field becomes null, it also gets nulled in the target. How does the SnapLogic Salesforce Upsert snap handle nulls? Is there a good way to allow null updates to the target?Re: Wait to run pipeline until target file does not exist
Figured it out. If anyone else is trying to accomplish the same task, here is my solution: File Poller monitors the source location (“out” folder). “Only Output on Change” is not enabled. When input is received from File Poller, Directory Browser reads the target folder filtered for test.csv. Filter snap checks to see if the Name path in the JSON object exists using this expression: !($.hasPath(“Name”)). If the path does not exist, filter the record so no further processing is done. If the Name path exists, proceed to the File Reader snap and read the file from the out folder. Write the file to the target location. Delete the file from the out folder.1.7KViews0likes0CommentsWait to run pipeline until target file does not exist
I need a pipeline to wait until a file (named say test.csv) on a network share is picked up and moved/deleted by another process. Then my pipeline can write a new test.csv. The other process might only take a few seconds, or could take up to an hour to process test.csv. Is there a way to have my SnapLogic pipeline watch test.csv on the network share and wait until that file is gone and then continue processing? This would be sort of the opposite of what File Poller does.Solved2.1KViews0likes1Comment
Groups
Higher Ed Users Group
This user group is for customers within higher education.0 Posts
