You can translate the question and the replies:

Connecting to Denodo

How do I connect to Denodo from diferent sources ? e.g Extracting Denodo Data from Excel, SQL Server, DBP, power bi, tableau and other consumers
user
14-03-2023 05:08:55 -0400
code

1 Answer

Greetings, Hope you are doing well. Denodo offers the ability to create various type of data sources which are typically considered different types of storage systems that you would like to extract data from including excel files. For instance, adding an Excel data source in your Denodo Virtualization platform extracts data from Excel files using the Apache POI library and allows you to make use of them in the platform. The following [link](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/excel_sources/excel_sources#excel-sources) explains how you would handle excel data sources in Denodo platform. The configuration of other types of data sources including JDBC/ODBC, web services , XML/JSON files , bulk data of SQL server and other systems are detailed in the following [section](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/creating_data_sources_and_base_views). Moreover, for connecting Denodo to multiple data consumers, Denodo connect components are provided, which are designed to connect the Denodo DV platform to multiple data consumers such as analytical tools and systems including Power BI, Tableau and others listed and explained in the following [link](https://community.denodo.com/docs/html/browse/8.0/en/denodoconnects/index). Note: Denodo Excel add-in is deprecated and can be replaced by using the excel data source or by making use of denodo scheduler to perform multiple data extraction jobs. More information can be found in the following resources/ answers: [Denodo Scheduler Guide](https://community.denodo.com/docs/html/browse/8.0/en/scheduler/administration/index) [Dealing with SQL Server](https://community.denodo.com/answers/question/details?questionId=906Du00000000NbIAI&title=Access+of+Denodo+Views+from+SQL+Server+Management+console+or+DB+visualiser) Hope this helps!
Denodo Team
15-03-2023 08:51:29 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here