Integration

I run a process that reads out of ESRI modifies some data and writes it back into the layer. This worked in AGOL but now that we moved to OnPremise version of ArcGIS I can't get it to work. The only difference I can see after replacing the read and write nodes is that the Type field in the user attributes tab doesn't maintain its esriField Types and defaults to string.When writing back I get an error saying ObjectId is missing but this field is in the data set.

i would like to access for some data in Microsoft azure storage explorer .could i read the data directly from azure storage explorer by FME Desktop? Thanks in advance .FME Desktop 2021

I am creating a process that is going to move 3.5 million records from a SQL server db to a destination. The target can only be interacted with over SOAP. I am using a python caller to make the SOAP call because the HTTPCaller could not handle the challenge authentication method the target enforces. I am batching the rows into groups of 20,000, creating the XML and passing that to the python caller as a single feature per batch. The calls become progressively slower throughout the run of the job. They start out around 4 seconds between batches and after 130 calls the time to process is around 130 seconds.  

I have a large FME desktop workspace that works great. It reads an ArcGIS Online feature service (2 tables), joins the 2 tables, makes many, many changes (new attributes, etc.), then writes to a different ArcGIS Online feature service (1 table). I plan to run this daily with a batch file using the Task Scheduler. The destination table is published to a group of people. My issue/question is that I need 1 to 3 attributes to be reviewed. Usually a few records (out of several hundred) need to be modified. I'm sorry my question is vague. I'm thinking that there may be way to write (publish) a few attributes to a software solution to facilitate approval records after reviewing a few attributes. The few records that aren't approved would be flagged then I would manually make the change in the ArcGIS source. An example would be removing PII such as a person's name.

$ curl -X POST --noproxy “*” -k "https://server_name/connect/token" -H "Content-Type: application/x-www-form-urlencoded" -d "username=asdfg" -d "password=ghjkl" -d "client_id=CLIENT_ID" -d "client_secret=CLIENT_SECRET" -d "scopes=openid profile role" -d "grant_type=password"  

I got un expected location from pdf page formatter .Iam not sure , why .i have added the cables and the polygon to pdf page formatter .when I add only polygon ,output as expected but when I add cables and polygon .the position for polygon border changed.then write the output in Feature writer Pdf(Geo spatial )the location of ouput as unexpected fme 2021

Can we use FME Desktop for data migration from ArcFM Fiber to ArcFM enabled UNM?  Are there any workbenches similar to Electric/GAS/WATER available for Fiber Telecom ?

Hi,Microsoft SQL Server Spatial reader connects successfully to a SQL Server entreprise geodatabase however it fails to retreive spatial data,throwing this error : Microsoft SQL Server Spatial Reader: Failed to load mssql_spatial_wrapper.dll. Cannot read/write curves and full globe and may orient geography incorrectly. Ensure Microsoft System CLR Types for SQL Server 2012 and Microsoft .NET Framework 4.5.2 (or higher) and are installedMicrosoft SQL Server Spatial Reader: Microsoft System CLR Types for SQL Server 2012 is available at http://www.microsoft.com/en-ca/download/details.aspx?id=29065. Please expand 'Install Instructions' and download 'SQLSysClrTypes.msi'Microsoft SQL Server Spatial Reader: If you have confirmed that Microsoft .NET Framework 4.5.2 (or higher) is not installed, it is available at http://www.microsoft.com/en-ca/download/details.aspx?id=42643Microsoft SQL Server Spatial Reader: Schema lookup query failed for table `domain\\TableName'. Provider

When I select NTLM the workspace successfully runs on FME Desktop and FME Server with all features read as expected. When I select Kerberos, the workspace successfully runs on FME Desktop but not FME Server.  The following error is observed in FME Server: “ArcGIS Portal Feature Service Reader: Using authentication ‘Kerberos’ ”“ArcGIS Portal Feature Service Reader: Logging into ‘https://<my ArcGIS Portal host>/portal/’ as user ' ' ”"ArcGIS Portal Feature Service Reader: Could not log into https://<my ArcGIS Portal host>/portal/sharing/rest/generateToken as user ' '. Check your credentials and try again. The error code from the server was '400' and the message was: 'Unable to generate token. 'username' must be specified, 'password' must be specified." Ideally we would like to use a more secure authentication method than NTLM. ArcGIS Portal is not currently setup to use OAuth and I’ve attempted to use the other authenticati

