You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »



TicketTopicStatusShort DescriptionText
6557611 Cornell Metadb: request to run automated process to update a table with ERM dataopenrequest to set up a process where hosting team obtains our quarterly EBSCO Consolidated Platform reports in CSV format and run a script we have to append the data to a table in the Cornell Metadb reporting database. The reports are the Title Usage Details reports. The contact for this file is Ashley Murry at EBSCO.

This is the platform for the files: : https://eadmin.ebscohost.com/

Hi Sharon,

I wanted to follow up on my previous email.

This response was sent from EBSCO's case management system, so when replying, please use the "Reply" button and respond directly to this email to ensure your response is received and documented in this case.

Thank You,

Sara Lewis

Technical Support Representative II


From: Sara Lewis <auto-response@ebsco.com>
Sent: 3/30/2026 9:00 am GMT-04:00
To: Sharon Markus (slm5@cornell.edu)
Subject: RE: Cornell Metadb: request to run automated process to update a table with ERM data

Hi Sharon,

I wanted to follow up on my previous email.

This response was sent from EBSCO's case management system, so when replying, please use the "Reply" button and respond directly to this email to ensure your response is received and documented in this case.

Thank You,

Sara Lewis

Technical Support Representative II


From: Sara Lewis <auto-response@ebsco.com>
Sent: 3/25/2026 3:41 pm GMT-04:00
To: Sharon Markus (slm5@cornell.edu)
Subject: RE: Cornell Metadb: request to run automated process to update a table with ERM data

Hi Sharon,

Thank you for contacting EBSCO Technical Support.

We are currently reviewing the details and would appreciate a bit more information to understand better how this might be implemented. Specifically:

  • You mentioned that a similar automated process is already running on a weekly basis. Could you share how and where that process is set up?
  • Do you know if your team is hosting and managing your own MetaDB instance?
  • Additionally, could you clarify where you would expect the quarterly script to be executed?

From our initial review, this request appears to be related to processes outside of FOLIO itself and may involve configurations within your MetaDB environment.

Understanding your current setup will help us determine the best way to guide you.

This response was sent from EBSCO's case management system, so when replying, please use the "Reply" button and respond directly to this email to ensure your response is received and documented in this case.

Thank You,

Sara Lewis

Technical Support Representative II


From: Sharon Markus <slm5@cornell.edu>
Sent: 3/24/2026 1:55 pm GMT-04:00
To: Web Service (crmwebsvc@epnet.com)
Subject: Cornell Metadb: request to run automated process to update a table with ERM data

Hosting Team,
We are wondering if you can set up a process where you obtain our quarterly EBSCO Consolidated Platform reports in CSV format and run a script we have to append the data to a table in the Cornell Metadb reporting database. The reports are the Title Usage Details reports. The contact for this file is Ashley Murry at EBSCO.

This is the platform for the files: : https://eadmin.ebscohost.com/

We have another automated process running weekly, and so we are hoping this is manageable on a quarterly basis.

All the best,
Sharon Markus


6579786 Cornell Metadb: please update user access to local_eusage schemacompletegrant Tom Trutt read-write access to local_eusage schema
6557469Cornell Metadb: please create new "local_erm" schemacompletecreated and name was changed to local_eusage schema
6563751 Cornell Metadb: indexing questioncompleteowners of tables in Postgresql can index them

Text of 6563751


Thank you for contacting EBSCO.

Your EBSCO Customer Support Case Number and Title are: 6563751 - "SI 4758546 | Cornell Metadb: indexing question".
_________________________________________________________________

Hello Sharon,

I have received the following update from the hosting team:

In PostgreSQL, you must be the table owner (or a superuser) to create an index on a table.

There is no separate GRANT permission (such as GRANT INDEX) that allows a non-owner to add an index.

Since Sharon is the owner of local_derived.marc__t table, she will be able to create an index for it.

Table folio_source_record.marc__t is owned by metadb_user account (whichh is the account which the metadb service runs as )
Only metadb_user or the superuser in postgresql would be allowed to create indexes for this table.

We would suggest discussing any new indexing with the metadb developers before making adjustments to any tables which are owned by metadb
(folio_source_record.marc__t )

Please let me know if you have any questions.

Cameron Viveiros
FOLIO Customer Account Specialist
EBSCO Information Services
978-414-0645
cameronviveiros@ebsco.com

This message and its contents are confidential. If you received this message in error, do not use or rely upon it. Instead, please inform the sender and then delete it.


--- Original Message ---
Hi Hosting Team,
We have been having trouble with the folio_source_record.marc__t table, so we set up a query to recreate this table in the local_derived schema. The table works, but queries against it run slowly. I would like to try indexing the table to improve performance. Is it possible for me to index tables with the permissions I currently have on my z_slm5 user account for our Metadb reporting database, or is this something you would need to add?
All the best,
Sharon



6455456 Cornell Metadb: MARC _ _ t table issue: Multiple srs IDs associated with same instance IDunresolved

 

 6390448  Cornell Metadb: connection via Power BI Desktop failingunresolved


Thank you for contacting EBSCO.

Your EBSCO Customer Support Case Number and Title are: 6390448 - "SI 4404657 | Cornell Metadb: connection via Power BI Desktop failing".
_________________________________________________________________

Hello Sharon,

I've found someone with a similar issue online, which they solved. Here is the issue:
https://community.fabric.microsoft.com/t5/Desktop/The-remote-certificate-is-invalid-according-to-the-validation/m-p/532504#M249591

Solution:
https://community.fabric.microsoft.com/t5/Desktop/The-remote-certificate-is-invalid-according-to-the-validation/m-p/532504#M249591

Cameron Viveiros
FOLIO Customer Account Specialist
EBSCO Information Services
978-414-0645
cameronviveiros@ebsco.com

This message and its contents are confidential. If you received this message in error, do not use or rely upon it. Instead, please inform the sender and then delete it.

--- Original Message ---
Hi Cameron,

I tried the settings you mentioned and was not able to successfully connect to Metadb from PowerBI on my computer that has a static IP address that is whitelisted for use with Cornell's Metadb reporting database.


I am attaching the specific login configurations I tried as a Word document.


Any other ideas?


All the best,

Sharon



  


  


  


  








  • No labels