![]() ![]() Create an XML Connection that points to the schema.xml file Reference Files: jsonFile.json, schema.xmlĥ. You may need to edit the schema.xml file so that the file path reflects your deployment path. Save the agentconfig.xml file, and re-start the Agent.Ĥ. Save the schema.xml file to the same directory location as the sample JSON data file. .//QuerySurge/agent/config/agentconfig.xmlĮdit the agentconfig.xml file for each Agent, by adding the following driver property:ģ. \\.\\QuerySurge\agent\config\agentconfig.xml Reference File: stels_xml_extension_v2.0.zipĢ. Stop your Agent(s), and make a copy of the agentconfig.xml file, located at: Note: You most likely will need Administrative rights to perform this setup.ġ. Download stels_xml_extension_v2.0.zip from the References at then end of this article and extract the stels_xml_extension.jar, commons-io-2.4.jar, and json-20090211.jar files and deploy them to each QuerySurge Agent's jdbc directory, located at: The following example shows how to set up automated conversion and querying of JSON via conversion to XML so that the whole process executes from QuerySurge like any other QuerySurge run. In order to put JSON documents in a "SQL-queryable" format for QuerySurge, the strategy shown here is to convert JSON to XML, so that QuerySurge's XML JDBC driver can be used to query for the data. For full details, see this article.Ī JSON to XML Conversion Strategy using the XML JDBC Driver Note: For a direct connection to your JSON files (avoiding the overhead of the conversion described in this article), you may want to consider the CData JSON JDBC driver (a commercial JDBC solution). This article describes a strategy for testing JSON data by automatically converting JSON to XML and testing the resulting XML using an XML JDBC driver. QuerySurge user users frequently have a need to use QuerySurge with JSON documents as a data Source or Target, as JSON has become a common data exchange format for a variety of technologies, most prominently in NOSQL databases. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |