1. Create New Dataset
To start from a connected system, simply click on "New Dataset."
2. Choose Your Connector
Select the system from which you want to create a dataset. If the desired system is not visible, navigate to the "Create a System" in the left-hand panel.
3. Configure Your Dataset
Standard Objects
Each system has unique configuration requirements. Most systems provide objects and tables that Savant can read. In these cases, Savant simplifies this process with available drop-down menus. Configure parameters such as skip rows and headerless configurations.
Custom QL
Savant also supports pulling data via custom QL for databases and advanced business apps. In these cases, you can simply select the Customer QL option at the top and drop in your query.
4. Name It!
Specify a name for your dataset and optionally provide a description.
Click Confirm to save your dataset in Savant.
5. Reconfigure As Needed
After configuring the dataset, Savant will read a sample of 1000 rows of data from your system. Adjust the table query or selected options in the top left-hand corner of the window. Adjust column settings in the bottom left-hand corner, including including/excluding future columns and selecting/deselecting columns. Configure data types, as these settings are locked in the dataset going forward.
