Writing to a local CSV from the Creatio Connect Cloud
Even though more and more services are moving to cloud-based solutions, often times we still need to interface to on-premises software using CSV files. To do this using the Creatio Connect iPaaS system, you'll need to set up a Creatio Connect Ray. A Ray will allow the us to interact with the local computer where it is installed. Once you can configured the Ray and confirmed it is online, follow these steps to set up a job to write to a CSV file on the local machine.
- Create a new connection - use the Connection Type of "CSV via Upload", and ensure that you select your new Ray.
- Create a new job, your origin may be anything you want to write to the CSV file. For the Destination, select your new CSV connection.
- Create a new stage, in the Table enter the name of the CSV file that you want to be created. It is likely nothing will show up in the dropdown - you will have to manually type it in.
- If the file does not currently exist on the Ray machine, the Stage will initially show up with no fields to map to. To get around this limitation, you may manually enter the names of the columns you want to map to in the stage's User-Defined Field List box.
- Map your fields as you would for any normal job and run.
- By default, the file will get created in a new 'Files' folder inside you Creatio Connect Ray folder (C:\StarfishRay\Files). You can override this path by editing your CSV connection and entering an Additional Connection String Parameter of "URI=D:\data\csv" - edit the path as required.
Related Articles
Creatio Connect iPaaS Logging Features and Settings
Creatio Connect iPaaS Logging Features and Settings Creatio Connect iPaaS has a number of options for logging and monitoring integration activity. Logging is required at various stages of the integration mapping process, during the testing phase ...CSV Connector
Additional Documentation This Connector is based on the CSV ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RVG/ado/ CSV Via Upload (in Cloud Designer) When you upload a ...Connect Creatio security features
StarfishETL security features Compliance and data privacy · No data kept at rest on Starfish ETL iPaaS servers · Data in motion is encrypted using HTTPS Infrastructure protection · StarfishETL iPaaS servers hosted on AWS ...Creatio Connect Designer 2-factor Authentication (2FA)
The latest update for Creatio Connect Designer has 2-factor authentication (2FA) enabled. Update applied to Creatio Connect Cloud servers March 26, 2020. This feature is part of the Creatio Connect product strategy to continually improve your ...Creatio Connector
Creatio Connector Versions Connect Creatio has two connector types for Creatio. OData: Allows for more complex querying. 4-6k records per hour Data Services: Faster than OData. Approx 30k records per hour Creatio (OData) Advanced Filtering Sometimes ...