I am using Intersystems Cache 2018.1.4. The data is stored in Globals and from what I see the only way to get data out is by using the export tool used. However, the only file format that I seem to be able to export to is .gof files. Is there a way to export or manipulate the data to be in a more tabular readable format with the end goal of being able to perform data analysis in SQL.
How can I convert Intersystems Cache Global Objects to SQL or a more readable format?
140 Views Asked by EnYou At
1
There are 1 best solutions below
Related Questions in INTERSYSTEMS-CACHE
- Spark SQL fails with "SQLCODE: <-25>:<Input encountered after end of query>" on intersystems cache DB JDBC read
- REceiving SQL erro 37000 after attempting to run Script creating Trigger
- How can I convert Intersystems Cache Global Objects to SQL or a more readable format?
- SQL Excluding data based on certain criteria for a date range
- Setting Up the Entity Framework Provider for Intersystems Cache 2018
- Intersystems Cache not generating data with Populate
- Pyodbc on intersystems Caché int overflow
- Nesting a CAST() Function
- Get 3 most recent months (T, T-1, and T-2) in InterSys Cache DB
- SQL Query returns a negative number but does not interpret it as a negative number but a positive number
- odbc_result(): Field index is larger than the number of fields?
- Connecting Caché database in Azure function
- Why are my Greek characters being inserted in the database as question marks(?) when using parameterized queries?
- How to concatenate and format date and time to timestamp/datetime in Intersystems Caché database
- How to export class to xml without namespace?
Related Questions in INTERSYSTEMS
- Spark SQL fails with "SQLCODE: <-25>:<Input encountered after end of query>" on intersystems cache DB JDBC read
- How can I convert Intersystems Cache Global Objects to SQL or a more readable format?
- Converting Intersystems cache objectscript into a python function
- How do I check a question has been answered in TrakCare?
- Syntax to access Intersystems cache 2017.xx class properties with Python
- InterSystems ODBC error crashes Powershell
- Connecting Caché database in Azure function
- Working with different timezones with Intersystems
- Set network interface on client host to be used for Cache connections
- How can we stop journalling on InterSystems IRIS instance?
- Can SQL queries across namespaces be made?
- facing the error “command 'vscode-objectscript.explorer.refresh' not found” in Visual Studio Code (Version 1.49.0) with IRIS 2020.1.0.215.0
- Intersystems IRIS Data Platform cant change default password
- Querying data from multiple odbc connections simultaneously?
- Does Flyway support InterSystems Cache Database migration?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You have to define a persistent class that describes the global. When the class is compiled it will create a corresponding SQL table for which you can use SQL against.