Connect Presto data with Analytics Plus   

If you have your data stored in Presto, a powerful open-source SQL query engine, you can integrate it with Analytics Plus to unlock deeper insights.

 Benefits of integrating Presto with Analytics Plus 

• Unified Data Analysis: Easily integrate and analyze data from multiple sources.

• Real-time Insights: Get up-to-date reports and dashboards with scheduled data sync.

• Secure Data Transmission: Data transmitted between Presto and Analytics Plus is encrypted using robust encryption mechanisms like SSL (Secure Sockets Layer).

Setting up the Presto connection 

To import data from Presto into Analytics Plus, follow these steps:

A. Choose how to connect to the application   

You can establish a connection with Presto in one of the following ways:

• Direct Connection: If your Presto instance is publicly accessible, you can connect to it directly.
• Using Analytics Plus Data Bridge: If your Presto instance is hosted in a private network, use the Data Bridge to fetch the data securely.

Note: Ensure that you have the latest version of Data Bridge installed for optimal performance.

B. Configure the connection settings  

1. Navigate to the Data Sources page in Analytics Plus.
2. Click + New Data Source and select Presto.
3. Enter the following details:

• Host Name – The IP address or domain name of your Presto server.
• Port Number – The port through which Presto is accessible (default: 8080).
• Catalog Name – The catalog where your database is stored.
• Schema Name – The specific schema to be used.

      4. If connecting via Data Bridge, select the Data Bridge that has access to the database.

      5. Enable SSL encryption by selecting the Use SSL checkbox.

      6. Click Authenticate & Continue to proceed.

C. Select the data to import  

Once the connection details are configured, select the data you want to import into Analytics Plus:

1.  Choose the required database from the list.
2.  Select the tables you want to import.
3. Modify table names if needed by clicking the Edit icon that appears when you hover over the table name.
4. Click Continue to proceed with data import.

D. Configure data synchronization settings  

You can configure the sync settings to keep your data up to date.

1. Click Set Sync Schedule and choose how frequently you want the data to be refreshed.
2. Select from the available options:

• Manual Sync – Data is updated only when triggered manually.
• Hourly, Daily, or Weekly Sync – Automate data updates at scheduled intervals.

      3. Click Save & Sync Now to apply your changes.

Tip: Sync operations are color-coded for easy recognition.

E. Start analyzing your data  

Once the data is imported, you can:

• Create reports and dashboards using Analytics Plus drag-and-drop interface.
• Apply filters and custom formulas to refine your analysis.

1) Import Data from Presto

2) Live Connect

3) Import Roll Back

4) Manage Data source Settings

5) Manage Table Synchronization Settings

6) Resolving Sync Failures

7) Data Blending

Import Data from Presto   

Importing data from Presto comprises of three steps:

• Configure Connection Details
• Choose Data to Import
• Schedule Data Import

Configure Connection Details   

1. Click Import Your Data ->Presto.
2. Select the Host Server Type, Cloud Server or Local Server based on where the data is hosted.​

Based on the Host Server Type selected, configure the following settings:

Cloud Server: Choose How to Connect with the application to fetch the data:

• Connect directly using IP addresses: You must allow-list Analytics Plus IP addresses to use this method.
• Connect through agent : Analytics Plus Data Bridge is a utility tool that helps fetch data hosted in private networks. Ensure that you have the latest version of Data bridge.

​

Local Server: Choose the Data bridge that has access to the database. Ensure that the SSL certificate is placed in the <Databridge>/zcert folder.

1. Choose the connection type, Data Import or Live Connect.

• Data Import: This method imports and stores the data in Analytics Plus
• Live Connect: In this mode, data is not imported from Presto DB into Analytics Plus. Instead, when you create reports, Analytics Plus generates queries that are executed directly in Presto DB to fetch the required data. As a result, the report loading time depends entirely on the performance of Presto DB.

      2. Select the checkbox 'Use SSL' to secure data transmission between Presto and Analytics Plus.

      3. Click Next.

 Choose Data to Import   

