# Atoti Hub: Atoti Engine Atoti Java SDK Atoti Java SDK 6.2 (latest) ## Atoti Java SDK 6.2 (latest) ### - [What is the Atoti Java SDK?](https://docs.activeviam.com/engine/java-sdk/6.2/intro/overview.md) ### Releases and upgrades - [Release notes](https://docs.activeviam.com/engine/java-sdk/6.2/release/whats_new.md) - [Changelog](https://docs.activeviam.com/engine/java-sdk/6.2/release/changelog.md) - [Migration notes](https://docs.activeviam.com/engine/java-sdk/6.2/release/migration_notes.md) - [Backward Compatibility](https://docs.activeviam.com/engine/java-sdk/6.2/release/backward_compatibility.md) - [Prepare Next Version](https://docs.activeviam.com/engine/java-sdk/6.2/release/migration_notes_next.md) - [Dependencies](https://docs.activeviam.com/engine/java-sdk/6.2/release/dependencies.md) #### Previous versions ##### 6.1 - [Release notes](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/6_1/whats_new_6_1.md) - [Changelog](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/6_1/changelog_6_1.md) - [Migration notes](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/6_1/migration_notes_6_1.md) - [Prepare Next Version](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/6_1/migration_notes_next_6_1.md) ##### 6.0 - [What's new in 6.0](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/6_0/whats_new_6_0.md) - [Changelog 6.0](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/6_0/changelog_6_0.md) - [Migration notes 6.0](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/6_0/migration_notes_6_0.md) - [Deprecations in 6.0](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/6_0/deprecations_6_0.md) ##### 5.11 - [What's new in 5.11](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/5_11/whats_new_5_11.md) - [Changelog 5.11](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/5_11/changelog_5_11.md) - [Migration notes 5.11](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/5_11/migration_notes_5_11.md) - [Deprecated features in 5.11](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/5_11/deprecations_5_11.md) ##### 5.10 - [What's new in 5.10](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/5_10/whats_new_5_10.md) - [Changelog 5.10](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/5_10/changelog_5_10.md) - [Migration notes 5.10](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/5_10/migration_notes_5_10.md) - [Deprecated features in 5.10](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/5_10/deprecations_5_10.md) ##### 5.9 - [What's new in 5.9](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/5_9/whats_new_5_9.md) - [Migration notes 5.9](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/5_9/migration_notes_5_9.md) - [Deprecated features in 5.9](https://docs.activeviam.com/engine/java-sdk/6.2/release/previous/5_9/deprecations_5_9.md) ### Getting started - [Getting Started: Overview](https://docs.activeviam.com/engine/java-sdk/6.2/start/getting_started_overview.md) - [Getting Started: Development Environment](https://docs.activeviam.com/engine/java-sdk/6.2/start/dev_env.md) - [Getting Started: Download](https://docs.activeviam.com/engine/java-sdk/6.2/start/download.md) - [Getting Started: License](https://docs.activeviam.com/engine/java-sdk/6.2/start/license.md) - [Getting Started with the Atoti Spring Boot Template](https://docs.activeviam.com/engine/java-sdk/6.2/start/spring_boot_template.md) - [Getting Started with the Sandbox Project (Deprecated)](https://docs.activeviam.com/engine/java-sdk/6.2/start/sandbox.md) ### Concepts - [Atoti Concepts in a Nutshell](https://docs.activeviam.com/engine/java-sdk/6.2/concepts/concepts_in_a_nutshell.md) - [Data Versioning (MVCC)](https://docs.activeviam.com/engine/java-sdk/6.2/concepts/data_versioning.md) - [Dimensions and Hierarchies](https://docs.activeviam.com/engine/java-sdk/6.2/concepts/dimensions_and_hierarchies.md) - [Partitioning and NUMA awareness in Atoti](https://docs.activeviam.com/engine/java-sdk/6.2/concepts/partitioning.md) ### Step 1: Bring your data into Atoti - [Database Overview](https://docs.activeviam.com/engine/java-sdk/6.2/database/database_overview.md) - [Database API](https://docs.activeviam.com/engine/java-sdk/6.2/database/database_api.md) - [Database Queries](https://docs.activeviam.com/engine/java-sdk/6.2/database/database_queries.md) #### Datastore - [Datastore Configuration](https://docs.activeviam.com/engine/java-sdk/6.2/datastore/datastore_config.md) - [Datastore Transactions](https://docs.activeviam.com/engine/java-sdk/6.2/datastore/datastore_transactions.md) - [Indexing the Stores](https://docs.activeviam.com/engine/java-sdk/6.2/datastore/store_indexing.md) - [Chunks](https://docs.activeviam.com/engine/java-sdk/6.2/datastore/chunks.md) - [Update-where procedures](https://docs.activeviam.com/engine/java-sdk/6.2/datastore/update_where_procedures.md) - [Monitoring on the Datastore](https://docs.activeviam.com/engine/java-sdk/6.2/datastore/datastore_monitoring.md) ##### Sources (ETL) - [ETL in Atoti](https://docs.activeviam.com/engine/java-sdk/6.2/sources/data_sources_introduction.md) - [CSV Source](https://docs.activeviam.com/engine/java-sdk/6.2/sources/csv_source.md) - [JDBC Source](https://docs.activeviam.com/engine/java-sdk/6.2/sources/jdbc_source.md) - [Parquet Source](https://docs.activeviam.com/engine/java-sdk/6.2/sources/parquet_source.md) - [Source Monitoring](https://docs.activeviam.com/engine/java-sdk/6.2/sources/source_monitoring.md) ###### How-to Guides - [Load a CSV file](https://docs.activeviam.com/engine/java-sdk/6.2/sources/how-to/load_a_csv_file.md) - [Load data from a JDBC source](https://docs.activeviam.com/engine/java-sdk/6.2/sources/how-to/load_data_from_jdbc.md) ###### Load from the cloud - [Cloud Source](https://docs.activeviam.com/engine/java-sdk/6.2/sources/cloud/cloud_source.md) - [Amazon S3 Cloud Source](https://docs.activeviam.com/engine/java-sdk/6.2/sources/cloud/aws_cloud_source.md) - [Azure Cloud Source](https://docs.activeviam.com/engine/java-sdk/6.2/sources/cloud/azure_cloud_source.md) - [Google Cloud Source](https://docs.activeviam.com/engine/java-sdk/6.2/sources/cloud/google_cloud_source.md) ##### Specific data types - [Handling Dates](https://docs.activeviam.com/engine/java-sdk/6.2/core_features/dates.md) - [Vectors in Atoti Server](https://docs.activeviam.com/engine/java-sdk/6.2/core_features/vectors.md) - [Numerical data in Atoti Server](https://docs.activeviam.com/engine/java-sdk/6.2/core_features/numerical_data.md) ##### How-to Guides - [How to edit datastore content](https://docs.activeviam.com/engine/java-sdk/6.2/datastore/how_to_edit_datastore_content.md) - [How to register update-where procedures](https://docs.activeviam.com/engine/java-sdk/6.2/datastore/how_to_register_update_where_procedures.md) - [How to use Transaction Record Blocks](https://docs.activeviam.com/engine/java-sdk/6.2/datastore/how_to_use_transaction_record_blocks.md) #### DirectQuery - [Getting Started](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/getting_started.md) - [Compatibility with Databases](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/compatibility.md): Which databases and versions are supported by Atoti DirectQuery, covering managed databases including Snowflake, BigQuery, Amazon Redshift, ClickHouse Cloud, Databricks, and Dremio, and self-hosted databases including ClickHouse and Microsoft SQL Server - [Monitoring in DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/directquery_monitoring.md): How to monitor Atoti DirectQuery using tracing for SQL query insights and external DB query IDs, or logging via the `atoti.server.directquery` root logger, with tags such as `category`, `pivot_name`, and `provider_name` - [Performance considerations with DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/directquery-performance-considerations.md): How to identify and resolve Atoti DirectQuery performance bottlenecks across query generation, external database execution, result download, and Atoti-side processing, using traces, logs, aggregate tables, and clustering fields ##### Connect to remote database - [Connecting to remote Database](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/connect_to_external/intro.md): How to connect Atoti DirectQuery to a remote database, covering required permissions and connection methods for BigQuery, ClickHouse, Databricks, SQL Server, Redshift, Snowflake, and Synapse - [Connect to BigQuery](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/connect_to_external/connect_to_bigquery.md): How to connect Atoti DirectQuery to Google BigQuery, covering service account key file setup via GOOGLE_APPLICATION_CREDENTIALS, OAuth2 user credential authentication, and the BigQuery IAM permissions required for read sessions and job execution - [Connect to ClickHouse](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/connect_to_external/connect_to_clickhouse.md): How to connect Atoti DirectQuery to ClickHouse, including credential delegation via `ClickhouseConfiguration`, optional LDAP authentication on the ClickHouse server, and minimum SQL role permissions on `system.databases`, `system.tables`, `system.columns`, and `system.processes` - [Connect to Databricks](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/connect_to_external/connect_to_databricks.md): How to connect Atoti DirectQuery to a Databricks database using the Databricks JDBC driver, including credential configuration via `DatabricksProperties` with a connection string and password - [Connect to Microsoft SQL Server](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/connect_to_external/connect_to_mssql.md): How to connect Atoti DirectQuery to Microsoft SQL Server, covering credentials via `SQLServerDataSource`, SQL login configuration, and the `CONNECT` and `SELECT` permissions required on target schemas or tables - [Connect to Redshift](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/connect_to_external/connect_to_redshift.md): How to connect Atoti DirectQuery to Amazon Redshift using the JDBC driver, covering role and user setup with `USAGE` and `SELECT` privileges, basic authentication via connection string, and IAM credentials from the AWS credentials file - [Connect to Snowflake](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/connect_to_external/connect_to_snowflake.md): How to connect Atoti DirectQuery to Snowflake using the Snowflake JDBC driver, including role configuration with `USAGE` and `SELECT` privileges, user setup with default warehouse and namespace, and JDBC connection string with basic or alternative authentication - [Connect to Synapse](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/connect_to_external/connect_to_synapse.md): How to configure credentials and SQL permissions for Atoti DirectQuery connections to Microsoft Azure Synapse, including `SQLServerDataSource` delegation, SQL login, Azure Active Directory login, and Managed Identity authentication ##### Concepts - [Split granular data between in-memory datastore and DirectQuery database](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/split-in-memory-directquery.md): How to split granular data between an in-memory datastore and an Atoti DirectQuery database in a hybrid distributed setup, covering hot/cold date partitioning, `IDatabase` abstraction, and partial aggregate providers for historical overviews ###### Schema Specifics - [Composite Database](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/composite-database.md): How to combine external tables and Atoti Datastore in-memory tables within a single Atoti DirectQuery schema, where in-memory stores remain isolated and enable faster measure computation via get-by-key queries without external database round-trips - [Vectors in DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/directquery-vectors.md) - [Relationship Optionality](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/relationship-optionality.md) - [External data validation](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/external-data-validation.md) ###### Versioning - [Versioning](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/versioning.md): Versioning support in Atoti DirectQuery connectors, covering time travel availability by database (BigQuery, Databricks, Snowflake), `DatabaseSettings` configuration, incremental and full data refresh, de-synchronization risks, and branching limitations - [Time-Travel Emulation](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/emulated-time-travel.md): How emulated time travel in Atoti DirectQuery adds `valid_from` and `valid_to` validity columns to external database tables to simulate versioning, covering database setup, data management, current version discovery, and `EmulatedTimeTravelDescription` configuration - [Incremental Refresh](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/incremental-refresh.md): How to trigger an incremental refresh in Atoti DirectQuery to propagate external database changes, covering change types such as `ADD_ROWS`, `UPDATE_ROWS`, `REMOVE_ROWS`, and `MIXED_CHANGES`, scope conditions, and full refresh fallback behavior - [Incremental Refresh advanced](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/incremental-refresh-advanced.md) ###### Querying - [Supported aggregation functions with DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/directquery-agg-functions.md) - [Clustering fields in DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/directquery-clustering-fields.md) - [Aggregate Tables](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/aggregate-tables.md): How to use aggregate tables in Atoti DirectQuery to pre-aggregate data in an external database, reducing query load by routing to smaller tables, with coverage of Sum, Min, Max, Average, and UDAF aggregations, measure mapping, hierarchy aggregate tables, and the Bootstrapper - [DirectQuery Local Cache](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/directquery_local_cache.md): How the Atoti DirectQuery local cache stores retrieved data partitions in memory to prevent repeated round-trips to external databases, covering cache partition configuration, retrieval behavior for get-by-key and list queries, version invalidation, and eviction policies ##### Database specifics - [Introduction](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/databases/introduction.md) - [Google BigQuery](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/databases/bigquery.md) - [ClickHouse](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/databases/clickhouse.md) - [Databricks](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/databases/databricks.md) - [Generic JDBC](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/databases/jdbc.md) - [Microsoft SQL Server](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/databases/mssql.md) - [Amazon Redshift](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/databases/redshift.md) - [Snowflake](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/databases/snowflake.md) - [Microsoft Azure Synapse](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/databases/synapse.md) ##### How-to Guides - [How-To Guides](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/how_to_guides.md) - [How-to use hierarchies](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/how_to/use_hierarchies_with_direct_query.md) - [Create and customize a Table](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/how_to/customize_table.md) - [How to use vectors](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/how_to/use_vector_in_table.md) - [User Defined Aggregation Functions](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/how_to/user_defined_aggregation.md) - [Use custom types](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/how_to/use_custom_types.md) - [Incremental Refresh](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/how_to/incremental-refresh-how-to.md) - [Wait for cube feeding](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/how_to/wait_cube_feeding.md) - [Create and use a DirectQuery local cache](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/how_to/define_and_use_cache.md) - [Setting query timeouts](https://docs.activeviam.com/engine/java-sdk/6.2/directquery/how_to/setting_query_timeouts.md) ### Step 2: Design your Cube - [Aggregation & Analytics Overview](https://docs.activeviam.com/engine/java-sdk/6.2/cube/overview.md) - [Cube Configuration](https://docs.activeviam.com/engine/java-sdk/6.2/cube/configuration.md) #### Cube structure - [Dimension and hierarchy Configuration](https://docs.activeviam.com/engine/java-sdk/6.2/cube/hierarchy_configuration.md) - [Level Configuration](https://docs.activeviam.com/engine/java-sdk/6.2/cube/level_configuration.md) #### Copper API - [Presentation](https://docs.activeviam.com/engine/java-sdk/6.2/copper/copper_intro.md) - [The API](https://docs.activeviam.com/engine/java-sdk/6.2/copper/copper_api.md) - [Creating and publishing measures](https://docs.activeviam.com/engine/java-sdk/6.2/copper/copper_measures.md) - [Creating and publishing hierarchies](https://docs.activeviam.com/engine/java-sdk/6.2/copper/copper_hierarchies.md) - [Measure and hierarchy publication](https://docs.activeviam.com/engine/java-sdk/6.2/copper/copper_publication.md) - [Joining isolated stores in Copper](https://docs.activeviam.com/engine/java-sdk/6.2/copper/copper_join.md) - [Advanced topics](https://docs.activeviam.com/engine/java-sdk/6.2/copper/copper_advanced.md) #### Advanced APIs - [Cube Locations](https://docs.activeviam.com/engine/java-sdk/6.2/cube/locations.md) - [Post-Processors](https://docs.activeviam.com/engine/java-sdk/6.2/cube/postprocessors.md) - [Cube Filters](https://docs.activeviam.com/engine/java-sdk/6.2/cube/filtering.md) - [Aggregation Functions](https://docs.activeviam.com/engine/java-sdk/6.2/cube/aggregation-functions.md) - [Analysis hierarchies](https://docs.activeviam.com/engine/java-sdk/6.2/cube/analysis_hierarchies.md) - [Aggregate Provider](https://docs.activeviam.com/engine/java-sdk/6.2/cube/providers/aggregate_provider.md) - [AI-based Optimizer](https://docs.activeviam.com/engine/java-sdk/6.2/cube/providers/ai_optimizer.md) - [Dynamic Aggregate Provider](https://docs.activeviam.com/engine/java-sdk/6.2/cube/providers/dynamic_aggregate_provider.md) - [Aggregate Cache](https://docs.activeviam.com/engine/java-sdk/6.2/cube/aggregate_cache.md) - [Custom Member Properties](https://docs.activeviam.com/engine/java-sdk/6.2/cube/member_properties.md) - [Context Values](https://docs.activeviam.com/engine/java-sdk/6.2/cube/context_values.md) - [Aggregates Continuous Handlers](https://docs.activeviam.com/engine/java-sdk/6.2/cube/handlers.md) #### Distribute Atoti - [Distributed Architecture Overview](https://docs.activeviam.com/engine/java-sdk/6.2/distributed/distributed_intro.md) - [Distributed Architecture Guide](https://docs.activeviam.com/engine/java-sdk/6.2/distributed/distributed_getting_started.md) - [Distributed Architecture Communication Flows](https://docs.activeviam.com/engine/java-sdk/6.2/distributed/communication_flow.md) - [Distributed Post-Processors](https://docs.activeviam.com/engine/java-sdk/6.2/distributed/distributed_post_processors.md) - [What-If](https://docs.activeviam.com/engine/java-sdk/6.2/distributed/distributed_what_ifs.md) - [Recommendations](https://docs.activeviam.com/engine/java-sdk/6.2/distributed/distributed_recommendations.md) - [Distribution Properties](https://docs.activeviam.com/engine/java-sdk/6.2/distributed/distributed_properties.md) - [Distribution Monitoring](https://docs.activeviam.com/engine/java-sdk/6.2/distributed/distribution_monitoring.md) - [Distribution Testing](https://docs.activeviam.com/engine/java-sdk/6.2/distributed/distribution_testing.md) ##### JGroups Configuration - [Protocol Configuration](https://docs.activeviam.com/engine/java-sdk/6.2/distributed/jgroups_protocol_configuration.md) - [JGroups Cluster Security](https://docs.activeviam.com/engine/java-sdk/6.2/distributed/jgroups_security_configuration.md) ##### Data Overlap - [What is data overlap?](https://docs.activeviam.com/engine/java-sdk/6.2/distributed/data_overlap.md) - [How to safely remove data in overlap configuration](https://docs.activeviam.com/engine/java-sdk/6.2/distributed/remove_data_overlap.md) ##### How-to Guides - [Distributed Data Roll Over](https://docs.activeviam.com/engine/java-sdk/6.2/distributed/distributed_data_roll_over.md) ### Step 3: Build an Atoti application - [List of Spring Boot Starters](https://docs.activeviam.com/engine/java-sdk/6.2/starters/starters_directory.md) - [The Atoti Server Starter](https://docs.activeviam.com/engine/java-sdk/6.2/starters/atoti_starter.md) - [The Atoti UI Starter](https://docs.activeviam.com/engine/java-sdk/6.2/starters/atoti_ui_starter.md) - [The Atoti Admin UI Starter](https://docs.activeviam.com/engine/java-sdk/6.2/starters/atoti_admin_ui_starter.md) - [The Atoti Excel Add-in Starter](https://docs.activeviam.com/engine/java-sdk/6.2/starters/atoti_excel_addin_starter.md) - [The Atoti Server Application Starter](https://docs.activeviam.com/engine/java-sdk/6.2/starters/atoti_server_application_starter.md) - [The Query History Starter](https://docs.activeviam.com/engine/java-sdk/6.2/starters/atoti_query_history_starter.md) - [Atoti Server Extension reference page](https://docs.activeviam.com/engine/java-sdk/6.2/starters/atoti_server_extension.md) #### How-to Guides - [How-to guides](https://docs.activeviam.com/engine/java-sdk/6.2/starters/how-to/index.md) - [How to expose an Atoti application to Atoti Python SDK](https://docs.activeviam.com/engine/java-sdk/6.2/starters/how-to/expose-app-to-python.md) - [How to set up an XMLA interceptor in an Atoti application](https://docs.activeviam.com/engine/java-sdk/6.2/starters/how-to/setup-xmla-interceptor.md) - [How to configure a content service](https://docs.activeviam.com/engine/java-sdk/6.2/starters/how-to/configure-content-service.md) - [How to use Atoti Server Extension to create your own measures](https://docs.activeviam.com/engine/java-sdk/6.2/starters/how-to/create-custom-measures.md) - [How to create a custom REST service in an Atoti Server Extension](https://docs.activeviam.com/engine/java-sdk/6.2/starters/how-to/create-custom-rest-service.md) - [How to secure REST services](https://docs.activeviam.com/engine/java-sdk/6.2/starters/how-to/configure-rest-endpoint-security.md) ### Step 4: Query an Atoti application - [Querying Atoti](https://docs.activeviam.com/engine/java-sdk/6.2/user_guide/querying/user_guide_querying_overview.md) #### Business Front Ends - [Business Front Ends Overview](https://docs.activeviam.com/engine/java-sdk/6.2/user_guide/querying/front_ends/user_guide_querying_front_ends_overview.md) - [Querying Atoti Server with Atoti UI](https://docs.activeviam.com/engine/java-sdk/6.2/user_guide/querying/front_ends/user_guide_querying_front_ends_atoti_ui.md) - [Atoti Excel Add-in](https://docs.activeviam.com/engine/java-sdk/6.2/user_guide/querying/front_ends/user_guide_querying_front_ends_excel_add-in.md) - [Microsoft Excel](https://docs.activeviam.com/engine/java-sdk/6.2/user_guide/querying/front_ends/excel_xmla.md) - [Power BI](https://docs.activeviam.com/engine/java-sdk/6.2/user_guide/querying/front_ends/power_bi.md) - [Tableau MSSAS connector](https://docs.activeviam.com/engine/java-sdk/6.2/user_guide/querying/front_ends/tableau/tableau_mssas_connector.md) ##### Tableau Adapter - [Atoti Tableau Adapter](https://docs.activeviam.com/engine/java-sdk/6.2/user_guide/querying/front_ends/tableau/tableau_adapter.md) - [How to use Tableau Adapter](https://docs.activeviam.com/engine/java-sdk/6.2/user_guide/querying/front_ends/tableau/tableau_adapter_how_to.md) #### Query Languages - [Get Aggregate Query](https://docs.activeviam.com/engine/java-sdk/6.2/querying/get_aggregate_query.md) ##### MDX - [MDX Engine Configuration](https://docs.activeviam.com/engine/java-sdk/6.2/mdx/engine_configuration.md) - [List of Supported MDX Functions by Atoti](https://docs.activeviam.com/engine/java-sdk/6.2/mdx/mdx_functions.md) - [List of Supported MDX Operators by Atoti](https://docs.activeviam.com/engine/java-sdk/6.2/mdx/mdx_operators.md) - [MDX formats](https://docs.activeviam.com/engine/java-sdk/6.2/mdx/mdx_formatting.md) - [MDX Filtering](https://docs.activeviam.com/engine/java-sdk/6.2/mdx/mdx_filtering.md) - [MDX examples to Run Non-trivial Analysis in Atoti](https://docs.activeviam.com/engine/java-sdk/6.2/mdx/mdx_snippets.md) - [Understanding MDX CellSets](https://docs.activeviam.com/engine/java-sdk/6.2/mdx/mdx_cellset.md) - [MDX Drillthrough](https://docs.activeviam.com/engine/java-sdk/6.2/drillthrough/mdx_drillthrough.md) #### Server Endpoints - [XMLA endpoint](https://docs.activeviam.com/engine/java-sdk/6.2/endpoints/xmla.md) - [Database REST API](https://docs.activeviam.com/engine/java-sdk/6.2/rest-api/database_rest_api.md) - [Cube REST API](https://docs.activeviam.com/engine/java-sdk/6.2/rest-api/atoti_rest_api.md) - [GAQ REST API](https://docs.activeviam.com/engine/java-sdk/6.2/rest-api/gaq_rest_api.md) - [Continuous GAQ REST API](https://docs.activeviam.com/engine/java-sdk/6.2/rest-api/continuous_gaq_rest_api.md) - [Data Export REST API](https://docs.activeviam.com/engine/java-sdk/6.2/rest-api/dataexport_rest_api.md) - [Atoti Websocket API](https://docs.activeviam.com/engine/java-sdk/6.2/ws-api/pivot_ws_api.md) - [ContentServer REST API](https://docs.activeviam.com/engine/java-sdk/6.2/rest-api/cs_rest_api.md) - [Diagnostics REST API](https://docs.activeviam.com/engine/java-sdk/6.2/rest-api/diagnostics_rest_api.md) - [ContentServer Websocket API](https://docs.activeviam.com/engine/java-sdk/6.2/ws-api/ws_api_contentserver.md) #### Java APIs - [Location-Based Queries](https://docs.activeviam.com/engine/java-sdk/6.2/querying/location_based_queries.md) ##### Streaming API - [Continuous Queries Overview](https://docs.activeviam.com/engine/java-sdk/6.2/cube/continuous_queries_overview.md) - [Streaming Overview](https://docs.activeviam.com/engine/java-sdk/6.2/cube/streaming_overview.md) - [Continuous Query Engine](https://docs.activeviam.com/engine/java-sdk/6.2/cube/continuous_query_engine.md) ### Configure Atoti - [Configuration Overview](https://docs.activeviam.com/engine/java-sdk/6.2/configuration/overview.md) - [Content service](https://docs.activeviam.com/engine/java-sdk/6.2/content_server/cs_overview.md) - [Internationalization](https://docs.activeviam.com/engine/java-sdk/6.2/configuration/internationalization.md) - [Java version compatibility](https://docs.activeviam.com/engine/java-sdk/6.2/configuration/java_version.md) - [Memory Management](https://docs.activeviam.com/engine/java-sdk/6.2/configuration/memory_management.md) - [Properties in Atoti Server](https://docs.activeviam.com/engine/java-sdk/6.2/properties/ap_properties.md) - [Serving Atoti on a subpath](https://docs.activeviam.com/engine/java-sdk/6.2/configuration/serving_on_a_subpath.md) ### Secure Atoti - [Atoti Security Overview](https://docs.activeviam.com/engine/java-sdk/6.2/security/security_overview.md) #### Client/Server communication - [Atoti Security: Authentication](https://docs.activeviam.com/engine/java-sdk/6.2/security/authentication.md) - [Atoti Security: Authorization and Entitlements](https://docs.activeviam.com/engine/java-sdk/6.2/security/authorization.md) #### Data access control - [Database Access Control](https://docs.activeviam.com/engine/java-sdk/6.2/security/database_access_control.md) - [Atoti Access Control](https://docs.activeviam.com/engine/java-sdk/6.2/security/atoti_access_control.md) - [Branch Permission Manager](https://docs.activeviam.com/engine/java-sdk/6.2/security/branch_permission.md) ### Operate Atoti #### Monitoring - [Monitoring Overview](https://docs.activeviam.com/engine/java-sdk/6.2/monitoring/overview.md) - [Monitoring via the Global Health Dispatcher](https://docs.activeviam.com/engine/java-sdk/6.2/monitoring/health_dispatcher.md) - [Query Execution Plan](https://docs.activeviam.com/engine/java-sdk/6.2/monitoring/query_execution_plan.md) - [Monitoring Query Execution](https://docs.activeviam.com/engine/java-sdk/6.2/monitoring/monitoring_query_execution.md) - [JMX monitoring](https://docs.activeviam.com/engine/java-sdk/6.2/monitoring/jmx_monitoring.md) - [Off-heap memory monitoring](https://docs.activeviam.com/engine/java-sdk/6.2/monitoring/off-heap_memory.md) - [Logging overview](https://docs.activeviam.com/engine/java-sdk/6.2/monitoring/logging_overview.md) - [How to set up Observability with OpenTelemetry SDK](https://docs.activeviam.com/engine/java-sdk/6.2/monitoring/otel_how_to.md) - [Metrics Overview](https://docs.activeviam.com/engine/java-sdk/6.2/monitoring/metrics.md) - [Tracing](https://docs.activeviam.com/engine/java-sdk/6.2/monitoring/tracing.md) - [JFR events](https://docs.activeviam.com/engine/java-sdk/6.2/monitoring/jfr_events.md) #### Checkpoint and Restore - [Checkpoint and Restore an Atoti application](https://docs.activeviam.com/engine/java-sdk/6.2/crac/overview.md) - [How to Checkpoint an Atoti application](https://docs.activeviam.com/engine/java-sdk/6.2/crac/how_to_checkpoint.md) - [How to Restore an Atoti application](https://docs.activeviam.com/engine/java-sdk/6.2/crac/how_to_restore.md) - [CRaC Command-Line Options](https://docs.activeviam.com/engine/java-sdk/6.2/crac/vm_options.md) ### Reference - [API Reference (Javadoc)](https://docs.activeviam.com/engine/java-sdk/6.2/release/javadoc.md) - [REST APIs](https://docs.activeviam.com/engine/java-sdk/6.2/rest-api/rest-apis-overview.md)