Re: [BangPypers] Teradata python ODBC driver
On 4 June 2013 11:37, Divya wrote: > > Hello, > > I have to connect Python based script (Python2.6) to Teradata using ODBC > driver on Linux. > > Can any one please suggest / help me to integrate. As has been mentioned before for similar requests, nobody is going to do your work for you. Have you even tried searching Google. Please tell us in more detail what the code needs to do, what your approach is, and ideally show us some code sample that you tried, tell us what did not work, and ask more specific questions. Regards, Gora ___ BangPypers mailing list BangPypers@python.org http://mail.python.org/mailman/listinfo/bangpypers
[BangPypers] Query | Automating report through Python
Hi, I have couple of reports that need to be sent during end of the day. There's single DB table, from which data is being picked and put into xcel-like tabular format and sent to specific email address. I want to understand - by using python, how to go about for automating this task? What are the key points to be considered here? This is just for learning purpose, hence I am looking forward to similar examples, if someone can guide me. Thanks in advance. Regards, Fagun ___ BangPypers mailing list BangPypers@python.org http://mail.python.org/mailman/listinfo/bangpypers
Re: [BangPypers] Query | Automating report through Python
Fagun Bhavsar writes: > Hi, > > I have couple of reports that need to be sent during end of the > day. There's single DB table, from which data is being picked and put > into xcel-like tabular format and sent to specific email address. > > I want to understand - by using python, how to go about for automating > this task? What are the key points to be considered here? This is just > for learning purpose, hence I am looking forward to similar examples, > if someone can guide me. It seems quite straightforward. Connect to the db, run your query, convert the response into a csv or tsv (there is a csv module in the standard libary) file and then email (there's an smtp module in the stdlib too) it. It'd look the same in most scripting languages. What exactly are you looking for? [...] -- Cordially, Noufal http://nibrahim.net.in ___ BangPypers mailing list BangPypers@python.org http://mail.python.org/mailman/listinfo/bangpypers
Re: [BangPypers] Query | Automating report through Python
On Tue, Jun 4, 2013 at 2:19 PM, Noufal Ibrahim wrote: > Fagun Bhavsar writes: > >> Hi, >> >> I have couple of reports that need to be sent during end of the >> day. There's single DB table, from which data is being picked and put >> into xcel-like tabular format and sent to specific email address. >> >> I want to understand - by using python, how to go about for automating >> this task? What are the key points to be considered here? This is just >> for learning purpose, hence I am looking forward to similar examples, >> if someone can guide me. > > It seems quite straightforward. Connect to the db, run your query, > convert the response into a csv or tsv (there is a csv module in the > standard libary) file and then email (there's an smtp module in the > stdlib too) it. It'd look the same in most scripting languages. In addition to the above, run it off as a cron job (on *nix machines) at the end of your day. svaksha ॥ http://svaksha.com ॥ ___ BangPypers mailing list BangPypers@python.org http://mail.python.org/mailman/listinfo/bangpypers
Re: [BangPypers] Query | Automating report through Python
Thanks a lot @Noufal and @Svaksha. As @Noufal mentioned, I was looking forward to the steps in order to break a problem in small chunks and then to work on it. Regards, Fagun On Tuesday 04 June 2013 02:26 PM, स्वक्ष wrote: On Tue, Jun 4, 2013 at 2:19 PM, Noufal Ibrahim wrote: Fagun Bhavsar writes: Hi, I have couple of reports that need to be sent during end of the day. There's single DB table, from which data is being picked and put into xcel-like tabular format and sent to specific email address. I want to understand - by using python, how to go about for automating this task? What are the key points to be considered here? This is just for learning purpose, hence I am looking forward to similar examples, if someone can guide me. It seems quite straightforward. Connect to the db, run your query, convert the response into a csv or tsv (there is a csv module in the standard libary) file and then email (there's an smtp module in the stdlib too) it. It'd look the same in most scripting languages. In addition to the above, run it off as a cron job (on *nix machines) at the end of your day. svaksha ॥ http://svaksha.com ॥ ___ BangPypers mailing list BangPypers@python.org http://mail.python.org/mailman/listinfo/bangpypers ___ BangPypers mailing list BangPypers@python.org http://mail.python.org/mailman/listinfo/bangpypers
