Caspio’s ability to import and export data using easy-to-use wizards is an excellent feature if you work with multiple sets of data in different formats such as Microsoft Excel, Access, TXT or XML. What’s even better is that if you’re on a Professional plan or higher, you can simply schedule and automate your data import and export sessions for your online database to avoid the tedious process of doing this manually.
Caspio’s DataHub enables you to schedule data import and export tasks automatically. With this advanced feature, you’ll be able to schedule your import and export tasks on an hourly, daily or weekly basis — it all depends on your business’ needs. Since the Caspio low-code platform is recognized for its application integration capabilities and extendibility, DataHub works seamlessly with different storage repositories such as:
- A website accessed through HTTP or HTTPS.
- An FTP server accessed through FTP, FTPS or SFTP protocols.
- A remote server that offers secure copy through the SCP protocol.
- A cloud drive service such as Amazon S3, Dropbox, Google Drive, Microsoft OneDrive or Box.
- An email attachment to one or more addresses for data export by email.
Once you import your data using DataHub, it will immediately be available in your online database applications.
To get you started, check out this step-by-step guide on how to configure a DataHub repository site. To get the most of Datahub’s capabilities, we recommend scheduling your data import or export task during low-peak hours to ensure that the scheduled task is completed quickly. We also recommend allowing one task to finish first before scheduling another one. We encourage you to review your DataHub logs every now and then to identify a schedule that works for you.
Still stuck with repetitive online database management tasks? Sign-up for a free trial with Caspio and automate your business processes today.