Does anyone know if it is possible for gINT to generate logs using data from another SQL Database via some kind of direct link. Or to generate logs, does it have to be referencing data held in a .gpj or a Professional Plus SQL Database?
Hi Paul,
You can write a datalink to your gINT database structure that is referenced on the reports. For a simple database structure it is not to bad, for a complex database structure it would be more difficult. The program is designed to use a gINT database .gpj or a Professional Plus SQL Database and is the method optimized to work best with your data. As the program is both a database management and reporting software.
The user guide is in help. goto gINT ..Help..search Using a gINT Data Link file (how-to guide)
So it you can pull data in from an external SQL database as long as you match up the fields/tables between the foreign database and the gINT database.
The documentation then states:
gINT can now output the queried data using any report style. The output engine views the queries the same as tables. However, gINT cannot currently bring up the data in the Input or Data Design Application Groups. These capabilities will be available in a future version of the program.
When is the ability to edit the external database through gINT scheduled to be available? Or is this still currently in development?
A data link was the only way to get data from a SQL database into gINT many years ago. Data link capabilities has been around for many years 15 +... probably more. Out of that came the development of gINT Pro plus. The future capabilities mentioned in that help topic are for using a gINT SQL Pro plus database.
Thanks for letting me know Kirk.
Hello,
I'm using gINT professional plus with an upsized enterprise database on SQL express.
I am trying to build a 'Text Docs' report.
The report works fine if I query a table i.e. something like <<Count(<<POINT.PointID>>)>>
However, I cannot seem to query a view. For proof on concept I made a view of the POINT table using SQL management studio named VW_POINT
Case 1: Simple view queried using <<Count(<<VW_POINT.PointID>>)>>
Case 2: view with schema binding i.e. dbo.VW_POINT queried using <<Count(<<VW_POINT.PointID>>)>>
Case 3: view with schema binding i.e. dbo.VW_POINT and unique index on GintRecID queried using <<Count(<<VW_POINT.PointID>>)>>
Case 4: view with schema binding i.e. dbo.VW_POINT and unique index on GintRecID and unique clustered index on (gINTProjectID, PointID) queried using <<Count(<<VW_POINT.PointID>>)>>
None of the above cases are returning results.
So my question is can we build reports by querying views? If so any pointers would be appreciated.
Final point, I noted there is a view generated in the gINT enterprise database called dbo.gINT_GIS so i am guessing that is used by GIS tools and not queried by gINT professional plus?
Thank you and kind regards
James
Discovered the SQL wrapper.
This works: <<Sql(Select count([VW_POINT].[PointID]) FROM [VW_POINT])>>