What is Live Data connection?

[jhon]

Hi, What is Live Data connection?

[Darwin]

Hi Jhon, please use this forum for questions you cannot find answer easily and also if it happens to be the case provide more context around the question, that would be of great helpful for anyone who wants to answer 🙂

[Lavanya]

Hi,

In this mode, data will not be imported and stored in Analytics Plus. Instead, Analytics Plus will display live data from your database when reports and dashboards are launched. Live connections offer the convenience of real-time updates.

Set up connection

Edit connection

Mismatches

Limitations​

Set up connection

Live connection setup can be initiated by selecting the connection type as Live connect in the database Import screen.

Follow the steps below to setup a live connection with your database:

Enter the host name, port number, user name and password of the database you wish to connect to, and select the connection type as Live connect.

In the next page, select the tables you wish to analyze. The tables you have selected from the database will be listed under Selected Tables.

Click on Connect to proceed with the import process.

It might take some time to establish the connection, depending on the performance of the database server.  On successful connection with database, a sample workspace as shown below will be created in Analytics Plus.

For each table in source database, there will be an equivalent table created in Analytics Plus with the same table name. The table relationships defined in the target database (via foreign key) will be carried over to Analytics Plus as is.

Edit connection

Once you set up the database connection with Analytics Plus, you can edit it any time. Open the workspace in Analytics Plus. Click the Data Sources button in the side panel. This opens the Local Database Connection Settings page using which you can manage your connection.

Select the Edit Connection button.

Mismatches

There are a few scenarios that could result in mismatch between the source (database) tables and the corresponding tables in Analytics Plus.

There are two types of mismatches that can occur:

Table Mismatch

Table mismatches are caused due to two reasons:

Case 1: When a table has been deleted in the source database, but not in Analytics Plus. To resolve this mismatch, the corresponding table needs to be deleted from Analytics Plus.

Note: Once you delete the table, all the reports created on that table would be deleted as well.

Case 2: When a table has been renamed in the source database, but has not been renamed in Analytics Plus. To resolve this, click the Remap link near the table name, select the table that has been renamed, and click Remap.

Note: For a remap to be successful, the existing table in Analytics Plus and the renamed table in source database should have the same structure.

Column Mismatch

Column mismatches are caused due to two reasons:

​Case 1: When a column has been deleted in the source database, but not in Analytics Plus. To resolve this mismatch, the corresponding column needs to be deleted from Analytics Plus.

Note: Once you delete the column, all the reports created using that column data would be deleted as well.

Case 2: When a column has been renamed in the source database, but has not been renamed in Analytics Plus. To resolve this, click the Remap link near the column name, select the column that has been renamed, and click Remap.

Limitations

As data from the source database is not stored locally in Analytics Plus, it might take some additional time to load reports. This loading time will depend on the performance of database.

Any change in column details will not be synchronized automatically. The setup needs to be manually synced to access reports with the latest data.

Query tables cannot be created in a workspace setup with live connect.

Data from other data sources cannot be imported into this workspace.

The data type of a column in Analytics Plus cannot be changed. The data type needs to be changed in the source database, and then resynced with the Analytics Plus application.

If you are interested to learn ISTQB? you can schedule to attend a free demo here ISTQB Online Certification Training.

Thanks and Regards,

Lavanya Sreepada.

 

[Stefan]

Hi Jhon,

I think the Live Data connection is great tool that can help you stay connected to your data.

It is easy to use and it is available for free. You can use it to connect to your data anywhere, anytime.

[Thomas]

Hello Jhon Please use this topic for questions you can’t find answers to readily, and if you can, add more context for the issue so that anyone who wishes to respond is as informed as possible.

[Author]

Posts