![]() Making an ODBC connection to Neo4j via Excel for Mac, via ODBC.In addition to Power BI, this driver connection can also be used to connect any ODBC-compliant application to Neo4j and its JDBC BI connector (i.e., Excel, Access, Tableau, Qlik Sense, etc.). Once loaded, you can build visualizations using data from your Neo4j instance. If Successful, a table showing results will be populated. Then, double click on ODBC, or click on Connect.Ĭlick on Advanced Options, enter the SQL Query that you want to return in PowerBI, and click OK. Open PowerBI, click Get Data, and find ODBC. If a successful connection has been made, you can now use this ODBC data source name with PowerBI. Optionally, you can build your JDBC source connection string by clicking on the … button.Ĭlick Next until you reach the final page. Name your new data source, and click Next. Provide a name for your Data Source, a description (optional), and click Next. ![]() Select OpenLink Lite for JDK 1.5 (Unicode or ANSI), and click Finish. Knowledge of the port number used for Bolt requests (Default: 7687)Ĭreating a Data Source Setting Up an ODBC DSN.OpenLink Software ODBC-JDBC Bridge Driver ( Free Evaluation, Installation Guide).This article shows how to use OpenLink Software’s ODBC-JDBC Bridge to extend the BI Connector’s reach to ODBC-compliant applications, such as Microsoft Power BI. Neo4j’s BI Connector enables users to send and receive SQL-centric query data using Java Database Connectivity (JDBC), and JDBC compliant applications. ![]()
0 Comments
Leave a Reply. |