Integrate SQL Database in amber

Follow these steps to securely connect your SQL database to amber so your teams can query data using natural language.


Set up SQL Database (Beta)

Questions about how amber features work? Find usage tips, best practices, and solutions by category.

Changelog

Roadmap

This guide walks you through using amberSearch Platform step by step, from setup to everyday team use.

Walk-Through: Using amberSearch Platform

A quick guide to setting up the amber Platform, including prerequisites, initial configuration, and first steps to get started.

🚀 amber Platform – Setup Guide

Find out which features are available in amber Platform and which ones are part of the full amber product.

✅ amber Platform – Features Overview

FAQ's amber Platform

Welcome to amber! Read the following articles to get the most out of amberSearch.

Onboarding amber

We'll help you register, explain amberSearch and provide you with the most important resources.

Your first steps with amberSearch

FAQ's - amber

Your first login - with video instructions

Contact our support

As a project manager or mutliplier, you have a significant share in the success of how much your team exploits the potential of amberSearch. With the following articles we would like to give you everything you need to help your team succeed with amberSearch.

For multipliers and project leaders

Administrator dashboard - License assignment

This is what successful onboarding of your team looks like!

Best Practices and phases of onboarding for amber

File formats at a glance - amber supports these formats

Step-by-step guide to the company context in amberAI: what to include, how to structure it, and which common mistakes to avoid.

Creating Your Company Context – Guide & Best Practices

Search & AI Prompt Library

Here you will find both basic and advanced prompts as well as exemplary AI agents for inspiration and further development.

Agent Library (Advanced)

In the prompt library, you’ll find ready-to-use example queries for various business functions—including Marketing, HR, Sales, Engineering, Data Analysis, and Webinars. These prompts help you quickly surface relevant information from internal documents, presentations, or reports and make targeted use of your enterprise search capabilities.

Prompt library (AI Dialog)

The search terms help you find relevant information from internal documents, presentations, or reports more quickly and make targeted use of your enterprise search capabilities.

Examples of search terms (document search) 

The Excel upload feature in amber lets you upload Excel files and interact directly with the data inside them. Whether you want to analyze trends, extract specific information, or summarize data, this feature makes your workday much easier. Below, you’ll find practical examples of how you can use this feature effectively in the office.

Excel-Upload-Function: Prompt-Examples

Your intelligent AI assistant for work!  ---  Disclaimer: If a function is not available for you, contact your IT administrator to ask for activation.

amberAI

amberAI is your intelligent assistant for a wide range of tasks, from answering questions to generating creative ideas. Whether you need help with research, writing, or technical issues, amberAI is here to assist you.

Chatting with amberAI

The selection of language models is dynamically updated with upcoming updates.

Language models overview

amberAI - Core functions worth knowing

Get general answers in the AI dialogue

The secure solution for your company

Upload function: Easy access to your documents and images

Your intelligent bot to chat with your documents

The Top 5 Use-Cases for the amberAI Document Chat

With the Web Search feature in the amberSearch AI chat, you can now retrieve information specifically from the public web — directly within the conversation with the AI. This feature is particularly helpful when you are looking for answers to questions that are not covered by your internal company knowledge.

Websearch with amber AI

AI-generated answers for every search

Jump quickly and easily to the amber search bar

Prompt suggestions for you

🖌️Generating and Analyzing Images with amberAI

Search Documents Directly in Chat and Chat About Them

Create Files with amberAI (Word, Excel, PowerPoint and more)

Pin Chats and Share with Colleagues

Become the hero of your team and generate the most value with amberSearch!

Tips and tricks for using amber

M365 [without Outlook]

Your first connection with M365

The Teams integration

Teams filter

OneNote

Browser Tips and Tricks

Create a shortcut in your taskbar

Use shortcuts to start your search directly from the address bar!

Have amber as your Landing Page

Bookmark amber

General Features

Open Office documents directly in the respective desktop applications

Unified File Directory

There are certain words missing from your query!

Tool tips

Right-click for more options

Two versions are one too many…

Searching Scanned Documents

Forward in Target Systems

The preview function

Set once, applied everywhere!

Some of our features include technology based on artificial intelligence. We have listed them here for you:

Features with AI technology

Crosslingual search & translation of results

Spell Correction

Highlights in Documents

Find out how to connect amberSearch to the systems that matter to you.

Connect all your data sources.

amber MCPs / Apps

MCP (Model Context Protocol) servers are an abstraction layer to bring external tools and capabilities into the amberAI. This guide provides an overview of how the MCP functionalities are integrated, how to manage them, and how to use them effectively.

Overview amber MCPs / Apps

Hubspot MCP / App

