Getting into dynamics

Hey guys i am new to dynamics and want to do something different beside rigging…! some help needed.
I have created a curve made it dynamic, set the point lock to Base and play the simulation. Now i created a sphere and i want the sphere to attach with the dynamic curve in such a way that it moves along the end of the curve like a ball tied with a rope and moves with the rope’s end.

Thank You in advance…

let the dynamic curve drive a joint chain with the spline ik function and then skin or parent the ball to the last joint

Is there no other way if we make the ball a rigid body?