import sys
import os.path as osPath
# list of jar files
listPBJdep = ["terajdbc4.jar", "tdgssconfig.jar", "tptwizard.jar"]
# Add jars
pbjDepPath = r"H:\temp\TD_jars"
# Debug
print("Adding PBJ dependencies from %s" % pbjDepPath)
for jar in listPBJdep:
    pbjPathJar = osPath.join(pbjDepPath, jar)
    if pbjPathJar not in sys.path:
        sys.path.append(pbjPathJar)
        print("PBJ dependency appended to sys path: %s" % jar)
        
print sys.path
        
import java.sql.DriverManager as DriverManager
import java.sql.SQLException as SQLException
import java.sql.Types as Types
import java.lang.Class as Class
  
srcdriver = "com.teradata.jdbc.TeraDriver"
srcurl = "jdbc:teradata://TERADATA/CHARSET=UTF8"
srcuser = "orel_da"
srcpass = 'password'
fetchsize = "10000"
Class.forName(srcdriver).newInstance() 
print('try to connect')
con = DriverManager.getConnection(srcurl+',TYPE=FASTEXPORT',srcuser,srcpass  )
print('connection sucecssful')