仅在查询中从 SQL Server 访问远程 Oracle？ （水晶报告命令）
我们面临着过于严格的使用限制的特殊挑战，我正在努力找到一种方法来完成它。
我们的数据位于两个位置、不同的平台上。我们正在从应用程序表中提取数据，并且不允许我们创建自己的视图/过程/等。
有没有办法从 SQL Server 查询中运行对远程 Oracle DB 的查询？
为了使问题更加复杂，我们必须使其通过 Crystal Reports 数据库命令运行。
我们在 BOXI 平台上定义了 ODBC 连接（使用 Oracle ODBC 进行 Oracle 连接）。
我希望使用 SQL WITH 子句构建内存视图（由于缺乏更好的术语）：
- 首先从本地 SQL Server 系统中提取一些电路 ID，
- 根据这些电路 ID 从远程 Oracle 中提取票号系统，
- 从 SQL Server 系统中提取我们的核心数据，与票证数据相结合，并将其作为结果数据集返回到 Crystal。
如果我们有自己的空间，这将是微不足道的。
BOXI 不允许我们创建多服务器宇宙。
We have a peculiar challenge with overly-strict use restrictions, and I'm trying to find a way to accomplish it.
We have data in two locations, on different platforms. We are extracting data from application tables, and we aren't allowed to create our own views/procs/etc.
Is there a way to run a query into a remote Oracle DB from within an SQL Server query?
To further complicate issues, we have to make it run through a Crystal Reports database command.
We have ODBC connections defined at the BOXI platform (using Oracle ODBC for the Oracle connection).
I am hoping to use the SQL WITH clause to build in-memory views (for lack of a better term) to:
- Initially extract some circuit IDs from the local SQL Server system,
- Extract ticket numbers based on those circuit IDs, from the remote Oracle system,
- Extract the core of our data from the SQL Server system, joined with the ticket data and return that to Crystal as a result dataset.
If we had our own space, this would be trivial.
BOXI doesn't let us do multiple-server universes.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您需要某种方式来编写和存储连接字符串，但听起来您无法做到这一点。
如果您无法对任一源系统进行任何更改，您可以尝试创建 MS Access DB 并使用链接表引入您需要的所有信息，并从中运行 Crystal Report。然后，您只需确保运行此程序的计算机具有能够连接的 ODBC 驱动程序，这些驱动程序的配置非常简单。
You would need to some way to write and store connection strings, but it doesn't sound like you're able to do this.
If you can't make ANY changes to either source system, you might try creating an MS Access DB and using linked tables to bring in all the information you need and have your Crystal Report run from that. You would then only need to make sure that the machine you're running this on has the ODBC drivers to be able to connect, which are simple enough to configure.