Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- server='111.00.00.00'
- username = 'user'
- password = 'pwd'
- udaExec = teradata.UdaExec(appName="test", version="1.0",
- logConsole=True)
- ndw_con = udaExec.connect(method = 'odbc',authentication = "LDAP",
- system=server, username=username, password=password)
- # SQL ALCHEMY from teradata
- from sqlalchemy import create_engine
- user = 'user'
- pwd = 'pwd'
- host = '1'11.00.00.00'
- td_engine = create_engine('teradata://'+user+':'+pwd+'@'+host+':22/' )
- result = td_engine.execute('select top 100 * from temp.sampledata')
- td_conn = pyodbc.connect('DRIVER= .
- {Teradata};DBCName='+server+';UID='+username+';PWD='+ password,
- automcommit=True)
- cursor = td_conn.cursor()
Add Comment
Please, Sign In to add comment