CN109933623A - By method, equipment and the storage medium of data source access BI tool - Google Patents
By method, equipment and the storage medium of data source access BI tool Download PDFInfo
- Publication number
- CN109933623A CN109933623A CN201811027545.6A CN201811027545A CN109933623A CN 109933623 A CN109933623 A CN 109933623A CN 201811027545 A CN201811027545 A CN 201811027545A CN 109933623 A CN109933623 A CN 109933623A
- Authority
- CN
- China
- Prior art keywords
- data
- source
- data source
- parameter field
- configuration parameter
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The disclosure belongs to big data technical field, is related to accessing data source into method, equipment and the storage medium of BI tool.The described method includes: the request of access source of new data from the user is received, wherein including the data source types of source of new data in the request;According to the data source types for the source of new data to be accessed, corresponding data source configuration parameter field is determined;User is requested to input the respective value of identified data source configuration parameter field;And according to the data source configuration parameter field and the respective value inputted, it is connected to the source of new data to be accessed.By the presently disclosed embodiments, different data resource types can be accessed into BI tool it is not necessary to modify program code.
Description
Technical field
It is the present invention relates to big data technical field, in particular to a kind of by the method, apparatus of data source access BI tool, meter
Calculate equipment and computer readable storage medium.
Background technique
BI (Business Intelligence) i.e. business intelligence, it is the solution of complete set, is used to enterprise
In existing data effectively integrated, report is fast and accurately provided and proposes decision-making foundation, enterprise is helped to make wisdom
Business business decision.
Current BI tool only has data mapping or is only limited to JDBC Datalink Interface.Present invention meaning
Know, since the parameter type that different types of data source is used in access is different, to access different types of number
According to source, need for every kind of data source customization or modification joining procedure code, it has not been convenient to the extension of data source.
Summary of the invention
One or more of in order to solve the above problem, the embodiment of the invention provides one kind for data source to be accessed BI
The method, apparatus of tool calculates equipment and computer readable storage medium.
According to a first aspect of the present application, a kind of method for data source to be accessed BI tool is provided comprising:
The request of access source of new data from the user is received, wherein including the data source class of source of new data in the request
Type;
According to the data source types for the source of new data to be accessed, corresponding data source configuration parameter field is determined;
User is requested to input the respective value of identified data source configuration parameter field;And
According to the data source configuration parameter field and the respective value inputted, it is connected to the source of new data to be accessed.
According to an exemplary embodiment, the method also includes:
According to the data source types for the source of new data to be accessed, corresponding data source query parameter field is determined;
User is requested to input the respective value of identified data source query parameter field;And
After being connected to the source of new data, according to the data source query parameter field and the correspondence inputted
Value, reads the data of the source of new data.
According to an exemplary embodiment, the method also includes:
The data source types, corresponding data source configuration parameter field and the respective value inputted are saved,
Wherein, the data source configuration parameter field includes the title of data source.
According to an exemplary embodiment, the method also includes:
Save the data source types, corresponding data source configuration parameter field and its respective value and corresponding data
Field and its respective value are inquired in source,
Wherein, the data source configuration parameter field includes the title of data source.
According to an exemplary embodiment, the method also includes:
Receive the request in access data with existing source from the user, wherein wrap in the request in the access data with existing source
Include the title in the data with existing source to be accessed;
According to the title in the data with existing source, the corresponding data source configuration parameter field and its correspondence saved is inquired
Value;
According to the corresponding data source configuration parameter field and its respective value inquired, it is connected to the data with existing
Source.
According to an exemplary embodiment, the method also includes:
According to the title in the data with existing source, corresponding data source query parameter field is determined;
Request user input or the respective value for confirming the data source query parameter field;
After being connected to the data with existing source, according to the data source query parameter field and its respective value acquisition
The data in data with existing source.
According to an exemplary embodiment, the data source types of the basis source of new data to be accessed determine corresponding number
According to source configuration parameter field, comprising:
According to the data source types for the source of new data to be accessed, the data source types-configuration parameter pair pre-saved is inquired
Table is answered, thereby determines that corresponding data source configuration parameter field.
According to an exemplary embodiment, the data source types of the basis source of new data to be accessed determine corresponding number
According to source query argument field, comprising:
According to the data source types for the source of new data to be accessed, the data source types-query argument pair pre-saved is inquired
Table is answered, thereby determines that corresponding data source query parameter field.
According to a second aspect of the present application, it provides a kind of for data source to be accessed to the device of BI tool comprising:
Receiving module is configured as: the request of access source of new data from the user is received, wherein wrapping in the request
Include the data source types of source of new data;
Configuration parameter field determining module, is configured as: according to the data source types for the source of new data to be accessed, determining
Corresponding data source configuration parameter field;
Configuration parameter value input module, is configured as: request user inputs identified data source configuration parameter field
Respective value;And
Link block is configured as: according to the data source configuration parameter field and the respective value inputted, connection
To the source of new data to be accessed.
According to an exemplary embodiment, described device further include:
Query argument field determining module, is configured as: according to the data source types for the source of new data to be accessed, determining
Corresponding data source query parameter field;
Query parameter values input module, is configured as: request user inputs identified data source query parameter field
Respective value;And
Data read module is configured as: after being connected to the source of new data, being joined according to the data source query
Digital section and the respective value inputted, read the data of the source of new data.
According to an exemplary embodiment, described device further include:
Preserving module is configured as: saving the data source types, corresponding data source configuration parameter field and its right
It should be worth and corresponding data source query field and its respective value,
Wherein, the data source configuration parameter field includes the title of data source.
According to an exemplary embodiment, described device further include:
Configuration parameter enquiry module, is configured as: in response to the received access data with existing source of the receiving module
Request, according to the title in data with existing source included in the request in the access data with existing source, inquiry is saved corresponding
Data source configuration parameter field and its respective value,
Wherein, the link block is also configured to the corresponding number inquired according to configuration parameter enquiry module
According to source configuration parameter field and its respective value, it is connected to the data with existing source.
According to an exemplary embodiment, described device further include:
Query argument Field Inquiry module, is configured as: according to the title in the data with existing source, determining corresponding number
According to source query argument field,
Wherein, the query parameter values input module is also configured to request user input or confirms the query argument
The respective value of the data source query parameter field determined by Field Inquiry module;And
Wherein, the link block is also configured to after being connected to the data with existing source, is looked into according to the data source
It askes parameter field and its respective value obtains the data in the data with existing source.
According to the third aspect of the application, a kind of calculating equipment is provided, the calculating equipment includes memory and processor,
Computer program is stored in the memory, the computer program by the processor when being executed, so that the calculating
Equipment executes any of embodiment of the method as described above.
According to the fourth aspect of the application, a kind of computer readable storage medium is provided, computer program is stored thereon with,
The computer program realizes any of embodiment of the method as described above when being executed by one or more processors.
The technical solution that embodiments herein provides can include the following benefits:
In the application each embodiment as described above and as described below, it can be connect according to the type determination of data source
The configuration parameter field of the data source entered, and the data source to be accessed is connected to according to the configuration parameter value of input, provide one
The simple and practical scheme of data source access BI tool can be accessed multiple data sources by kind it is not necessary to modify program code.
In some embodiments, data source query parameter field can also be determined according to the type of data source, and according to the inquiry of input
Parameter value obtains corresponding data from the data source connected.
It should be understood that the above general description and the following detailed description are merely exemplary, this can not be limited
It is open.
Detailed description of the invention
Fig. 1 is the exemplary flow according to the method by data source access BI tool shown in one exemplary embodiment of the application
Figure.
Fig. 2 is according to the data source cut-in method including data acquisition shown in the application another exemplary embodiment
Schematic flow diagram.
Fig. 3 is connect according to the data source including access data with existing source procedure shown in the application another exemplary embodiment
Enter the schematic flow diagram of method.
Fig. 4 is illustrated according to the composition of the device by data source access BI tool shown in one exemplary embodiment of the application
Block diagram.
Fig. 5 is the signal composition block diagram according to the calculating equipment shown in one exemplary embodiment of the application.
Specific embodiment
In order to make the objectives, technical solutions, and advantages of the present invention clearer, with reference to the accompanying drawings and embodiments, right
Exemplary embodiment of the present invention is further elaborated.In the following description when referring to the accompanying drawings, unless otherwise indicated, it is different
Same numbers in attached drawing indicate the same or similar element.The not generation of embodiment described in following exemplary embodiment
The table all embodiments consistent with the application.On the contrary, they are only and as detailed in the attached claim, this Shen
The example of the consistent device and method of some aspects please.It should be appreciated that specific embodiment described herein is used only for
It explains the present invention, is not intended to limit the present invention.
Fig. 1 is the signal stream according to the method by data source access BI tool shown in one exemplary embodiment of the application
Cheng Tu.Each step of this method embodiment can be executed by equipment that BI tool is run on it in other words by BI tool.Such as
Shown in the exemplary embodiment of Fig. 1, this method may include step:
S110, receives the request of access source of new data from the user, wherein including the number of source of new data in the request
According to Source Type.
In one example, user can be connect by locally or remotely operating the user interface of BI tool to input it
Enter the request of source of new data.For example, the menu option " access source of new data " in user interface of the user by clicking BI tool
Or " configuration source of new data " etc. realizes the request of access source of new data.In one example, menu option " the new number of access is clicked
According to source " or " configuration source of new data " etc. after, BI tool may require that the input data source types to be accessed.
S120 determines corresponding data source configuration parameter field according to the data source types for the source of new data to be accessed.
In one example, data source types-configuration parameter has been pre-saved in BI tool and corresponded to table, arranged in the table
One or more data source types and its corresponding data source configuration parameter field are gone out.The data source configuration parameter can be with
Including the access parameter for needing to use when connecting the data source, such as data source driving class, connection string, username and password etc.
Deng.Data source configuration parameter can also include the data source name for mark data source.
S130, request user input the respective value of identified data source configuration parameter field.
In one example, the source of new data type to be accessed, BI tool meeting are inputted in S110 step in response to user
Configuration parameter input page is jumped to, data source configuration parameter field determining in the step s 120 is listed, so that user is in step
The respective value of input data source configuration parameter field in rapid S130.The number for respectively corresponding four kinds of different exemplary types is shown as follows
According to the configuration parameter in source.
Example 1: the data source types to be accessed are jdbc, and data source configuration parameter field corresponding thereto includes: number
It is gone here and there according to source name, data source driving class, data source connection, the username and password of data source.
Example 2: the data source types to be accessed are Elasticsearch, data source configuration parameter word corresponding thereto
Section includes: data source name, the address of service ES and port numbers, ES services the user name of x-pack certification, ES service x-pack recognizes
Password, the character set encoding of card.
Example 3: the data source types to be accessed are Kylin, and data source configuration parameter field corresponding thereto includes: number
The password of the user name, Kylin certification that are authenticated according to source name, the address of service Kylin and port numbers, Kylin.
Example 4: the data source types to be accessed are textfile, data source configuration parameter field packet corresponding thereto
It includes: directory address where data source name, data source text file.
As can be seen that data source configuration parameter field corresponding to every kind of data source types is not identical or not fully phase
Together.
In one example, after having input configuration parameter respective value, data source parameter, corresponding number can also be saved
According to source configuration parameter field and its respective value.For example, these data are saved by clicking " preservation " button on the page, thus
If later user has input data source types or data source name, can be found according to data source types or data source name
The corresponding configuration parameter field and its respective value saved.
S140 is connected to the new number to be accessed according to the data source configuration parameter field and the respective value inputted
According to source.
As described above, including parameter required when accessing the data source in data source configuration parameter field, according to data source
Configuration parameter value, it may be connected to the source of new data, so that the source of new data is accessed BI tool.
Fig. 2 is showing according to the data source cut-in method including data acquisition shown in the application another exemplary embodiment
Meaning flow chart.In this embodiment, as shown in FIG. 2, the embodiment method can with comprising steps of
S210 determines corresponding data source query parameter field according to the data source types for the source of new data to be accessed.
In one example, data type-query argument can also have been pre-saved in BI tool and correspond to table, in the table
List one or more data source types and its corresponding data source query parameter field.In one example, data class
Type-query argument corresponds to table table corresponding with data type-configuration parameter and is merged into a corresponding table.The data source query ginseng
Number may include the data classification/title for needing the parameter used when obtaining data from the data source, such as to be obtained, inquiry
Sentence etc..
S220, request user input the respective value of identified data source query parameter field.
In one example, the source of new data type to be accessed, or response are inputted in S110 step in response to user
Data source configuration parameter value is inputted and/or saves in the step s 120 in user, BI tool can jump to query argument input
The page is listed in the query argument field determined in step S210, so that user in step S220 join by the inquiry of input data source
The respective value of digital section.In one example, query argument input page and configuration parameter input page can be in the same pages
On, it can not also be on the same page.The query argument for respectively corresponding the data source of two kinds of different exemplary types is shown as follows.
Example A: data source types jdbc, data source query parameter field corresponding thereto include: the number to be obtained
According to classification/title, data source name to be used, query statement.
Example B: data source types ElasticSearch1.x, 2.x, 5.x, data source query parameter corresponding thereto
Field includes: that the data classification/title to be obtained, data source name to be used, ES index, ES index type, ES inquiry are poly-
Close sentence.
As can be seen that data source configuration parameter field corresponding to different data Source Type is not identical or not fully phase
Together.
In one example, it after input inquiry parameter value, can be saved by clicking " preservation " button on the page
The query argument inputted, if so that later user has input data source types or data source name and can look into what is saved
It askes parameter field and its respective value provides and confirms for user.
In one example, after user input query parameter value, " preservation " button on the page can be clicked to save
The information of input can also click " obtaining data " button on the page to enter step S230.In another example, in response to
User input data source query parameter values, BI tool can be automatically into step S230.
S230 according to the data source query parameter field and is inputted after being connected to the source of new data
Respective value reads the data of the source of new data.
According to the data source query field and its respective value inputted, the data for the data source having connected can be read.?
In one example, any partial data for reading data source is specified in query argument (for example, can be by the data to be obtained
Classification/title or query statement etc. are specified), thus obtain when obtaining data be specified portions data, rather than the number
According to the total data in source.
It in one example, can be by clicking " obtaining data " on the page after the query parameter values of input data source
Button is by corresponding data acquisition to BI tool.
Fig. 3 is connect according to the data source including access data with existing source procedure shown in the application another exemplary embodiment
Enter the schematic flow diagram of method.As shown in Figure 3, the process in the access data with existing source may include step:
S310 receives the request in access data with existing source from the user, wherein the request in the access data with existing source
In include the data with existing source to be accessed title.
In one example, user can " access has number by the menu option in the user interface of click BI tool
According to source " or " using data with existing source " come issue access data with existing source request.In response to the request, BI tool can be prompted
User inputs data with existing source name to be used.
S320, according to the title in the data with existing source, inquire the corresponding data source configuration parameter field saved and
Its respective value.
In one example, it as described previously for/configured data source had been accessed, has been preserved in BI tool
Its data source types and data source configuration parameter can inquire and the data source phase according to the data source name that user inputs
Corresponding data source configuration parameter and its respective value, it is possible thereby to be connected to this according to data source configuration parameter in step S330
Data source.
S330, according to the corresponding data source configuration parameter field and its respective value inquired, be connected to it is described
There is data source.
S340 determines corresponding data source query parameter field according to the title in the data with existing source.
In one example, as described previously for used data source, it may have been preserved in BI tool
Data source name and corresponding data source query parameter field and its respective value.It, can be with according to the data source name that user inputs
Inquire the respective value of data query parameter field corresponding with the data source and last time preservation.Alternatively, according to data source
Title can inquire its data source types, and the respective queries parameter word of the data source then can be determined according to data source types
Section.
S350, request user input or the respective value for confirming the data source query parameter field.
In one example, the request in access data with existing source is inputted in response to user, BI tool can join by inquiry
Number the pages be listed in step S340 determine data source query parameter field, can also list saved (if saved
If) data source query parameter value, so that user inputs or confirms the query parameter values.
In one example, after user inputs or confirms query parameter values, " preservation " button on the page can be clicked
The information of input or confirmation is saved, " obtaining data " button on the page can also be clicked to enter step S360.Another
In example, data source query parameter value is inputted or confirmed in response to user, BI tool can be automatically into step S360.
S360 is obtained after being connected to the data with existing source according to the data source query parameter field and its respective value
Take the data in the data with existing source.
According to the another aspect of the application, the device for data source to be accessed to BI tool is also disclosed.Fig. 4 is according to this
Apply for the composition schematic block diagram of the device by data source access BI tool shown in an exemplary embodiment.The device 401 is used for
Execute each method embodiment as described above.In one example, device 401 is implemented as the equipment that BI tool is run on it
Or part of it.As shown in figure 4, the exemplary device 401 includes:
Receiving module 410, is configured as: the request of access source of new data from the user is received, wherein the request
In include source of new data data source types;
Configuration parameter field determining module 420, is configured as: according to the data source types for the source of new data to be accessed,
Determine corresponding data source configuration parameter field;
Configuration parameter value input module 430, is configured as: request user inputs identified data source configuration parameter word
The respective value of section;And
Link block 440, is configured as: according to the data source configuration parameter field and the respective value inputted,
It is connected to the source of new data to be accessed.
Embodiment according to Fig.4, device 401 can also include:
Query argument field determining module 450, is configured as: according to the data source types for the source of new data to be accessed,
Determine corresponding data source query parameter field;
Query parameter values input module 460, is configured as: request user inputs identified data source query parameter word
The respective value of section;And
Data read module 470, is configured as: after being connected to the source of new data, being looked into according to the data source
The respective value asking parameter field and being inputted, reads the data of the source of new data.
Embodiment according to Fig.4, device 401 can also include:
Preserving module 480, is configured as: save the data source types, corresponding data source configuration parameter field and
Its respective value and corresponding data source query field and its respective value,
Wherein, the data source configuration parameter field includes the title of data source.
Embodiment according to Fig.4, device 401 can also include:
Configuration parameter enquiry module 490, is configured as: having number in response to the received access of the receiving module 410
According to the request in source, according to the title in data with existing source included in the request in the access data with existing source, inquiry is saved
Corresponding data source configuration parameter field and its respective value,
Wherein, the link block 440 is also configured to the phase inquired according to configuration parameter enquiry module 490
The data source configuration parameter field and its respective value answered are connected to the data with existing source.
Embodiment according to Fig.4, device 401 can also include:
Query argument Field Inquiry module 400, is configured as: according to the title in the data with existing source, determining corresponding
Data source query parameter field,
Wherein, the query parameter values input module 460 is also configured to request user input or confirms the inquiry ginseng
The respective value of the data source query parameter field determined by digital section enquiry module 400;And
Wherein, the link block 440 is also configured to after being connected to the data with existing source, according to the data
Source query argument field and its respective value obtain the data in the data with existing source.
Each unit/module function and the realization process and correlative detail of effect are specifically detailed in above-mentioned in above-mentioned apparatus
The realization process of step is corresponded in embodiment of the method, details are not described herein.
Installation practice in the above various embodiments can realize by way of hardware, software, firmware or combinations thereof,
And which can be implemented as an individual devices, also may be implemented as each composition units/modules and are dispersed in one or more
The logic integrated system of corresponding function is executed in a calculating equipment and respectively.
Each unit/module that the device is formed in the above various embodiments is divided according to logic function, they can be with
It is repartitioned according to logic function, such as can realize the device by more or fewer units/modules.These compositions
Units/modules can realize that they can be the independence of difference by way of hardware, software, firmware or combinations thereof respectively
Component is also possible to multiple components and combines execute integrated unit/module of corresponding logic function.The hardware, software,
The mode of firmware or combinations thereof may include: the hardware component of separation, by the functional module of programming mode realization, by that can compile
The functional module, etc. that journey logical device is realized, or with the combination of upper type.
According to an exemplary embodiment, which can be implemented as a kind of calculating equipment, which includes storage
Device and processor, computer program is stored in the memory, and the computer program makes when being executed by the processor
It obtains the processor and executes any of each method embodiment as described above, alternatively, the computer program is described
Processor makes the calculating equipment realize that component units/module of each Installation practice as described above is realized function when executing
Energy.
Processor described in above embodiment can refer to single processing unit, such as central processing unit CPU, can also
Be include multiple dispersions processing unit distributed processor system.
Memory described in above embodiment may include one or more memories, can be and calculates equipment
Internal storage, such as transient state or non-transient various memories, are also possible to be connected to calculating equipment by memory interface
External memory.
Fig. 5 shows the signal composition block diagram of such exemplary embodiment for calculating equipment 501.As shown in figure 5,
Calculating equipment 501 may include: processor 510, communication interface 520, memory 530 and bus 540.Storage in memory 530
There is the computer program that can be executed by processor 510.Processor 510 is realized in above-described embodiment when executing the computer program
Method and device function.The quantity of memory 530 and processor 510 can be respectively one or more.Communication interface 520
For the communication between processor 510 and external equipment.
Wherein, processor 510 can be central processing unit, general processor, digital signal processor, dedicated integrated electricity
Road, field programmable gate array or other programmable logic device, transistor logic, hardware component or its any group
It closes.It, which may be implemented or executes, combines various illustrative process steps, functional unit/mould described in the disclosure of invention
Block and/or circuit.The processor is also possible to realize the combination of computing function, such as includes one or more microprocessors group
Conjunction, digital signal processor etc..
Memory 530 may include volatile memory and/or nonvolatile memory, such as non-volatile dynamic random
Access memory, phase change random access memory devices, magnetic random access memory, magnetic disk storage, Electrical Erasable can be compiled
Journey read-only memory, flush memory device, semiconductor devices (such as solid state hard disk) etc..Memory 530 optionally can also be external
Remote storage.
It is total that bus 540 can be industry standard architecture (ISA, Industry Standard Architecture)
Line, external equipment interconnection (PCI, Peripheral Component) bus or extended industry-standard architecture (EISA,
Extended Industry Standard Component) bus etc..It is total that the bus can be divided into address bus, data
Line, control bus etc..Only to be indicated with a thick line in Fig. 5, it is not intended that an only bus or a type convenient for indicating
The bus of type.Optionally, if memory 530, processor 510 and communication interface 520 are integrated on one chip, memory
530, processor 510 and communication interface 520 can complete mutual communication by internal interface.
The above each method and Installation practice are also implemented as the form of computer program, are stored in storage medium
On, and can be distributed.Therefore, according to another aspect of the present disclosure, a kind of computer program product is also provided, the computer journey
Sequence product is stored on computer readable storage medium, and realize when being executed by processor each method as described above and
Any of Installation practice.According to the another aspect of the disclosure, a kind of computer readable storage medium is also provided, is deposited thereon
The computer program executed for processor is contained, the computer program is realized as described above each when being executed by processor
Any of method and apparatus embodiment.
The computer readable storage medium can be any finger that can be kept and store and can be used by instruction execution equipment
The tangible device of order.For example, it can be ,-- but is not limited to-- storage device electric, magnetic storage apparatus, light storage device, electricity
Magnetic storage apparatus, semiconductor memory apparatus or above-mentioned any appropriate combination.The more specific example of storage medium is (non-poor
The list of act) it include: portable computer diskette, hard disk, random access memory (RAM), read-only memory (ROM), erasable type
Programmable read only memory (EPROM or flash memory), static random access memory (SRAM), Portable compressed disk read-only memory
(CD-ROM), digital versatile disc (DVD), memory stick, floppy disk, mechanical coding equipment, the punching for being for example stored thereon with instruction
Card or groove internal projection structure and above-mentioned any appropriate combination.
Computer program/computer instruction as described herein can download to each meter from computer readable storage medium
Calculation/processing equipment, or outer computer is downloaded to by network, such as internet, local area network, wide area network and/or wireless network
Or External memory equipment.Network may include copper transmission cable, optical fiber transmission, wireless transmission, router, firewall, interchanger,
Gateway computer and/or Edge Server.Adapter or network interface in each calculating/processing equipment connect from network
Computer-readable program instructions are received, and forward the computer-readable program instructions, for being stored in each calculating/processing equipment
Computer readable storage medium in.
Computer program instructions described in the disclosure can be assembly instruction, instruction set architecture (ISA) instructs, machine refers to
It enables, machine-dependent instructions, microcode, firmware instructions, condition setup data or with any group of one or more programming languages
The source code or object code write are compiled in collaboration with, the programming language includes programming language-such as Smalltalk, C+ of object-oriented
+ etc., and conventional procedural programming languages-such as " C " language or similar programming language.Computer-readable program instructions
It can fully execute on the user computer, partly execute, held as an independent software package on the user computer
Part executes on the remote computer or holds on a remote computer or server completely on the user computer for row, part
Row.In situations involving remote computers, remote computer can include local area network (LAN) by the network-of any kind
Or wide area network (WAN)-is connected to subscriber computer, or, it may be connected to outer computer (such as utilize Internet service
Provider is connected by internet).In some embodiments, by the status information using computer-readable program instructions come
Personalized customization electronic circuit, such as programmable logic circuit, field programmable gate array (FPGA) or programmable logic array
(PLA), which can execute computer-readable program instructions, to realize various aspects of the invention.
Referring herein to according to the method for the embodiment of the present invention, the flow chart of device (system) and computer program product and/
Or block diagram describes various aspects of the invention.It should be appreciated that flowchart and or block diagram each box and flow chart and/
Or in block diagram each box combination, can be realized by computer-readable program instructions.
These computer-readable program instructions can be supplied to general purpose computer, special purpose computer or other programmable datas
The processor of processing unit, so that a kind of machine is produced, so that these instructions are passing through computer or other programmable datas
When the processor of processing unit executes, function specified in one or more boxes in implementation flow chart and/or block diagram is produced
The device of energy/movement.These computer-readable program instructions can also be stored in a computer-readable storage medium, these refer to
It enables so that computer, programmable data processing unit and/or other equipment work in a specific way, thus, it is stored with instruction
Computer-readable medium then includes a manufacture comprising in one or more boxes in implementation flow chart and/or block diagram
The instruction of the various aspects of defined function action.
Computer-readable program instructions can also be loaded into computer, other programmable data processing units or other
In equipment, so that series of operation steps are executed in computer, other programmable data processing units or other equipment, to produce
Raw computer implemented process, so that executed in computer, other programmable data processing units or other equipment
Instruct function action specified in one or more boxes in implementation flow chart and/or block diagram.
The flow chart and block diagram in the drawings show the system of multiple embodiments according to the present invention, method and computer journeys
The architecture, function and operation in the cards of sequence product.In this regard, each box in flowchart or block diagram can generation
One module of table, program segment or a part of instruction, the module, program segment or a part of instruction include one or more use
The executable instruction of the logic function as defined in realizing.In some implementations as replacements, function marked in the box
It can occur in a different order than that indicated in the drawings.For example, two continuous boxes can actually be held substantially in parallel
Row, they can also be executed in the opposite order sometimes, and this depends on the function involved.It is also noted that block diagram and/or
The combination of each box in flow chart and the box in block diagram and or flow chart, can the function as defined in executing or dynamic
The dedicated hardware based system made is realized, or can be realized using a combination of dedicated hardware and computer instructions.It is right
For those skilled in the art it is well known that, by hardware mode realize, by software mode realize and pass through software and
It is all of equal value that the mode of combination of hardware, which is realized,.
It, can be it is not necessary to modify program code by different data source classes by each embodiment as described above
Type accesses BI tool.
It should be noted that all the embodiments in this specification are described in a progressive manner, each embodiment weight
Point explanation is the difference from other embodiments, and the same or similar parts between the embodiments can be referred to each other.
But it will be clear for those skilled in the art that the various embodiments described above, which can according to need exclusive use or be combined with each other, to be made
With.In addition, for device embodiment, since it is corresponding with embodiment of the method, so describe fairly simple, it is related
Place referring to the corresponding part of embodiment of the method explanation.
The embodiments described above only express several embodiments of the present invention, and the description thereof is more specific and detailed, but simultaneously
Limitations on the scope of the patent of the present invention therefore cannot be interpreted as.It should be pointed out that for those of ordinary skill in the art
For, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to guarantor of the invention
Protect range.Therefore, the scope of protection of the patent of the invention shall be subject to the appended claims.
Claims (10)
1. a kind of method for data source to be accessed BI tool characterized by comprising
The request of access source of new data from the user is received, wherein including the data source types of source of new data in the request;
According to the data source types for the source of new data to be accessed, corresponding data source configuration parameter field is determined;
User is requested to input the respective value of identified data source configuration parameter field;And
According to the data source configuration parameter field and the respective value inputted, it is connected to the source of new data to be accessed.
2. the method as described in claim 1, which is characterized in that further include:
According to the data source types for the source of new data to be accessed, corresponding data source query parameter field is determined;
User is requested to input the respective value of identified data source query parameter field;And
After being connected to the source of new data, according to the data source query parameter field and the respective value inputted, read
Take the data of the source of new data.
3. the method as described in claim 1, which is characterized in that further include:
The data source types, corresponding data source configuration parameter field and the respective value inputted are saved,
Wherein, the data source configuration parameter field includes the title of data source.
4. method according to claim 2, which is characterized in that further include:
It saves the data source types, corresponding data source configuration parameter field and its respective value and corresponding data source is looked into
Field and its respective value are ask,
Wherein, the data source configuration parameter field includes the title of data source.
5. the method as claimed in claim 3 or 4, which is characterized in that further include:
Receive the request in access data with existing source from the user, wherein include wanting in the request in the access data with existing source
The title in the data with existing source of access;
According to the title in the data with existing source, the corresponding data source configuration parameter field and its respective value saved is inquired;
According to the corresponding data source configuration parameter field and its respective value inquired, it is connected to the data with existing source.
6. method as claimed in claim 5, which is characterized in that further include:
According to the title in the data with existing source, corresponding data source query parameter field is determined;
Request user input or the respective value for confirming the data source query parameter field;
After being connected to the data with existing source, obtained according to the data source query parameter field and its respective value described existing
The data of data source.
7. a kind of for data source to be accessed to the device of BI tool characterized by comprising
Receiving module is configured as: the request of access source of new data from the user is received, wherein including new in the request
The data source types of data source;
Configuration parameter field determining module, is configured as: according to the data source types for the source of new data to be accessed, determining corresponding
Data source configuration parameter field;
Configuration parameter value input module, is configured as: request user inputs pair of identified data source configuration parameter field
It should be worth;And
Link block is configured as: according to the data source configuration parameter field and the respective value inputted, being connected to and is wanted
The source of new data of access.
8. device as claimed in claim 7, which is characterized in that further include:
Query argument field determining module, is configured as: according to the data source types for the source of new data to be accessed, determining corresponding
Data source query parameter field;
Query parameter values input module, is configured as: request user inputs pair of identified data source query parameter field
It should be worth;And
Data read module is configured as: after being connected to the source of new data, according to the data source query parameter word
Section and the respective value inputted, read the data of the source of new data.
9. a kind of calculating equipment, the calculating equipment includes memory and processor, computer journey is stored in the memory
Sequence, the computer program by the processor when being executed, so that the calculating equipment is executed as appointed in claim 1 to 6
Method described in one.
10. a kind of computer readable storage medium is stored thereon with computer program, the computer program is by one or more
Such as method described in any one of claims 1 to 6 is realized when a processor executes.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811027545.6A CN109933623A (en) | 2018-09-04 | 2018-09-04 | By method, equipment and the storage medium of data source access BI tool |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811027545.6A CN109933623A (en) | 2018-09-04 | 2018-09-04 | By method, equipment and the storage medium of data source access BI tool |
Publications (1)
Publication Number | Publication Date |
---|---|
CN109933623A true CN109933623A (en) | 2019-06-25 |
Family
ID=66984500
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811027545.6A Pending CN109933623A (en) | 2018-09-04 | 2018-09-04 | By method, equipment and the storage medium of data source access BI tool |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109933623A (en) |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102629929A (en) * | 2012-04-18 | 2012-08-08 | 华为技术有限公司 | Method and system and device for obtaining data |
US20150264674A1 (en) * | 2014-03-17 | 2015-09-17 | Rohde & Schwarz Gmbh & Co. Kg | Radio-transmission system and a radio-transmission method with multiple-channel access |
CN105243333A (en) * | 2015-08-28 | 2016-01-13 | 苏州国云数据科技有限公司 | Multi-data-source remote access method |
CN106815371A (en) * | 2017-02-06 | 2017-06-09 | 浪潮通用软件有限公司 | A kind of method for reading data realized by visual configuration across data source |
CN106855889A (en) * | 2016-12-29 | 2017-06-16 | 深圳市华傲数据技术有限公司 | The development approach and device of the extemporaneous query function of the tables of data of different data sources |
CN106941730A (en) * | 2016-01-05 | 2017-07-11 | 中兴通讯股份有限公司 | The control method and device of Stochastic accessing |
US20170351741A1 (en) * | 2016-06-07 | 2017-12-07 | Sap Se | Management of data sources in database system |
-
2018
- 2018-09-04 CN CN201811027545.6A patent/CN109933623A/en active Pending
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102629929A (en) * | 2012-04-18 | 2012-08-08 | 华为技术有限公司 | Method and system and device for obtaining data |
US20150264674A1 (en) * | 2014-03-17 | 2015-09-17 | Rohde & Schwarz Gmbh & Co. Kg | Radio-transmission system and a radio-transmission method with multiple-channel access |
CN105243333A (en) * | 2015-08-28 | 2016-01-13 | 苏州国云数据科技有限公司 | Multi-data-source remote access method |
CN106941730A (en) * | 2016-01-05 | 2017-07-11 | 中兴通讯股份有限公司 | The control method and device of Stochastic accessing |
US20170351741A1 (en) * | 2016-06-07 | 2017-12-07 | Sap Se | Management of data sources in database system |
CN106855889A (en) * | 2016-12-29 | 2017-06-16 | 深圳市华傲数据技术有限公司 | The development approach and device of the extemporaneous query function of the tables of data of different data sources |
CN106815371A (en) * | 2017-02-06 | 2017-06-09 | 浪潮通用软件有限公司 | A kind of method for reading data realized by visual configuration across data source |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10049671B2 (en) | Management of voice commands for devices in a cloud computing environment | |
US10628276B2 (en) | Unit test framework for testing code in a gateway service | |
US11551123B2 (en) | Automatic visualization and explanation of feature learning output from a relational database for predictive modelling | |
US10528528B2 (en) | Supporting multi-tenant applications on a shared database using pre-defined attributes | |
US10839160B2 (en) | Ontology-based automatic bootstrapping of state-based dialog systems | |
CN109597606A (en) | Method, equipment and the storage medium of operational decision making are carried out using regulation engine | |
US20160342506A1 (en) | Data processing | |
US10612940B2 (en) | Flow meter reading with image recognition secured with mask and software connected by mobile device | |
CN104391690A (en) | Application development system and method | |
US11108871B2 (en) | Dynamic generation of network routing configuration with service requirements | |
US11509731B2 (en) | Robotic cloud computing services arbitration using orchestrator of orchestrators | |
CN110348672A (en) | Operational decision making method, apparatus calculates equipment and computer readable storage medium | |
US10171431B2 (en) | Secure message handling of an application across deployment locations | |
US10691764B2 (en) | Search engine optimization techniques | |
CN110738038A (en) | Contract text generation method, device, equipment and computer readable storage medium | |
US10268734B2 (en) | Providing search results based on natural language classification confidence information | |
US20190188259A1 (en) | Decomposing composite product reviews | |
US9948694B2 (en) | Addressing application program interface format modifications to ensure client compatibility | |
US20190156667A1 (en) | Vehicle dash cam sign reading | |
US11055213B2 (en) | Facilitating localization of code defect | |
US20180173509A1 (en) | On-demand codeset converter generation | |
US20170010927A1 (en) | Generating storage plans in storage management systems | |
CN109933623A (en) | By method, equipment and the storage medium of data source access BI tool | |
US20190179689A1 (en) | System and Method for Root Cause Analysis in Large Scale Data Curation Flows Using Provenance | |
US20230177385A1 (en) | Federated machine learning based on partially secured spatio-temporal data |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination |