The present invention provides a compound having the basic structure shown by Formula (I) in which the indole ring and the pyrazolopyridine structure is bound through a substituent, a salt thereof or a solvate of either the compound or a salt of the compound, as well as a preventative agent or a therapeutic agent for non-insulin-dependent diabetes mellitus (Type 2 diabetes) or obesity containing such compound, salt or solvate as an active ingredient.