added oracle test, custom producer and sample connections