![]() Note that COP Discovery is not implemented yet. Specify the Teradata Database hostname as the host component of the URL. import sqlalchemyĪfter importing the sqlalchemy package, your Python script calls the sqlalchemy.create_engine function to open a connection to the Teradata Database. Your Python script must import the sqlalchemy package in order to use the Teradata SQL Driver Dialect for SQLAlchemy. ![]() Using the Teradata SQL Driver Dialect for SQLAlchemy While the file can be viewed with any text file viewer or editor, your viewing experience will be best with an editor that understands Markdown format. The README.md file is a plain text file containing the documentation for the Teradata SQL Driver Dialect for SQLAlchemy. This permits you to view the documentation offline, when you are not connected to the Internet. When the Teradata SQL Driver Dialect for SQLAlchemy is installed, the README.md file is placed in the teradatasqlalchemy directory under your Python installation directory. When the Teradata SQL Driver Dialect for SQLAlchemy is installed, the LICENSE file is placed in the teradatasqlalchemy directory under your Python installation directory. Use of the Teradata SQL Driver Dialect for SQLAlchemy is governed by the License Agreement for the Teradata SQL Driver Dialect for SQLAlchemy. Py -3 -m pip install -no-cache-dir -U teradatasqlalchemy Pip install -no-cache-dir -U teradatasqlalchemy When upgrading to a new version of the Teradata SQL Driver Dialect for SQLAlchemy, you may need to use pip install's -no-cache-dir option to force the download of the new version. Use pip to install the Teradata SQL Driver Dialect for SQLAlchemy. Added support for below Teradata's datatypes:.Added ART Table support for get_columns API.Release Notes: teradatasqlalchemy 17.0.0.5 Using the Teradata SQL Driver Dialect for SQLAlchemy.32-bit Python is not supported.įor community support, please visit the Teradata Community forums.įor Teradata customer support, please visit Teradata Access.Ĭopyright 2023 Teradata. This package requires 64-bit Python 3.4 or later, and runs on Windows, macOS, and Linux. This package enables SQLAlchemy to connect to the Teradata Database. You can then query the tables.Teradata SQL Driver Dialect for SQLAlchemy 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:ldap:User=Domain\BobF Password=bob123456 Server=10.0.1.1 Port=389 Īfter establishing a connection, the wizard will close and the connection will be available in the connections panel. Note: Specifying a narrow BaseDN may greatly increase performance for example, cn=users,dc=domain will only return results contained within cn=users and its children.įor assistance in constructing the JDBC URL, use the connection string designer built into the LDAP JDBC Driver. Server information, including the IP or host name of the Server, as well as the Port.īaseDN: This will limit the scope of LDAP searches to the height of the distinguished name provided.Valid User and Password credentials (e.g., Domain\BobF or cn=Bob F,ou=Employees,dc=Domain).To establish a connection, the following properties under the Authentication section must be provided: The JDBC URL begins with jdbc:ldap: 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. ![]() 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:.Open the RazorSQL application and, in the Connections menu, select Add Connection Profile -> Other -> JDBC.This article shows how to connect to LDAP using wizards in RazorSQL.Ĭreate a JDBC Data Source for LDAP Objects The CData JDBC Driver for LDAP enables standards-based access from third-party tools, from wizards in IDEs to data management and analysis tools.
0 Comments
Leave a Reply. |