There are four different types of registered data sources with Zetaris:
-
File Sources such as CSV, Excel, XML, JSON, Parquet, ORC, Delta and Avro. Examples of these datasources include AWS S3, Azure Blob, local/network file drives.
-
Logical Datasources include any data source that offers a JDBC API. These typically include relational and non-relational databases (RDBMS and NoSQL).
-
Streaming Datasources
- REST API connections
How to connect to your data
Filesources
To register physical data sources in Zetaris:
1. Create and name a virtual connection to your physical data source, local Files, or AWS S3, and so on, by clicking the plus button.
2. Once the virtual connection is added, click the plus button next to the registered data source.
3. Select File Store to register data from known locations, or select API to retrieve data from a RESTful API. Click Next.
4. Complete fields to register data source tables.
The physical data sources should now be available.
You can register these tables in bulk through the Schema Store.
Logical Datasources
To register Logical Datasources in Zetaris:
1. Click the plus button under Logical Datasources to initiate the connection wizard.
2. Select Pull Type and click Next.
3. Complete fields to register logical data source tables.
4. Click Next. A summary of all the virtual database and driver parameters with the selected virtual tables is displayed. To accept these changes and create the virtual data source, click Register.
Logical data source tables should now be available.
You can register these tables in bulk through the Schema Store.
Streaming Datasources
Streaming data sources can be set up through the Schema Store.