Method, system, and apparatus for discovering and connecting to data sources
    2.
    发明授权
    Method, system, and apparatus for discovering and connecting to data sources 有权
    用于发现和连接到数据源的方法,系统和设备

    公开(公告)号:US07558799B2

    公开(公告)日:2009-07-07

    申请号:US10858190

    申请日:2004-06-01

    IPC分类号: G06F17/30

    摘要: A method, system, and apparatus for discovering and connecting to data sources are provided. A system is provided that includes a server computer operative to maintain a centrally managed repository of data connection definitions. A client computer is also provided including an application program capable of consuming data from a data source. When a request is received by the application to connect to a data source, a list of available sources is retrieved from the server computer. If one of the data sources in the list is selected, a data connection file is retrieved and utilized to connect to the data source. If a report is opened by the application that includes a reference to a data source, the repository is utilized to confirm the connection to the data source.

    摘要翻译: 提供了用于发现和连接到数据源的方法,系统和装置。 提供了一种系统,其包括可操作以维护中央管理的数据连接定义库的服务器计算机。 还提供了包括能够从数据源消耗数据的应用程序的客户端计算机。 当应用程序接收到连接到数据源的请求时,从服务器计算机检索可用源的列表。 如果选择列表中的数据源之一,则检索数据连接文件并将其用于连接到数据源。 如果包含对数据源的引用的应用程序打开报告,则使用存储库确认与数据源的连接。

    Locating, viewing and interacting with information sources
    3.
    发明申请
    Locating, viewing and interacting with information sources 有权
    定位,查看和与信息源进行交互

    公开(公告)号:US20080021932A1

    公开(公告)日:2008-01-24

    申请号:US11490762

    申请日:2006-07-21

    IPC分类号: G06F17/30

    CPC分类号: G06F17/3056

    摘要: A user interface is provided for allowing a user to quickly and easily connect to data and other informational sources. A user can use a user interface to interact with a collection of connection files to quickly and easily connect to various data sources and other informational sources. The user interface is configured to make data sources available at a glance, providing a user with a convenient and comprehensive display of the data sources. The user interface is designed to be a simplified experience for data import that is helpful to both novice and more experienced users in that the data is presented simply without a lot of extraneous information.

    摘要翻译: 提供了一种用户界面,用于允许用户快速方便地连接到数据和其他信息来源。 用户可以使用用户界面与连接文件的集合进行交互,以便快速方便地连接到各种数据源和其他信息源。 用户界面被配置为使数据源可以一目了然,为用户提供方便和全面的数据源显示。 用户界面被设计为简化的数据导入体验,有助于新手和更有经验的用户,因为数据简单地呈现,无需大量的无关信息。

    Autocompleting with queries to a database
    4.
    发明申请
    Autocompleting with queries to a database 有权
    自动完成对数据库的查询

    公开(公告)号:US20070055922A1

    公开(公告)日:2007-03-08

    申请号:US11222928

    申请日:2005-09-08

    IPC分类号: G06F17/00

    摘要: An autocomplete method and system provides suggested completions for partial data entries based upon predefined coordinates, operands and/or commands. In one embodiment, the partial data entry may be in an active cell of a spreadsheet and the predefined coordinates may be queried from a separate, preconfigured, multi-dimensional database linked to the active cell or the spreadsheet.

    摘要翻译: 自动完成方法和系统根据预定义的坐标,操作数和/或命令提供部分数据条目的建议完成。 在一个实施例中,部分数据条目可以在电子表格的活动单元中,并且可以从链接到活动单元或电子表格的单独的,预配置的多维数据库中查询预定坐标。

    Autocompleting with queries to a database
    5.
    发明授权
    Autocompleting with queries to a database 有权
    自动完成对数据库的查询

    公开(公告)号:US08234293B2

    公开(公告)日:2012-07-31

    申请号:US11222928

    申请日:2005-09-08

    IPC分类号: G06F17/30 G06F17/00 G06F17/20

    摘要: An autocomplete method and system provides suggested completions for partial data entries based upon predefined coordinates, operands and/or commands. In one embodiment, the partial data entry may be in an active cell of a spreadsheet and the predefined coordinates may be queried from a separate, preconfigured, multi-dimensional database linked to the active cell or the spreadsheet.

    摘要翻译: 自动完成方法和系统根据预定义的坐标,操作数和/或命令提供部分数据条目的建议完成。 在一个实施例中,部分数据条目可以在电子表格的活动单元中,并且可以从链接到活动单元或电子表格的单独的,预配置的多维数据库中查询预定坐标。

    Locating, viewing and interacting with information sources
    6.
    发明授权
    Locating, viewing and interacting with information sources 有权
    定位,查看和与信息源进行交互

    公开(公告)号:US07788259B2

    公开(公告)日:2010-08-31

    申请号:US11490762

    申请日:2006-07-21

    CPC分类号: G06F17/3056

    摘要: A user interface is provided for allowing a user to quickly and easily connect to data and other informational sources. A user can use a user interface to interact with a collection of connection files to quickly and easily connect to various data sources and other informational sources. The user interface is configured to make data sources available at a glance, providing a user with a convenient and comprehensive display of the data sources. The user interface is designed to be a simplified experience for data import that is helpful to both novice and more experienced users in that the data is presented simply without a lot of extraneous information.

    摘要翻译: 提供了一种用户界面,用于允许用户快速方便地连接到数据和其他信息来源。 用户可以使用用户界面与连接文件的集合进行交互,以便快速方便地连接到各种数据源和其他信息源。 用户界面被配置为使数据源可以一目了然,为用户提供方便和全面的数据源显示。 用户界面被设计为简化的数据导入体验,有助于新手和更有经验的用户,因为数据简单地呈现,无需大量的无关信息。

    Management of connections to external data
    7.
    发明授权
    Management of connections to external data 有权
    管理与外部数据的连接

    公开(公告)号:US07653731B2

    公开(公告)日:2010-01-26

    申请号:US11361502

    申请日:2006-02-24

    CPC分类号: H04L67/02 H04L43/06

    摘要: Embodiments of present application treat Connection Information Files contained in an instance of an application, such as a workbook, as independent objects and multiple data objects, such as data summary tables, may link to one Connection Information File. Maintaining Connection Information Files as independent objects within an instance of an application provides the ability to modify a connection to an external data source and have that modification applied to all linked data objects without having to modify each data object individually. Additionally, a user may view a complete list of all Connection Information Files that exist within a workbook and easily add, delete, or modify those Connection Information Files.

    摘要翻译: 本申请的实施例将连接信息包含在诸如工作簿的应用的实例中的文件作为独立对象和诸如数据摘要表的多个数据对象可以链接到一个连接信息文件。 维护连接信息文件作为应用程序实例中的独立对象提供了修改与外部数据源的连接的能力,并将该修改应用于所有链接的数据对象,而无需单独修改每个数据对象。 此外,用户可以查看工作簿中存在的所有连接信息文件的完整列表,并轻松添加,删除或修改这些连接信息文件。

    Management of connections to external data
    8.
    发明申请
    Management of connections to external data 有权
    管理与外部数据的连接

    公开(公告)号:US20070204019A1

    公开(公告)日:2007-08-30

    申请号:US11361502

    申请日:2006-02-24

    IPC分类号: G06F15/173

    CPC分类号: H04L67/02 H04L43/06

    摘要: Embodiments of present application treat Connection Information Files contained in an instance of an application, such as a workbook, as independent objects and multiple data objects, such as data summary tables, may link to one Connection Information File. Maintaining Connection Information Files as independent objects within an instance of an application provides the ability to modify a connection to an external data source and have that modification applied to all linked data objects without having to modify each data object individually. Additionally, a user may view a complete list of all Connection Information Files that exist within a workbook and easily add, delete, or modify those Connection Information Files.

    摘要翻译: 本申请的实施例将连接信息包含在诸如工作簿的应用的实例中的文件作为独立对象和诸如数据摘要表的多个数据对象可以链接到一个连接信息文件。 维护连接信息文件作为应用程序实例中的独立对象提供了修改与外部数据源的连接的能力,并将该修改应用于所有链接的数据对象,而无需单独修改每个数据对象。 此外,用户可以查看工作簿中存在的所有连接信息文件的完整列表,并轻松添加,删除或修改这些连接信息文件。