Books like The making of Star trek, Deep Space Nine by Judith Reeves-Stevens

Months ago, young Jake Sisko came upon a mysterious prophecy in the ruins of B'hala, one that told of a Son destined to enter the Celestial Temple of the Prophets and return home with a lost Herald. Certain that the ancient text was intended for him, Jake entered the wormhole to bring back his father, Captain Benjamin Sisko -- missing since his final, fateful confrontation with Gul Dukat in the Fire Caves of Bajor. But Jake's quest has failed. Or so he believes. Flung across the galaxy by a power beyond his understanding, Jake is rescued by a strange ship with an even stranger alien crew. Joining them on a voyage unlike any he has ever experienced, Jake learns that his search for the truth will lead him to find the last thing he ever expected, and to discoveries far beyond his wildest imaginings. Part of the tenth anniversary celebration of Star Trek: Deep Space Nine.

Star Trek: Deep Space Nine – Millennium opens after the series finale "What You Leave Behind," following Captain Sisko as he recounts the erased War of the Prophets to the Vay'leth.

Two legendary crews of the USS Enterprise collide across time, as Captain Kirk and Captain Picard race to rescue key figures whose fates could determine the future of the Federation.