Since an empty database schema is created for you in the free trial system, run the CURRENT_USER statement to view the name of the current user, and run the OPEN SCHEMA statement to see the schema that is created for your username. Once you have installed the SQL client of your choice, you can connect it to the free trial system by using the credentials provided in the email. Assume that you have a folder with a set of files, and you want to copy them to three folders depending on their extensions: you have one folder for text files, another for Excel files, and the last one for the rest of the files. You can connect Exasol to various SQL clients. The Copy Files job entry allows you to copy one or more files or folders. Additionally, the database also includes some preloaded datasets. Since the demo system is hosted on ExaCloud, you do not have to perform any additional setup or hardware configurations.Īn empty database schema is created for you, where you can create and execute tables, views, functions, and scripts. You will shortly receive an email confirmation along with the credentials details to log into the Exasol demo system. The free trial system is hosted on ExaCloud, and you can access it by signing up here.
#PENTAHO DATA INTEGRATION CSV FILE TO XML WITH XSD HOW TO#
These exercises allow you to start using some of the key functionalities of Exasol.Īdditionally, the Data Science and UDFs Examples section provides you with UDF tutorials based on real-world examples and how to use them for Data Science within Exasol. such as Excel and Access, from text files such as CSV files, from XML. The objective of this step by step guide is to provide you with the necessary foundation to get you started on Exasol along with some easy hands-on exercises. spreadsheets, databases, and XML files Use Pentaho Data Integration to perform.