We have multiple TimeXtender projects that use the same databases for their ODX/DSA/MDWs.
What is the best way to use tables from one project in another one of the other projects? "Add External SQL Connection" seems to be an option, should this still be used if the table we want to connect to is in the same database?
Best answer by JTreadwell
View original
+5
Hi Mark, Thanks for posting.
Yes, External SQL Connection is absolutely the best option. If they are in the same db, this option will simply create views making it very efficient.
Just a tip If you are taking this approach. I'd highly recommend using different schemas in your different projects to prevent table naming collisions.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