Hello class!In the attached PDF (in Dutch) I have an example of what I want to do exactly but the example was made with the PostMan program (but I can't follow the same steps in FME). Mainly the part of obtaining the Token (access authorization to the Melvin database). I would like to know how to authenticate Melvin API via FME? In this case with HTTPCaller transformer. I already have the Melvin account (username and password), but I don't know how to use this information in HTTPCaller. I have 3 requests, 2 Post and a Get: https://keycloak.ndwcloud.nu/auth/realms/ndw/protocol/openid-connect/token (POST) https://melvin.ndw.nu/melvinservice/rest/area/all (GET) https://melvin.ndw.nu/melvinservice/rest/export (POST) My WS follows along. Does anyone have a model to share? Thanks in advance. Regards, Everton

Hello,I want to merge a jpg with a png over it.How can I replace this Paint.Net function (Merge Layer Down)?https://www.getpaint.net/doc/latest/LayersMenu.htmlThank you.

Below as a screenshot of the Revit project (what i am trying to export) followed by what i am able to convert and export into ArcMap. Missing room tags and door swings.

Using a RabbitMQConnector in Stream mode to continuously listen for change events. It is set to not Auto Acknowledge messages as we do not want that to happen until confirmation it is written to the database. Was thinking to use a FeatureWriter as it chains outputs after writing. Doing this with Transaction Type of None and it inserts/updates the features in real-time fine. But the output from the FeatureWriter seems to always be blocking. We ideally want to use that output to acknowledge the message in RabbitMQ. Would try a SQLExecutor but also need to write the shape to an ESRI geodatabase. Worst case can probably use a PythonCaller using arcpy. But would be nice to have a persistent connection with an actual writer. Any thoughts on how to do something like this while keeping a data steam going?  

Hello FME'ersWelcome to What's Up Wednesday FME User Conference NewsIf you're attending the upcoming conference, then you'll be happy to know you can now officially create your FME UC Profile & Personal Schedule online and in the mobile app!  Basically, you can see all of the sessions, mark which ones you'll be attending, browse the speaker list, look at event maps, and check out our sponsors. One event on the agenda is the FME Hackathon, 6pm-9pm on Thursday evening, and for which I'm now pleased to announce the themes:  There are 4 themes (or categories, if you prefer), and you can choose which to take part in: The Peak of Data IntegrationJust for FunFME Server AppsAugmented Reality The Peak of Data Integration is where we want to see your great ideas for Desktop functionality or projects. For example, you might make a new custom transformer or workspace to process data in a specific way. Hopefully, you'll stretch the boundaries of FME as you do. Just f

Hello I am using FME 2021.2 on an AWS machine and am connecting to an Oracle DB on-prem, but the connection is very slow. I currently have SQL Developer setup on the AWS machine and its connection to Oracle is as expected (fast). Issue:When I test the connection in FME it can take several minutes to recieve the pop-up saying 'successful connection'.I am using TNS and have setup the tnsnames.ora file I dont get any warnings or errors in the log When I use the same file for SQL Developer its response is very fastDoes anyone have any suggestions as to how to speed up that connection?

I try to retrieve Data from the Microsoft Intune MDM using OData. The OData FME Reader only supports Basic and NTLM Authentication thought and dhe OData REST API only supports OAuth so I had to resort to the HTTPCaller. This is similar to this Question I created a new Web-Service from the "Microsoft Azure Active Directory (Template)" template and extended the API Permissions in the Azure Portal for the Client App with the get_data_warehouse Permission. I already created it for the "Microsoft SharePoint Online" Web-Service (which works fine using the SharePoint Lists Reader).Authentication URL:https://api.manage.microsoft.com/get_data_warehouse" alt="https://login.microsoftonline.com/e0aedced-9266-403b-b320-a41XXXXXXX/oauth2/v2.0/authorize?scope=https://api.manage.microsoft.com/get_data_warehouse" target="_blank">https://login.microsoftonline.com/e0aedced-9266-403b-b320-a41XXXXXXX/oauth2/v2.0/authorize?scope=https://api.manage.microsoft.com/get_data_warehouse offline_access&respo

Hi.I'm exploring the possibility of making request to a secure server using FME.The webservices to be called require that the requests are accompanied by a company or function certificate. It will typically be stored in a certificate repository on the machine.I can make it work manually using HttpCaller with authentication = "Single Sign-On", but this prompts me for a certificate password every time, and the final script needs to run fully autonomously (on an FME Server).Any help is appreciated.Cheers.

Hello all, We are in the process of upgrading our software to 2021 from 2019 and I'm in the middle of UAT. I'm encountering an issue with the scripts that grab data from a Google Cloud Storage bucket using the GoogleCloudStorageConnector transformer. In 2021, when I try to reauthenticate my web connection to GCS I get this popup: I wasn't involved with the script design for the 2019 version (and my colleague who was is on vacation for another week). I did some research and found out that the stock settings for the GSC webservice need to be configured to match credentials in GSC. I created a OAuth 2.0 Client ID/Secret in the Credentials page in the GSC settings, and insert that information into the Client Information section in the GSC web service dialogue (my understanding based on documentation is that default redirect Uri here should be left untouched). After adding these credentials and applying my changes, I am still getting the same Authorization Error when I try to te

is there any way to get the data from https://www.cdc.gov/ecoli/2022/o157h7-08-22/epi.html  and This  https://www.cdc.gov/ecoli/2022/o157h7-08-22/map.html graph one or data table one ?

I have a file that has been converted from .ifc format to citygml format and I want to convert it to a shapefile. There is a problem with the coordinates and dimensions of the building. If the modeling is done, as shown in the following figure...Suggest me a set of solutions, please.?

Hi, We are creating an integration between Smallworld and FME Server. The Smallworld tool will call an FME workspace on our FME Server. The FME Server is hosted internally only and we are using built in authentication.  There is an option in FME Server to create a short lived session token via the api. I've set up a user that only has access to this repository that can be used to generate the token.  There is a second option in the Administrator interface to generate a fixed api token. When is this used? Is it more or less secure? The Smallworld developer notes that if you are using a user name and password to generate the short lived token then the risk is similar:'It seems to me that the API token with restrictions is more secure than username/password. Such a token is long and not recommended. It can be extracted from the Smallworld session and this applies for username/password.' For integration with Portal for ArcGIS we use the short lived token generated by a built in

Hello!I have trouble connecting to the Fme DataExpress app, I enter my login information, and the URL of our fme server, and it gives me this error: I would be happy to help if anyone knows the problem.Thanks!

I have merged the tables, it helped with the search but did not give me details about the specific table

Hi I am trying to merge about 15 sets containing information about green infrastructure in to one singular dissolved, multipart polygon. In ArcGIS I would use the Merge geoprocessing tool to all the the layers into one, select all the features and merge them. Finally I would do a dissolve. In FME I have fed all the input layers into a Dissolve transformer (dropping attibutes), fed the area output port to an aggregator. I am unsure what to do with remnants - I have fed Unused Areas from the remnants port to the Aggregator but not interior lines (I presume these are the dividing lines that have been removed in the dissolve?) - is this correct? Many thanks

It's a simple workflow: connect to AGOL, check for data, copy the new features to a service on internal Portal. But it's tripping me up every which way. I got the basic workflow going nicely, but it fails when I try running it via a batch file through Task Scheduler. Keeps returning an error message that it can't find the service. Same thing happened with Python which is why I'm trying FME now.I'm connecting to Portal using a OAuth2.0 web service connection but it doesn't seem to like working through Scheduler.So I thought I'd try a different authentication (tokens) and found a recently released 'ESRI Portal Token Getter' but there's no documentation to really help.Anyone have any success with it?