Working with local files
Local files are the files in a storage device attached to your computer, or a network device available from your computer.
In Integrator, you can copy (upload) local files into any available file storage or cloud storage location, including server storage. In fact, the simplest way to start working with local files is to upload them into server storage.
Step 1. Create a server storage connection.
Step 2. Use Explorer to upload local files.
Important: in order to upload local files, you must have access to Integrator's add-on Explorer.
Working with data behind a corporate firewall
When Integrator is installed on the cloud, it can connect to databases, web services and APIs, as well as data in file- and cloud-based storage, as long as they are accessible from the Internet.
This is not always the case, especially for corporate databases.
Accessing corporate databases, files and APIs
To access data behind a corporate firewall, Etlworks Integrator uses a zero-maintenance background service called Integration Agent. Integration Agent is installed right on your network, so it can easily connect to corporate data sources and Integrator on the cloud.
Integration Agent works behind a corporate firewall, so it can communicate with databases, file storage and APIs directly. Integration Agent and Etlworks Integrator share the same ETL engine.
Extracting and loading data
Integration Agent can extract data from corporate data sources and send it to secure cloud file storage, such as Amazon S3, which is accessible through Integrator, or it can push data directly to Integrator's REST API. Read about event-driven flows.
In addition to extracting data, Integration Agent can load data into a corporate database or an API.