Integration

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?

I am trying to build an API POST call using HTTPCaller for situations where there will be a dynamic number of parameters using the same name based on an aggregated list. In this instance, I have an attribute value called "fee id" which could have anywhere from 1-20+ items in the list (built using Aggregator) depending on how many charges were processed in a specific transaction. Each item on the list needs to be its own parameter (the values cannot be comma-separated), which is where I'm running into trouble. I can configure HTTPCaller manually to handle this, but that is only in my tests where I know ahead of time how many items will need to be processed.  I have been unable to find a way for FME/HTTPCaller to accommodate dynamically generating a query string parameter for each item in the list. Is this possible?  Even though it is not the most elegant solution, I also tried playing around with using a conditional statement for the name column (i.e., if a value in &q

I have a batch file which runs a WB nightly. It also write a log file which is great. But is there a "universal" way to control that the workbench ran successfully? Or do I have to make a script to scan the log file for key words? What key words would that be? Hopefully there is a better way?

I am trying to find a way to get the data from IFC file and import it to postGIS data. I tried to do it using a reader of IFC and a writer of postGIS, but then instead of saving 3D data - I get only 2D. When I tried changing the geometry type to geometryZ - I get "Error geometry type parsing" I tried to convert first to GML, and from GML to save to postGIS, but that also didn't work. I would appreciate some help hereThanks,Elyran  

Hello ! I use a SystemCaller in order to copy files.This files come from 2 differents folders and have to be copied from to different ways (command lines are differents) and - in addition- I want the user to choose if he wants to "copy/Y" or "Ycopy" the files.So I have 2 types of command lines from 2 publics parameters but they have the same values "Copie SANS sous-dossiers" and "Copie AVEC sous dossiers":AndSo when the user run the workbench he has 2 parameters to choose but they are named the same way:It is possible to link these 2 parameters and give the user only one parameter to choose ? Thank you !

Hello, we would like to connect a vpn connection in a workspace in order to transmit some data from our folders found on our own server to another distant server. Is this possible with FME Desktop? We use Forticlient as a remote access. Thanks!

Hi All, more or less the same as this query, but checking if anyone has any suggestions on a solution for downloading emails received to an account monitored by fme server? The email & content is used as a topic/trigger to start a workspace, i now need to also download a local copy of the email itself (eml,msg file). Is there a way to do this though fme?

Hi folks,I am getting some obscure errors (Dropbox API I assume) using the DropboxConnector with bigish files >300 mb.Looking at the error and the Dropbox community I am assuming FME is using the /2/files/upload endpoint which is limited to 300 mb. Can anyone confirm there is an upload size limit with the DropBoxConnector? Workaround?

I have been able to connect/authenticate to Dataverse with Postman by following the steps in this guide: https://docs.microsoft.com/en-us/power-apps/developer/data-platform/webapi/setup-postman-environment I have tried using the Dynamics 365 web service for this connection, but could not get it to work. I am trying to create a new web service in FME Desktop that uses the OAuth 2.0 implicit grant type to retrieve at token, as in the steps from the linked guide, but have been unsuccessful at this as well; when I try to authenticate or create a new web connection from the web service, I am unable to get the browser window/sign in prompt to appear and allow me to enter my account credentials. I am attempting to create this web service as a new Token Service, rather than a new OAuth 2.0 Service, as the parameters for this type of service seem to be what I need to enter/what I am doing with Postman.

Hi, I am trying to install FME Desktop 2020.2.4 from https://www.safe.com/support/downloads/. I would like to now if the software installed from this path is compatible with GE Smallworld. Please advice. Thank You.

Hi ,Recently we have upgraded our FME Desktop version from FME 2021 to FME 2022. Since then to Fetch data from Esri ArcGIS Portal Feature Service (Reader) is very low. Even to fetch around 10k records it takes about 10 mins, However in FME 2021 it was working very well and it takes about only few seconds only to fetch the same size of records. Is this a known issue with FME 2022?

I'm trying to use the ArcGIS Portal writer to 'update/overwrite records' in a layer. I'm using truncate and insert to remove the records before replacing them. I'm getting this error 'ArcGIS Portal Feature Service Writer: 'addResults' error for a feature in 'BranchTest.DBO.Hospitals_in_NJ'. The error code from the server was '-1' and the message was: '''. When viewing the portal item in Pro after running there are 'records' but all attributes are Null other than the Object ID. If I view the source referenced SDE layer there are no records. Any ideas?

I have a workspace which reads files from an SFTP location. I am using FTPCaller to connect to the SFTP. The credentials will change depending on the env i.e. different creds for dev, qa and prod.What is the best way to store credentials for the SFTP connection? Right now, I have these in a config file stored in Resources>Data. My workspaces reads this into a variable and then uses it to connect to the SFTP. However, this is not safe since:credentials are stored in plaintext in the config filethey also get printed in the log like every other property from that file.

I can not access views in my oracle DB neither with the oracle non-spatial reader nor with a SQLExecutor.Is there a workaround?The FME Help also talks uniquely about tables, never views.Oracle Non-Spatial Reader Parameters (safe.com)