There is lots of information out there on how to do this, unfortunately, it all looks like Greek to me.
I need a connection to a DB so I can add and use tables and featureclasses contained within it. I have tried calling import cx_oracle in python win 32 build 218 but I get the response no module named cx_oracle.
We use Toad for Oracle version 18.104.22.168. Oracle version 11.2 I think.
import arcpy, cx_Oracle #con = cx_Oracle.connect('p747/p747.tfc@ORATFC01') #print con.version #con.close() # Set variables folderName = r"c:\connectionFiles" fileName = "oratfc01.sde" serverName = "ORATFC01" serviceName = "ORATFC01" databaseName = "p747" authType = "DATABASE_AUTH" username = "p747" password = "p747.abc" saveUserInfo = "SAVE_USERNAME" versionName = "SDE.DEFAULT" saveVersionInfo = "SAVE_VERSION" # Process: Use the CreateArcSDEConnectionFile function arcpy.CreateArcSDEConnectionFile_management (folderName, fileName, serverName, serviceName, databaseName, authType, username, password, saveUserInfo, versionName, saveVersionInfo)