|
IDEA
|
A few more data points... Found that the most recent MSSQL JDBC driver is 11.2. tried, failed. https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15 Noticed that I did not take a step to check or reset Classpath to the new driver. Looked around to see if I could do that. Probably not on my end in the role of "user." Maybe the Insights code goes sniffing and sets it automatically? idk. https://learn.microsoft.com/en-us/sql/connect/jdbc/using-the-jdbc-driver?view=sql-server-ver15 SQL Server 2019 Enterprise instance Is Clustered = False SQL Server 2019 Enterprise security configuration: Force Encryption = Yes Certificate unexpired, issued by parent organization service account under which instance runs has read permission on certificate Hmm. Similar? "try removing this connection string property hostNameInCertificate=*.database.windows.net" from here https://github.com/microsoft/mssql-jdbc/issues/1926 gotta get back to work. tim
... View more
10-26-2022
09:59 AM
|
0
|
0
|
3053
|
|
IDEA
|
Hi Frances, This try failed with the same error message. 2022-10-25 07:52:11,914 [qtp1463877470-31] ERROR c.e.i.s.IntegratedSecurityLogin - IntegratedSecurityLogin failed: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Tag mismatch!". ClientConnectionId:<redacted guid-looking string> I have logging all the way up and can send you the log file. tim
... View more
10-25-2022
08:08 AM
|
0
|
0
|
3082
|
|
IDEA
|
Hi Frances, The account I'm using meets the ArcGIS Insights "Without data caching" permission requirements in the database, and I use that account to connect and use data without error or warning messages via all of the clients I initially mentioned. I've tried IP address and server name and CNAME (Alias) with fully qualified domain name in the Insights database connection dialog "Server name (Fully qualified domain name)" field. The insights_service.log shows a driver getting excited about a "Tag mismatch!" here: 2022-10-21 15:25:13,719 [qtp111819772-28] ERROR c.e.i.s.IntegratedSecurityLogin - IntegratedSecurityLogin failed: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Tag mismatch!". ClientConnectionId:<redacted guid-looking string>
... View more
10-21-2022
03:52 PM
|
0
|
0
|
3132
|
|
IDEA
|
Just an idea. I'm evaluating ArcGIS Insights Desktop 2022.2.0.4957 to add to our barrel of BI products. I installed it on my workhorse PC, Windows 10 Enterprise 21H2. I tried to connect to my solid, fully functional 10.9.1.2.9 enterprise geodatabase in SQL Server 2019 Enterprise. ArcGIS Insights Desktop didn't even get past the first thing I would wanted to do. SQL Server Management Studio, Power BI Desktop, Tableau, ArcGIS Pro, ArcGIS Enterprise, ArcMap, QGIS, Excel, etc. can do it, no problem. My idea is that ArcGIS Insights could do it, too. Fastest software evaluation I've ever done. tim
... View more
10-20-2022
02:15 PM
|
1
|
9
|
3207
|
|
IDEA
|
Actually, I like my alternate idea better because it re-uses all of the layers I've published in ArcGIS Enterprise and ArcGIS Online. My Power BI customers can search/find/evaluate/get/use my data right there, and I can carry on with my ArcGIS and Tableau customers without further messing about. Of course, this approach continues to break the basic Power BI user workflow. Maybe we add "ArcGIS Online" and "ArcGIS Enterprise" to the "Get data" listing then search/find/etc.
... View more
10-12-2022
05:03 PM
|
0
|
0
|
3289
|
|
IDEA
|
Simple. Easy. Get data. As of 10/12/2022, it's not a simple matter to use Power BI to "Get data" if it is ArcGIS data or other data with a spatial column, and heaven forfend, we actually want to load that spatial column into a map visualization, join the table it's in to other tables, and color boundaries by a value column and such. It's tough. By "data" I don't mean the canned polygons from a geocoding service. I mean "our data that we need to use for our business purposes." And I'm mostly talking about polygon geometry here. After engaging in a 5-day crash course in learning "Almost All the Maps for Power BI" to support a gang of customers, it dawns on me that maybe one of the first ideas for "ArcGIS Maps for Power BI" or "ArcGIS for Power BI" should be right at "Get data", where it all starts for Power BI users. If I search for "ArcGIS", "Esri", "spatial", "location", or any key words of Esri's choice, I would expect to get a pick list along the lines of: Map service File geodatabase Enterprise geodatabase Shapefile (yes, even 30 years later. or no, I personally don't really care to use shapefiles ever again, but my customers seem to love them.) It looks like all the pieces are lurking around somewhere in my findings... Can add data from ArcGIS Online hosted feature layer via Power Automate Premium license using an ArcGIS connector to request “EsriJSON” from the hosted feature layer REST service and convert it to a CSV file that Power BI will load and which the ArcGIS Maps for Power BI visualization can render. Whew. There are so many constraints in that workflow, that it's essentially unusable for my purposes - confidential data; no external access to my ArcGIS Enterprise deployment (i.e. no Power Automate at present); leaping the fresh paywall; and why only ArcGIS Online hosted feature layers? I can squeeze the necessary "EsriJSON" out of referenced map image layers, referenced feature layers, in ArcGIS Enterprise ArcGIS Servers federated with portal and stand-alone. That little "convert to CSV file" piece appears to be the magic in the premium ArcGIS connector, so now it's on my list to go sniffing around GDAL again. I mean, ETLing that EsriJSON geometry thing is my only missing piece at the moment in the non-automated, unpleasant workflow. I've been doing GIS for some time now and have developed fortitude that most of the customers I support are too bright to develop. They don't want to follow my "I will make it work" path. They want, "It works!" Right? That's the thing. Ok, that's it. That's my idea. Get data. If the answer to this idea is, "no" because of technical constraints, strategery, or whatever, then how about an alternate idea? Power BI > ArcGIS Maps for Power BI > wrench thing > search/find/add "reference layer" Layers > ... > add "Add to Power BI" launcher that converts to CSV with geometry column so I can join and relate that with my other stuff, then get on back to the map and other visualizations. Stick it right above "Remove" maybe? tim
... View more
10-12-2022
04:56 PM
|
8
|
2
|
3291
|
|
IDEA
|
Yes, need "easy button" for adding primary data tables that include geospatial geometry columns to Power BI, much like Tableau, ArcGIS Pro, QGIS, and other geospatially capable software can do. I would love it if Esri can make this happen via the "ArcGIS Maps for Power BI" visualization thingy. There is a hint in the "ArcGIS for Power BI" documentation (https://doc.arcgis.com/en/power-bi/get-started/prepare-your-data.htm) that "EsriJSON" might be a way to do this, but I have yet to find any workable details on how to do it. Everything I've tried so far over the last several days results in, "Oh, nuh-uh," including @EricO_Neal1 's example above. I realize that Power BI does not understand SQL Server Spatial (weird, right?), so I'm hoping that Esri can provide a way to keep the data together, including coordinates. Is it really EsriJSON as the help suggests? If yes (-ish, I realize there are constraints), then how?
... View more
10-11-2022
09:40 AM
|
0
|
0
|
3764
|
|
POST
|
Yep, me too. I need to use an off-menu feature class of an organization's administrative boundaries that are not in the list of recognized boundary types that the geocoders can find and supply. I can query the hosted map service in ArcGIS online and return EsriJSON in WGS84 with all fields like this: https://services2.arcgis.com/WW3T8U6q5EkZ9U3n/arcgis/rest/services/DCYF_Service_Areas/FeatureServer/1/query?where=1=1&outFields=*&outSR=4326&geometryPrecision=5&f=json note that returnGeometry=true is the default, so no need to specify I'll note that there is no such thing as a "Shape" column in that EsriJSON above, so I'm guessing that the help documentation is referring to what Power BI perceives as the Column1.attribute.geometry column. I can tell Power BI to load JSON, then get Power Query Editor to convert it to a table thingy from which I can load that Column1.attribute.geometry (or "Shape" when I rename it) into the Location well for an "ArcGIS Maps for Power BI" visualization, which then erases the basemap, creates a white canvas, and tells me "The accuracy of your locations can be improved (hint - not by any existing Power BI map visualizations, they can't) and presents a "Go to Location Type and learn more." button. I click the button and fill out this thing, which does not seem to understand what's happening: Clicking that "OK" button results in a briefly spinning spinner. Any pointers on how to get Power BI to use an EsriJSON file (or any approach, really) for using off-menu boundaries and columns like what one would find in a SQL Server enterprise geodatabase feature class that Tableau or ArcGIS can use (i.e. WGS84, SQL Server geography spatial type) would be greatly appreciated. I'm adding this little movie that I made to show the situation and provide the trickery necessary to get EsriJSON into Power BI as a data resource.
... View more
10-10-2022
04:35 PM
|
2
|
0
|
6504
|
|
POST
|
So, one possible answer is "109 is more in September than 107 is in July". I'm good with that. I retract my question and don't care to know anything more about why. 🌎 Happy Thursday, tim
... View more
10-06-2022
01:57 PM
|
0
|
0
|
688
|
|
POST
|
In Power BI Desktop, recent release, signed into ArcGIS Enterprise 10.9.1 as Creator account in role with "make and do stuff" permissions, how do I add a layer to the ArcGIS for Power BI widgety thingy? The tool in the YouTube video here (https://www.youtube.com/watch?v=-izRcDYGR1g) does not appear in my instance of Power BI Desktop. cheers, tim
... View more
10-06-2022
11:58 AM
|
0
|
1
|
716
|
|
DOC
|
Another approach to consider if your team or your administrators have access to Microsoft Active Directory is to create an Alias (CNAME) for the machine your SQL Server is on. Something like this: IP: <current IP> Server: <current server name> Alias (CNAME): Geodata An event arises wherein you decide to migrate to a more recent SQL Server version. You complete the migration, one step being to update the Active Directory entry for your Alias(CNAME): IP: <new IP> Server: <new server name> Alias (CNAME): Geodata The change propagates across your environment after a bit, and ta-dah, stuff works just like it did when you sorted out the whole migration process in sandbox, dev, and test environments. tim
... View more
09-08-2022
09:31 AM
|
0
|
0
|
21344
|
|
IDEA
|
As a content provider, I want staff with portal accounts to be able to find descriptions of confidential content, but I do not want them to be able to access the content until after they have successfully completed a disclosure authorization process. As an example, I have a portal hosted feature layer which contains confidential records. I have written ISO-whatevs-compliant metadata. The metadata is public information. I want to share the item page description and metadata to "Organization". I want to share the feature layer records separately only to a group in which I've added accounts for authorized staff. So, I want staff to know the data exists, but I am required to make them jump through flaming hoops to get it. That's my last idea for today. No more ideas. Fresh out. tim
... View more
07-20-2022
05:01 PM
|
4
|
2
|
1062
|
|
IDEA
|
good info @jcarlson . It could work for me, but maybe not for others for whom I'm hacking a path through the underbrush. Another idea I have, but have to review a bit before posting, is that GP tools should all work consistently and as documented: alone in a ModelBuilder model in a Python script exported from a ModelBuilder model in a "from scratch" Python script I've found several situations that I think break that continuum... but for another post at some point when I have time. thanks! tim
... View more
07-20-2022
10:39 AM
|
0
|
0
|
3415
|
|
IDEA
|
I like it, @KoryKramer ! If you all can complete and release my ideas faster than I can have and post them, then I think we're where we need to be 🙂 So, I'm at ArcGIS Pro 2.9.3 and ArcGIS Enterprise 10.9.1. We don't deploy Esri dot zero releases, and it looks like AGP 3.0.x will require some planning and finagling to make the jump, so... it will be awhile. Nice, tim
... View more
07-20-2022
10:32 AM
|
0
|
0
|
3417
|
|
IDEA
|
Truncate Table GP tool would work faster than the Delete Features GP tool, and it would reset the ObjectID values instead of incrementing them from the highest number left over from Delete Features. That would surely be better. Cheers, tim
... View more
07-19-2022
05:09 PM
|
1
|
11
|
4791
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 10-24-2024 02:51 PM | |
| 1 | 10-24-2024 02:39 PM | |
| 1 | 10-22-2024 02:31 PM | |
| 1 | 02-07-2024 09:16 AM | |
| 1 | 02-07-2024 08:11 AM |