How to connect LDAP to Microsoft Excel
Discover how to connect LDAP to Microsoft Excel and how to integrate LDAP with other data sources to build an organization-wide data model.
WITH PIPES OR PIPES PROFESSIONAL
WITH THE LOGICAL DATA WAREHOUSE
The LDAP (Lightweight Directory Access Protocol) is a vendor-neutral, open, industry standard application protocol for maintaining and accessing distributed directory information services over an IP (Internet Protocol) network. LDAP enables access to locate organizations, individuals, and resources such as files and devices in a network, both on public Internet and on corporate intranet.
About Microsoft Excel
Excel is a spreadsheet developed by Microsoft and enables its users to do complex calculations, create charts, graphs and pivot tables and comes with a macro programming language called Visual Basic to apply more sophisticated workflows. Microsoft Excel is available for Windows, macOS, Android and iOS and offers a wide range of features to process data.
What is Data Virtuality?
Data Virtuality enables companies to build an agile BI stack in 1 day. It connects to LDAP, Microsoft Excel and more than 200 other databases and cloud services. All connected data sources can be directly queried with SQL and data can be moved into any analytical database. Customers of the Data Virtuality Logical Data Warehouse are digital businesses with the highest flexibility needs.
IMMEDIATE DATA ACCESS
Connect over 200+ databases, cloud services and files (XML, CSV, etc.) in minutes. Query data directly with your favourite business intelligence and analysis tools.
CENTRAL DATA MODEL
Build your single source of data truth and set uniform definitions for your data. Connect your business intelligence tools to Data Virtuality and make sure everyone in your organisation works with the right data.
ALL IN SQL
With Data Virtuality you can query all data sources with SQL regardless of the file format. NoSQL, CSV or XML File: We transform any connected data source in SQL.
Data Virtuality controls the exchange of data between all databases, cloud services, and analysis tools to help everyone in your organization get the right information, in real-time if needed.