Wyn Enterprise provides a vast list of native connections to all sorts of data sources regardless of whether they are local files or databases available on different servers.

To create a data source in Wyn Enterprise - Resource Portal, follow these steps.

1. On the Resource Portal, navigate to Create (+) > Create Data Source.

   
   

   
   

2. Select a data source from the available ones.

3. Fill in the database configuration information for the selected data source.

4. Verify the data source connection by clicking Test Connection. If the data source is available, and the credentials are correct, you receive a notification of successful connection.

5. Click Create after the connection is successful.

Manage Data Source

You can view the added data source in the Categories tab of the Resource Portal.

You can edit, copy links, rename, delete, download, and manage permissions.

Supported Data Sources

You need to connect to the data before using the Wyn Enterprise for data analysis. This page covers the configuration settings for each of the datasource:

• Oracle

• SQL Server

• MySQL

• Postgres

• Snowflake

• SQLite

• DM

• TiDB

• AnalyticDB(MySQL)

• GreenPlum

• TimeScale

• Amazon Redshift

• MariaDB

• ClickHouseV2

• MonetDB

• Kingbase

• GBase8a

• GBase8s

• ClickHouse

• IBM DB2

• IBM DB2 iSeries/AS400

• Doris

• Kylin

• Google BigQuery

• Hive (beta)

• ElasticSearch (beta)

• Hana

• Excel

• JSON

• CSV

• XML

• MongoDB

• ElasticSearchDSL

• InfluxDB

• SSAS

• ODBC

• OData

• TDengine

• Teradata

• Custom Provider