On the Analytics tab you can configure access to data for analysis and reporting. Data can be extracted into your own database or you can choose to access it from Printix Cloud. Data can be viewed and analyzed with Printix Power BI solution or a tool of your own.

To get here:

  1. Select Menu , Settings
  2. Select the Analytics tab.

See also:

Printix database Own database
Data is kept for 30 days 90 days
Data extracts 2 times per day 4 times per day

Database

  • Database server address
    The address of the database server.
  • Database name
    The name of the database.
  • Database server port
    The TCP port to access the database. The default is 1433.
  • Username
    The username used to access the database.
  • Password
    The password used to access the database.

Test database connection

  1. Select Test to test the connection to the database.

Deactivate database

  1. Select Deactivate to stop extracting data to the database.
    You can select Activate if you want to start the extraction of data again.

Delete database

  1. Select Deactivate to stop extracting data to the database.
  2. Select Delete to delete the database.

How to extract data to Printix database

  1. On the Settings page select the Analytics tab.
  2. In the Printix database section select Create.
  3. When the database is created you will see:
    • Database server address, the address of the database server.
    • Database name, the name of the database.
    • Database server port, TCP port 1433.
    • Username, the username used to access the database.
    • Password, the password used to access the database.
  1. Select Activate to start extracting data to the database.
  2. Copy the configuration items one by one and use them to setup the Printix Power BI solution or a tool of your own.

How to extract data to own database

  • Create the Azure SQL Database you want to use for this purpose.
    • A good starting point is a database with 20 DTUs (Database Transaction Units).
  • The database user should have the database role db_owner. Alternatively you can give the database user these three fixed database roles: db_datareader, db_datawriter and db_ddladmin. Specifically the database user as a minimum need these database permissions:
    • CREATE TABLE
    • GRANT SELECT ON DATABASE
    • GRANT INSERT ON DATABASE
    • GRANT UPDATE ON DATABASE
    • GRANT DELETE ON DATABASE
  1. On the Settings page select the Analytics tab.
  2. In the Own database section:
    • In Database server address enter the address of the database server.
    • In Database name enter the name of the database.
    • In Database server port enter the TCP port to access the database. The default is 1433.
    • In Username enter the username to access the database. See database role above.
    • In Password enter the password to access the database.
  1. Select Create.
  2. Select Activate to start extracting data to the database.
  3. Copy the configuration items one by one and use them to setup the Printix Power BI solution or a tool of your own.

Modify own database

  1. Select Deactivate to stop extracting data to the database.
  2. Select Modify to modify the database.
  3. Select Save.
    You can select Activate if you want to start the extraction of data again.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Please do not use this for support questions.
Printix Support

Post Comment