We report single crystal X-ray investigations of three d10 metal based oxalate-sulfite inorganic-organic hybrid open framework materials, namely [Zn2(SO3)2(C2O4)0.5(C6N2H13)]·(H2O)2, 1, [C4N2H12]0.5[Zn2(SO3)2(C2O4)0.5(H2O)2], 2 and [C4N2H12][Cd2(SO3)2(C2O4)(H2O)]·H2O, 3 which show layered and three dimensional structures with different organic templates. These materials were synthesized under hydrothermal conditions and characterized by techniques such as single crystal X-ray diffraction, dipole moment calculations, FTIR, powder X-ray diffraction (PXRD), thermogravimetric analysis (TGA) and differential scanning calorimetry (DSC). The common feature for 1 and 2 is the interconnection of embedded zinc-sulfite chains via oxalate anions in the framework and in 3, cadmium-oxalate chains are interconnected via sulfite anions. The coordination geometries of metal(ii) ions vary significantly resulting in a ladder-like layered structure in the case of 1, a 3D framework in case of 2 and a layered structure with an embedded one-dimensional channel in 3. The observed structures can also be partly attributed to the influence exerted by the presence of different structure directing agents (SDA) in the lattice. The dipole moments for metal polyhedra 1, 2 and 3 were calculated from bond valence analyses and are 2.39 D for Zn(1)O4N polyhedra and 1.66 D for Zn(2)O4 polyhedra in 1, 24.90 D for Zn(1)O6 and 29.52 D for Zn(2)O4 in 2 and 5.82 D for Cd(1)O7 and 2.90 D for Cd(2)O6 in 3.