Connecting
Connecting with the cdata.sage50uk Module:
The connector's module is used directly to establish a connection with the data source. It does this by using a connection string as its argument. For example:import cdata.sage50uk as mod conn = mod.connect("URL=http://localhost:5493/sdata/accounts50/GCRM/{C4C863BE-B098-4A7D-A78B-D7A92B8ADB59};User=Manager;Password=xxxxxx;")
Once the connection is created, you can use it to execute subsequent SQL queries.