# US 2019/0171741 A1 · Sharing artifacts with heterogeneous database connectivity > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2019/0171741 A1 - Document ID: US20190171741A1 - Status: Published application - Kind: A1 - Application number: 15/829,163 - Filed: 2017-12-01 - Published: 2019-06-06 - Earliest claimed: 2017-12-01 - Assignees: Business Objects Software Ltd. - Applicants: Business Objects Software Limited - Inventors: Alain CHARROUX - Web page: https://patentgrep.com/patent/US20190171741A1 ## CPC - G06F 16/2433: {Query languages} - G06F 16/21: Design, administration or maintenance of databases - G06F 16/2452: Query translation - G06F 16/252: {between a Database Management System and a front-end application} - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract According to some embodiments, an abstraction engine may determine a data manipulation definition generated by a creator platform to accesses a database via a first connection protocol (e.g., ODBC). The abstraction engine may then automatically analyze the data manipulation definition to discover a connectivity parameter (e.g., a DSN, a DBMS type, a DBMS host name, a port, etc.) associated with the access to the database via the first connection protocol. The data manipulation definition may then be stored along with the connectivity parameter as a meta-connection into a metadata repository. A consuming platform may retrieve the meta-connection from the metadata repository translate the meta-connection into the database manipulation definition to accesses the database via a second connection protocol (e.g., JDBC). ## Claims ### Claim 1 A system to share artifacts with heterogeneous database connectivity, comprising: (a) a metadata repository storing electronic records; and (b) an abstraction engine including a computer processor configured to. (i) determine a data manipulation definition generated by a creator platform to accesses a database via a first connection protocol, (ii) automatically analyze the data manipulation definition to discover a connectivity parameter associated with the access to the database via the first connection protocol, and (iii) store the data manipulation definition along with the connectivity parameter as a meta-connection into the electronic records of the metadata repository. ### Claim 2 (depends on 1) The system of claim 1, wherein the data manipulation definition is to be translated into Structured Query Language (“SQL”) upon utilization. ### Claim 3 (depends on 1) The system of claim 1, wherein the first connection protocol is associated with at least one of Open Database Connectivity (“ODBC”), and (ii) Java Database Connectivity (“JDBC”). ### Claim 4 (depends on 1) The system of claim 1, wherein a plurality of connectivity parameters are discovered and stored as the meta-connection. ### Claim 5 (depends on 4) The system of claim 4, wherein the plurality of parameters include at least one of: (i) a Data Source Name (“DSN”), (ii) a Database Management System (“DBMS”) type, (iii) a DBMS host name, and (iv) a port. ### Claim 6 (depends on 1) The system of claim 1, further comprising: (c) a consuming platform adapted to: (iv) retrieve the meta-connection from the metadata repository, and (v) translate the meta-connection into the database manipulation definition to accesses the database via a second connection protocol. ### Claim 7 (depends on 6) The system of claim 6, wherein the consuming platform is further adapted to: (vi) execute the database manipulation definition. ### Claim 8 (depends on 6) The system of claim 6, wherein at least one of the abstraction engine and the consuming platform are associated with: (i) automated analytics, (ii) expert analytics, (iii) legacy automated analytics, (iv) an automated analytics kernel, (v) an automated analytics server, and (vi) a predictive factory. ### Claim 9 A computer-implemented method to share artifacts with heterogeneous database connectivity, comprising: determining, by a computer processor of an abstraction engine, a data manipulation definition generated by a creator platform to accesses a database via a first connection protocol; automatically analyzing, by the computer processor, the data manipulation definition to discover a connectivity parameter associated with the access to the database via the first connection protocol; and storing the data manipulation definition along with the connectivity parameter as a meta-connection into a metadata repository. ### Claim 10 (depends on 9) The method of claim 9, wherein the data manipulation definition is to be translated into Structed Query Language (“SQL”) upon utilization. ### Claim 11 (depends on 9) The method of claim 9, wherein the first connection protocol is associated with at least one of Open Database Connectivity (“ODBC”), and (ii) Java Database Connectivity (“JDBC”). ### Claim 12 (depends on 9) The method of claim 9, wherein a plurality of connectivity parameters are discovered and stored as the meta-connection. ### Claim 13 (depends on 12) The method of claim 12, wherein the plurality of parameters include at least one of: (i) a Data Source Name (“DSN”), (ii) a Database Management System (“DBMS”) type, (iii) a DBMS host name, and (iv) a port. ### Claim 14 (depends on 9) The method of claim 9, further comprising: retrieving, by a consuming platform, the meta-connection from the metadata repository; and translating, by the consuming platform, the meta-connection into the database manipulation definition to accesses the database via a second connection protocol. ### Claim 15 (depends on 14) The method of claim 14, further comprising: executing, by the consuming platform, the database manipulation definition. ### Claim 16 (depends on 14) The method of claim 14, wherein at least one of the abstraction engine and the consuming platform are associated with: (i) automated analytics, (ii) expert analytics, (iii) legacy automated analytics, (iv) an automated analytics kernel, (v) an automated analytics server, and (vi) a predictive factory. ### Claim 17 A non-transitory, computer-readable medium storing program code, the program code executable by a computer processor to cause the processor to perform a method to share artifacts with heterogeneous database connectivity, the method comprising: determining a data manipulation definition generated by a creator platform to accesses a database via Open Database Connectivity (“ODBC”); automatically analyzing the data manipulation definition to discover a Database Management System (“DBMS”) type, a DBMS host name, and a port associated with the access to the database via ODBC; and storing the data manipulation definition along with the DBMS type, the DBMS host name, and the port as a meta-connection into a metadata repository. ### Claim 18 (depends on 17) The medium of claim 17, wherein the data manipulation definition is to be translated into Structed Query Language (“SQL”) upon utilization. ### Claim 19 (depends on 17) The medium of claim 17, wherein a consuming platform is to retrieve the meta-connection from the metadata repository and translate the meta-connection into the database manipulation definition to accesses the database via Java Database Connectivity (“JDBC”). ### Claim 20 (depends on 19) The medium of claim 19, wherein at least one of the abstraction engine and the consuming platform are associated with: (i) automated analytics, (ii) expert analytics, (iii) legacy automated analytics, (iv) an automated analytics kernel, (v) an automated analytics server, and (vi) a predictive factory.