Once the connection details are configured, you need to decide which data you want to import from Presto. Analytics Plus offers a range of import options, including Single Table, Multiple Table, and Custom Query, to support various data structures and analysis needs.

• Single Table
• Multiple Table 
• Custom Query

 Single Table   

1. Select Single Table from the Import From.
2. Choose the table to import from the Select Table drop-down menu.
3. Click Next to continue

1. The Import Settings and Preview wizard will open.

• You can edit the Workspace Name, Table Name, and add a description if needed.
• The Data Preview section displays the first few records of your data; you can verify the column name and the data type.
• Unselect the checkbox adjacent to the column header to Remove Column from importing.

2. On Import Errors section allows you to specify how to handle error conditions in case they occur while importing data. The following are the possible options:

• Set Empty Value for the Column (default): Sets an empty value to the corresponding column value that had problems while importing.
• Skip Corresponding Rows: Skips the corresponding rows in which an error occurs while importing.  
• Don't Import the Data: Aborts the import process if any error occurs during importing.

Click Create. Data import will be initiated, and you can also choose to schedule the import.

 Multiple Tables   

1. Select Multiple Tables from the Import From section.
2. Choose the tables to be imported.
3. Click Next to continue.

4. On the Import Settings page, enter the Workspace Name to be created in Analytics Plus. Additionally, you can add a Description for the workspace.

5. Click the Edit icon that appears when you hover over it to edit the table name.

6. Specify how to handle errors that occur during import in the On Import Errors section.

 Custom Query   

Select the Custom Query option and provide the SQL SELECT query in the given text area.

Click Next to continue. The successive steps are similar to importing data from a single table.

 Schedule Data Import   

Data Refresh  
Data freshness is important for effective analysis. Analytics Plus allows you to configure what data should be fetched in each schedule.

• Import all records: This option imports all the records in each schedule Refer to the Schedule import article to learn more.
• Incremental Refresh: This option imports only the new and updated or modified records into Analytics Plus. This method is beneficial when the database contains transactional records that get updated frequently. Refer to the Incremental Fetch article to learn more.

Follow the steps below to configure the Import synchronization settings (data refresh settings)

Once you have initiated the data import, Click Schedule this Import.

2. Choose What data to fetch in each schedule drop-down menu. You can choose to import all the records or incrementally fetch only the newly added or modified records.

3. Choose How do you want to import the data?

4. Select Include new columns added in your cloud database automatically into Analytics Plus table(s) to import data from newly created columns in the subsequent imports. 

5. Click Next.

Data Sync Frequency  

Analytics Plus offers flexible sync schedules to ensure that the data is always up-to-date for effective analysis.

1. In the Schedule Setting pane, choose the interval in which you would like to synchronize the data. You can choose to synchronize your data at one of the intervals mentioned below.

• Every 'N' hour
• Everyday
• Weekly Once (Standard plan and above)
• Monthly Once (Standard plan and above)

2. Selecting Not Scheduled will import the data only once, i.e., at the time of import.

3. In the case of continuous import errors, you can choose to be notified via email. To get notifications, select the interval at which you need to be notified from the Notify me after every drop-down menu. You can also choose to notify the Account Admin, All Workspace Admins, All Organization Admins, or any Custom User.

4. You can also choose to notify the Account Admin, All Workspace Admins, All Organization Admins, or any Custom User.

5. Enable the Periodically Fetch toggle button to initiate a full fetch of records. The frequencies are available based on the selected intervals.

6. Choose the required interval and click Save.

Refer to the Multiple Sync Schedule interval section to learn how to sync different tables at different sync intervals.

Live Connect

Live Connect enables direct, real-time connection to the data source, ensuring that up-to-the-minute data is used for analysis. In this method, the data is not imported or stored within the Analytics application. 

Import Rollback   

Import rollback reverts the most recent data import to the previous version. Users with administrator privileges and custom role users with permission to create tables can perform this action. Rollback facilitates the correction of errors in data without disrupting operations and also minimizes data loss. It is useful in collaborative environments where multiple users access the data and make changes.

Note:

• Data can be reverted to its previous state within 4 hours of the import.
• Deleted columns will not be reverted during the import rollback. Any actions, such as adding a new column, creating formulas, formatting columns, and having lookups defined, will be preserved during the import rollback.

Follow the below steps to revert the data import to the previous version,

1. Access the data table, which needs to be reverted.
2. Click Import Data -> Last Import Details.
   ​
3. Click Rollback to revert to the previous instance.
4. Import rollback will be initiated, displaying the status along with the details of the admin who performed the action and the time of execution.

Manage Data Source sync settings

The Data Sources tab is the central hub that helps manage all the connection settings of the data sources in the workspace. It also helps keep tabs on the data sync status and notifies in the case of data sync failures. User with the Administrator Privilege can access the data sources tab and make necessary changes when needed.

 Edit Connection:    

Enables admins to re-authenticate and update the connection details such as credentials or configuration settings without causing any interruption to the existing data flow.

Sync Settings:    

Helps manage and modify the frequency of data synchronization (e.g., change from daily to hourly syncs) based on the current needs of your analysis. In case of a sync failure, you can specify which users should be notified. You can manage the periodic fetch settings for the tables where only the newly added records are imported. Refer to the Schedule Import section to learn more.

 Configure Multiple Sync Intervals: 

Analytics Plus allows you to configure multiple sync schedules for the tables in a connection, that is, tables can be synced at different timeframes. Refer to the Multiple Sync Schedule article to learn more.

 Audit History:    

Audit logs are crucial for maintaining security and troubleshooting issues. They provide a comprehensive record of User and System Actions, including details of the time when the action occurred and information about the administrator who performed the action. Audit logs are maintained for each data source in the workspace.

The following are the User Actions and the System Actions that are logged in Analytics Plus:

Select any action in the audit history to view complete information about the action performed.

 Sync History:    

Provides a detailed record of data synchronization activities, making it easy for the administrators to track the status of each data sync. The sync operations are color-coded for easy recognition. Successful data syncs are indicated in green, signaling that the data sync is completed without any issues. Failed data syncs are marked in red with the reasons for failure along with the necessary action to be taken.

Manage Table Synchronization Settings   

Analytics Plus provides flexible data fetch options like full data and incremental fetch, which imports only the new records. Each table can have different data fetch configurations. All the tables imported from the database will be listed with the Table and Source Table Name, What data is fetched in each sync, Last Fetch Time, and its Sync status.

• Hover the mouse over the table for which you want to modify the settings.
• Click the Sync Now icon to include the recent changes made in the source database.
• Click the Edit icon to modify the synchronization settings of the table. You can choose whether all the data should be fetched from the source or only the new records in each data sync schedule.
• Click the Delete icon to remove a table. This will terminate only the data synchronization between the source table and Analytics Plus. The lookups and the relationships defined, and the reports created over that table, will all be retained.
• Click the Info icon to view the Import Details. Get a Summary of the data that were successfully imported and the data that had errors while importing.

Resolving Sync Failures   

Data synchronization can fail if the credential provided is invalid or expired, or if the data type mismatches. Analytics Plus sends an email to the workspace admin and also sends an in-app notification with the reason for failure along with the necessary action to be taken to resolve the issue. Access the Data Sources tab to resolve sync failure. Refer to the Edit Setup section for more details.

Data Blending   

Combine data from various data sources, such as Files, Feeds, Cloud storage Databases, and other application integrations, for in-depth analysis. While importing data in an existing workspace, Analytics Plus auto identifies columns of the same data type and provides suggestions for lookup. With Query Tables, you can combine data from different tables in the workspace. Use query tables to import data

To import data into an existing workspace, Click the Create icon on the side navigation panel and choose New Table/Import Data from the drop-down menu. Successive steps are similar to the steps mentioned in this section.

 Import Data into an existing table 

1. Click Import -> Import data into this table.
2. Select the table you want to import.
   
3. Choose how you want to import the data into the existing table and select how to handle import errors.
4. Click Import.

 Conclusion 

Integrating Presto with Analytics Plus allows you to analyze large datasets seamlessly and derive actionable insights. Follow the steps outlined above to establish a secure and efficient connection between Presto and Analytics Plus.