Control Jira & Confluence directly from amberAI – Guide for End Users

Atlassian MCP / App in amberAI for Users

Outlook MCP / App in amberAI for Users

Outlook MCP / App in amberAI for Administrators

Atlassian MCP / App in amberAI for Administrators


In General...

Find out how to connect new data sources

Network Drives

Network Drives: Open Folder and Files

First connection with network drives

Outlook in General

Forwarding to e-mails does not work

Find email histories in threads

Search your email attachments

Import .PST files into Outlook and then into amber

Outlook Exchange

Search your shared group mailboxes

Connect amberSearch with your d.velop document management system.

d.velop d3

Connect amber with d.velop

With amberSearch you can also search through Atlassians two main systems, Jira and Confluence. In this section we tell you some more details about our Jira and Confluence connectors.

Atlassian

Confluence

Jira

Connecting Confluence and Jira for Users

GitLab

Search all your Issues, Merge Requests and Gitlab Wiki Pages

Have you ever wished you could save certain templates for a chat? That’s exactly what agents are for! Provide agents with fixed instructions and different data sources to chat about specific use cases.

Agents

Agent Library

Creating Agents – Here’s How

Agent Instructions: Tips & Tricks for the perfect configuration 

Supported file types for agent upload in amber

Everything about making your search more efficient

amberSearch

amber is your central entry point when you want to find emails, documents, images, or chat messages in your company. Your access permissions remain intact — this means team members can see different results for the same query based on their rights.

Search with amber

Understanding search results

Image Search

Use amberSearch more efficiently

Searching in a specific folder

Operators

Tips and tricks at the bottom of the search results

Filter options

Resetting Filters

Optimizing Image Search

Clustering images

Use operators for image search

Whether you want to access amber from your desktop, your browser, or your SharePoint, we enable you to do exactly that

Platforms & Apps

Products

amber as an App in Teams

amber Desktop App

📧 Outlook Add-In for Users

Browser Extension

Download amber Browser Extension (Google Chrome & Microsoft Edge)

Features - amber Browser Extension

For the detailed API documentation please visit: https://developers.ambersearch.de

API & Automations

n8n is an open-source automation tool that lets you create workflows without deep programming knowledge. By connecting it with amber, you can embed enterprise search and AI-generated answers directly into automated processes — for example, in Slack bots, email workflows, or internal dashboards.

🤖n8n Workflow Integration

How to get your API Key

⌨️Quick API overview — amber 

Widgets

Include amber widgets in SharePoint pages or your intranet

An unexpected error has occurred? Read on to find out possible causes!

Troubleshooter! amber does not work!

Find out why you might have trouble using amber

My password has changed - what can I do?

Login at amber not possible

On this page you will find all the necessary information for when amber is in maintenance mode.

Maintenance Mode 

🚨Error Message:"You do not have an active license – Some features are restricted. Contact your administrator."

🚨Our systems are currently processing a large number of requests, so this feature is not available at the moment. Please try again in 5 minutes!

amber does not find my information. What can I do?

🚨Error Message: "Unavailable Answer"

🚨amber Chat Error Overview

This section is intended just for administrators as a lot of technical knowledge and administrator access rights are required to fulfill the tasks from this section. Furthermore, these instructions only apply to online systems. 

Data Source Set-Up (Administrators)

Integrate BlueSpice in amberSearch

Set up BlueSpice

Integrate Enaio in amberSearch

Set up Enaio Client

General

Set Up SSO (Single Sign On) with Okta through Saml

Set Up SSO (Single Sign On) with Microsoft through Saml

Integrate Google Drive in amberSearch

To set up the Google Drive connector you need administrator access to your Google Workspace and your Google Cloud Console.

Set Up Google Drive Connector

Integrate BookStack in amberSearch

Set up BookStack

Integrate Q.Wiki in amberSearch

Set up Q.Wiki Client

Integrate GitLab in amberSearch

SetUp GitLab

Integrate Plone in amberSearch

How to provide API Access to amberSearch through Zope

Set up Plone Client

Integrate ConSense in amberSearch

SetUp ConSense Client

This section will help you to make amberSearch widely available to your users. There are several options on how to integrate amberSearch into your system which are explained here.

Integrate amberSearch in other applications

amberSearch Desktop Application deployment and configuration

Teams app (for administrators)

Integrate our Chat Widget into your Website

Integrate amberSearch via IFrame into different systems!

Chrome & Edge Plugin: Rollout for the Entire Company (Administrators)

📧 amber Outlook Add-in – Administrator 

Learn, how to connect amberSearch with your M365.
If you need assistance please reach out to us via it@ambersearch.de

Integrate Microsoft M365 in amberSearch

amber | Help Center