![]() Query Power BI XMLA Data and Select TablesĪfter establishing a connection, the wizard will close and the connection will be available in the connections panel. Either double-click the JAR file or execute the jar file from the command-line.įill in the connection properties and copy the connection string to the clipboard.Ī typical JDBC URL is the following: jdbc:powerbixmla:URL=powerbi:///v1.0/myorg/CData InitiateOAuth=GETANDREFRESH RazorSQL is a SQL query tool, database, SQL editor, and database management tool for Windows, macOS, Mac OS X, Linux, and Solaris. For instance, powerbi:///v1.0/myorg/CData.įor assistance in constructing the JDBC URL, use the connection string designer built into the Power BI XMLA JDBC Driver. ![]() To connect, set the Url property to a valid PowerBIXMLA workspace. The JDBC URL begins with jdbc:powerbixmla: and is followed by a semicolon-separated list of connection properties. (This property can also be set in the JDBC URL.) Driver Class: Set the driver class to . Connect to LDAP from wizards and query LDAP objects from the GUI in the RazorSQL database management tool.Driver Location: Set this property to the path to the lib subfolder in the installation directory.In the Connection Wizard that appears, set the following properties:.:) I do not know how to close this thread. Adding below line at the top solved my problem logmech LDAP Problem solved. Open the RazorSQL application and, in the Connections menu, select Add Connection Profile -> Other -> JDBC. 1 Answer Sorted by: 0 The problem was, I should have mentioned what mechanism I should be using to connect.This article shows how to connect to Power BI XMLA using wizards in RazorSQL.Ĭreate a JDBC Data Source for Power BI XMLA Data I recognize this may be a specific solution option that may not work for everyone, but the root of the problem is confirmed to be a TCP connection issue from my experience.The CData JDBC Driver for Power BI XMLA enables standards-based access from third-party tools, from wizards in IDEs to data management and analysis tools. For example on Windows: C:\WINDOWS\system32>nslookup MYDB-TEST # Īliases: # <- works I am also on a VPN and found that the actual host name in DNS didn't work, but the ALIAS available did. I had this issue today and resolved it by altering my host. The most likely cause is that some kind of networking problem prevented the driver from properly connecting to the database. In other words, the driver thought that it had established a TCP socket connection, but the TCP socket connection was probably not fully successful, because a failure occurred on the initial message handshake between the driver and the database. The stack trace indicates that a TCP socket connection was made to the database, then the driver transmitted a Config Request message to the database, then the driver timed out waiting for a Config Response message from the database. The root cause of this error is outlined here by tomnolan: _cgoexpwrap_212fad278f55_goCreateConnection _cgo_gotypes.go:240↵ at runtime.call64 asm_amd64.s:574↵ at runtime.cgocallbackg1 cgocall.go:316↵ at runtime.cgocallbackg cgocall.go:194↵ at runtime.cgocallback_gofunc asm_amd64.s:826↵ at runtime.goexit asm_amd64.s:2361↵Caused by read tcp IP:PORT->IP:PORT: wsarecv: An existing connection was forcibly closed by the remote host (*DB).Conn sql.go:1619↵ at main.goCreateConnection goside.go:275↵ at main. Open TeradataDriver.go:32↵ at database/ sql.go:600↵ at database/sql.(*DB).conn sql.go:1103↵ at database/sql. (*teradataConnection).sendAndReceive TeradataConnection.go:1397↵ at gosqldriver/teradatasql.newTeradataConnection TeradataConnection.go:180↵ at gosqldriver/teradatasql.(*teradataDriver). (*teradataConnection).makeDriverError TeradataConnection.go:1101↵ at gosqldriver/teradatasql. Failure receiving Config Response message header↵ at gosqldriver/teradatasql. Session = nnect(host=host, user=username, password=password, logmech="LDAP") Host, username, password = 'hostname', 'username', '****' The code is running fine on localhost, but once deployed on the server as part of the server code, it is throwing the error. I am trying to connect to Teradata using teradatasql module in Python.
0 Comments
Leave a Reply. |