如何从 Siebel 检索数据到 mdb
我是 Siebel CRM 的新手。因此，我需要将按对象（帐户、潜在客户、联系人等）分开的数据检索到 Access (mdb) 中。请告诉我如何做以及任何建议..感谢支持
I am a newbie with Siebel CRM. So I need to retrieve data separate by object (account, lead, contact, …) into Access (mdb). Please advice me how to and any advise.. Thanks for support
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
没有现成的工具可用于将数据导出到 Access 数据库。但是，Siebel 数据存储在某些 RDBMS 中 — 哪一个取决于您的设置。您需要使用 ODBC 连接将数据从 Siebel 数据库导入到 Access 数据库。这是一个示例。
There's no out-of-the-box tool for exporting your data to an Access database. However, Siebel data is stored in some RDBMS -- which one depends on your setup. You'll need to import data from your Siebel database to the Access database using an ODBC connection. Here's an example.
大多数实体都存储在自己的表中 - S_PARTY 和 S_ORG_EXT 保存帐户数据； S_OPTY 保存潜在客户等 - 请参阅 Siebel Tools 或 Siebel Data Model Reference。
每个表还具有自己的过滤器，用于按类型（例如联系人与员工）划分表记录，并且表之间的关系在数据库级别上并不完全清晰（您需要当地的 Siebel 开发人员来完成此操作），
如果您如果没有本地 Siebel 开发人员，那么您也许可以从专用 Web 客户端假脱机 SQL 并找出表之间的关系 - 但这将是相当大量的工作
Most entities are stored in their own tables - S_PARTY and S_ORG_EXT hold Account data; S_OPTY holds Leads, etc. - see Siebel Tools or the Siebel Data Model Reference.
Each of the tables also has it's own filters to divide the tables records by type (e.g. Contacts vs. Employees) and the relationships between tables is not totally clear from the database level (you'll need your local Siebel developer for that)
if you don't have a local Siebel developer then you might be able to spool SQL from the dedicated web client and figure out how tables are related from there - but this would be quite a lot of work
从您的问题中不清楚您需要获得什么级别的数据详细信息。
如果您想获得基本的、GUI 可用的详细信息，那么屏幕中的大多数列表视图（活动、潜在客户、联系人、客户、机会等）都允许您将显示在列表中的记录列表导出到 *.CSV 格式文件。根据您运行的任何查询进行查看。然后您可以将 *.csv 导入 MS Access。
如果您需要主键或外键或相关表等详细信息，则需要使用 SQL 工具和锻炼查询来从服务器数据库中获取该数据，正如其他人在此提到的那样。
It is not clear from your question what level of data detail you need to get.
If you want to get basic, GUI-available details, then most list views in the screens (Activities, Leads, Contacts, Accounts, Opportunities, etc) allow you to export to a *.CSV format file the list of records shown in the view based on whatever query you have run. You can then import the *.csv into MS Access.
If you need the details like primary keys or foreign keys, or related tables, you will need to use a SQL tool and workout queries to get that data out of the server database as others have here mentioned.