Guest User

Untitled

a guest
May 8th, 2018
191
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. server='111.00.00.00'
  2. username = 'user'
  3. password = 'pwd'
  4.  
  5. udaExec = teradata.UdaExec(appName="test", version="1.0",
  6. logConsole=True)
  7.  
  8. ndw_con = udaExec.connect(method = 'odbc',authentication = "LDAP",
  9. system=server, username=username, password=password)
  10.  
  11. # SQL ALCHEMY from teradata
  12. from sqlalchemy import create_engine
  13. user = 'user'
  14. pwd = 'pwd'
  15. host = '1'11.00.00.00'
  16.  
  17. td_engine = create_engine('teradata://'+user+':'+pwd+'@'+host+':22/' )
  18.  
  19. result = td_engine.execute('select top 100 * from temp.sampledata')
  20.  
  21. td_conn = pyodbc.connect('DRIVER= .
  22. {Teradata};DBCName='+server+';UID='+username+';PWD='+ password,
  23. automcommit=True)
  24.  
  25. cursor = td_conn.cursor()
Add Comment
Please, Sign In to add comment