In Avaya Analytics™, advanced users can create connections to the popular external databases for importing data. You can use the data to create reports and documents.
You can define a new database connection directly from Avaya Analytics™ for users to import data, edit, delete, rename, or duplicate an existing connection.
Before you begin
Ensure the following:
Get advanced user credentials.
Create a data source with Data Source Name (DSN) if you plan to connect to a data source using a DSN.
Note:
You can also use the DSNLess Connection option to connect to your data source.
Log on to Avaya Analytics™ with your advanced user credentials.
From the navigation bar on the left, click CreateAdd External Data.
ADDITIONAL INFORMATION:
Note:
A basic user can get access to only the data files from the local machine, such as excel files, CSV, JSON files. An advanced user can get access to data from external databases.
STEP RESULT:
Avaya Analytics™ displays the Connect to Your Data page.
Click Databases and select the database that you want to connect to, such as Microsoft SQL (MS SQL) database.
STEP RESULT:
The Select Import Options page pops up and displays the following options:
Build a Query
Type a Query
Select Tables
Depending of the type of data you want to import, click one of the following options:
To use a graphical interface to build the SQL query to use to import your data, click the Build a Query button.
To manually type or paste a query to import your data, click the Type a Query button.
To select tables in the data for the import, click the Select Tables button.
Click Next.
To create a new data source, click the plus icon next to DATA SOURCES.
STEP RESULT:
The Data Source page pops up.
Select the type of connection to the database using one of the following options:
ADDITIONAL INFORMATION:
DSN Data Sources
DSN-less Data Sources
Depending on the database connection you choose, enter the details in the fields and click Save.
To test the connection, return to Import from the <import options> page and ensure that the page displays the information.
ADDITIONAL INFORMATION:
Here <import options> refers to any of the data types you choose to import, such as tables.
