ContributionsMost RecentMost LikesSolutionsOracle to Redshift Migration Using Generative Integration It is a quick and easy task to move data at scale without writing complex SQL statements or code. Select the read and write Snaps you need, give them the right parameters and tune as much as you need to, and in minutes your task is done. Re: reading fixed width cobol file in snaplogic using python script If this is a valid copybook file, we have a COBOL Copybook parser that would do this with one snap, Ref: https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2386591995/Copybook+Snap+Pack. Other snaps of interest would be the transcoder and fixed width parser snaps SnapLogic Mainframe Accelerator The SnapLogic Mainframe Accelerator is a collection of fully functional pipelines that read and write Cobol Copybooks, DB2 and file systems. It is now available as a free download from the AWS Marketplace. Learn more in this video. Re: REST GET Also, you need to confirm the source does not have any API limits. Some endpoints throttle traffic and limit the number of calls per minute or rows of data per 24 hours. Make sure the source is not ignoring your requests. Re: REST GET You want to use the HTTP client snap for this. It will handle pagination easier than the REST snap pack and should be used instead of the REST Snap for all new development. Ref: https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2614591489/HTTP+Client Re: ServiceNow Query snap Performance instead of doing it in a single pipeline, use multiple pipelines and partition the reads. Depending on the performance of their API you could spin up 10 or 20 pipelines, have them read at the same time and get it done much faster. Re: Failed to execute pipeline Follow these steps to learn more In the dashboard, find the instance of the pipeline that failed. Click on the pipeline name in the first column. This will load it into the designer, if the pipeline has been altered since it ran, you may see a warning, that is expected, you are opening up a copy of the pipeline as it ran. Open the pipeline statistics and scroll through the errors at the pipeline or snap level. Also review the extra details for additional information. I suspect it is not at the snap level, but at the pipeline level. Look for time outs and failed connections. Re: REST Snap Pack Reference Page Diane, what is the context of this email please? Best regards, Rich Re: Problems with Date.parse() function Victor, I can understand how 16/12/1943 would fail. But I tested 1932, 1940 and 1950 and had no issues This in the mapper expression Date.parse (“09/12/1940”,“dd/MM/yyyy”) this is the result _snaptype_datetime: “1940-12-09T00:00:00.000 UTC” please try again Re: How to login/ who can login to snaplogic university? Mike, new Partners get free access for thirty days. Beyond that it is a 12 month subscription for $449. per seat. Best regards, Rich
GroupsPartner User Group This area is for our partners to communicate with each other and with the SnapLogic Alliances team.0 Posts
Partner User Group This area is for our partners to communicate with each other and with the SnapLogic Alliances team.0 Posts