If you want your tank to stay mostly self-sufficient for 2 weeks you will need timers for the lights, good filtration, a top off system, possibly a chiller (if the house gets hot), and an automatic feeder system.
I had all of those and my tank was fine over my 2 week vacation. However, I had 2 neighbors and a friend (fish expert) occasionally check in every couple days to clean the glass/ reset the timers in the even of power outages/ check for problems. Also, its a good idea to do a water change a day or two before you leave.
It can be done but as I said, if you plan to go on a long vacation, get someone you trust to keep an eye on everything and leave contact info in the unlikely event of a major problem.